出自:Oracle认证

You need to change the hostname and IP address of a server. Without manually editing all of the required files， which command can be run to restore a system configuration to an unconfigured state， ready to be reconfigured again restore a system configuration to an unconfigured state， ready to be reconfigured again？ （）
A: /usr/sbin/sys-unconfig
B: /usr/sbin/unconfig
C: /sbin/ipconfig
D: /usr/sbin/set_parms initial
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）
A:Inactive and current redo log files are required to accomplish recovery.
B:Online and archived redo log files are required to accomplish instance recovery.
C:All redo log entries after the last checkpoint are applied from redo log files to data files.
D:All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
What is the implication of this command?（）
A:The command produces an error because the retention time cannot be reduced. 
B:All historical data is retained but the subsequent flashback data archives are maintained for only three years. 
C:All historical data is purged and the new flashback data archives are maintained for three years. 
D:All historical data older than three years is purged from the flashback archive FLA1. 
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  
A: V$SYSSTAT
B: V$SESSSTAT
C: V$RSRC_PLAN
D: V$RSRC_CONSUMER_GROUP
Given： Which two code fragments， inserted independently at line 3， generate the output 4247？ （）
A:String s = "123456789";s = (s-"123").replace(1,3,"24") - "89";
B:StringBuffer s = new StringBuffer("123456789");
C:sdelete（0，3）.replace（1，3，"；24"；）.delete（4，6）；
D:substring（3，6）.delete（1，3）.insert（1，&ensp；"；24"；）；
You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed.  What would be the appropriate order of operations to correct the situation？（）   a. Mount the database with the startup mount command.  b. Take the SYSTEM datafile offline with the alter database command.  c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command.  f. Issue the recover datafile SYSTEM_01.dbf command.  g. Open the database with the alter database open command.  h. Open the database with the alter database open resetlogs command.
A:a， c， f， g
B:b， d， e， h
C:a， b， c， f， g
D:d， a， e， g
E:b， c， f， e， g
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）
A:You can conned as a common user by using the connect statement.
B:You can connect as a local user by using the connect statement.
C:You can connect by using easy connect.
D:You can connect by using OS authentication.
E:You can connect by using a Net Service name.
F:You can connect as a local user by using the SET CONTAINER statement.
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）
A:SMON would automatically restore the lost file.
B:You would need to restore the whole database from the last backup.
C:You would need to restore the file from the last full database backup.
D:You would need to use flashback technology to restore the lost redo log member.
E:You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
F:You would need to restore the missing log file by copying one of the remaining files from the same group.
Given： What is the result？（）
A:Canada
B:null Canada
C:Canada null
D:Canada Canada
E:Compilation fails due to an error on line 26.
F:Compilation fails due to an error on line 29.
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
A:Information about each Oracle Net connection.
B:Information about each entry in theLinstener.orafile
C:Information about the changed done in the database
D:Information about the different listeners in your system
E:Information about all thenondatabasefiles required to operate the database
You are doing an environment assessment for a client that has invested in Oracle RAC for fault tolerance， load balancing， and scalability. The client also invested in clustered Oracle WebLogic Server. You notice that this client’s environment is not integrated for active-active high availability deployment of applications.  What will be your recommendation to achieve that ？ （）
A: MetaLink to RAC
B: ClusterLink to RAC
C: TopLink to RAC
D: GridLink to RAC
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）
A: space allocated in the tablespace
B: space required for the bitmap index on a column of the table
C: space remaining in the tablespace after creating the table
D: estimated value of the PCTFREE storage parameter
You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）
A:use enterprise manager
B:use DBMS_SQL package
C:use DBMS_AWR package
D:use PRVT_WORKLOAD package
E:query the AWR snapshot repository objects
F:use DBMS_WORKLOAD_REPOSITORY package
Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）
A:set SHARED_POOL_SIZE to zero
B:set STATISTICS_LEVEL to BASIC
C:set SGA_TARGET to a non-zero value
D:set DB_CACHE_SIZE to a non-zero value
E:set STATISTICS_LEVEL to TYPICAL or ALL
下列哪个操作可以将表中的数据删除，并且不需要回滚删除后回收其所占有的空间，但表定义保留（）
A:DELETE FROM EMP;
B:TUNCATE TABLE EMP;
C:TUNCATE TABLE EMP REUSE STORAGE;
D:DROP TABLE EMP;
E:以上所述都不正确
Select three true statements regarding Coherence（）
A: Coherence provides stronger data management than an Application Server
B: Coherence provides better scale-out performance than a Application Server
C: Coherence provides better scale-out performance than a Database Server
D: Coherence provides better througput than a JMS messaging server Coherence provides stronger configuration management than Grid Control
下面的函数，（）用于返回时区信息。
A:zone（）
B:date（）
C:dbtimezone（）
D:time（）
What does it mean if a backup is expired?（）
A:The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. 
B:The backup set has one or more invalid blocks in it and is not usable for recovery. 
C:The backup set contains one or more tablespaces no longer in the database.  
D:The backup set contains one or more missing backup set pieces.
E:The backup set is from a previous version of RMAN and was not upgraded. 
Which two statements about the SQL Management Base （SMB） are true？（） 
A: It contains only SQL profiles generated by SQL Tuning Advisor.
B: It stores plans generated by the optimizer using a stored outline.
C: It is part of the data dictionary and stored in the SYSAUX tablespace.
D: It is part of the data dictionary and stored in the SYSTEM tablespace.
E: It contains the statement log，the plan history，plan baselines，and SQL profiles.
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）
A: True
B: False
You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）  
A: The online redo log file Is not allowed to be overwritten.
B: The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
C: The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
D: The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）  
A: Recover the online redo log from backup.
B: Delete and re-create the log file.
C: Use the alter database clear logfile command to clear the log file.
D: Shut down the database and restart it.
E: Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）  
A: The plan baselines are verified with the SQL profiles.
B: All fixed plan baselines are converted into nonfixed plan baselines.
C: All the nonaccepted SQL profiles are accepted into the plan baseline.
D: The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
A: You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
B: You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C: You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
D: You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）  
A: It will create the tablespace TEMP1 in group G1.
B: It will create the tablespace TEMP1 in group G3.
C: It will not add the tablespace TEMP1 to any group.
D: It will create the tablespace TEMP1 in the default group.
当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）
A:SYSTEM和MANAGER
B:SYS和SYSTEM
C:SYS和SYSMAN
D:ROOT和SUPERMAN
E:SCOTT和TIGER
Which RMAN backup command is used to create the block-change tracking file？（）  
A: alter database create block change tracking file
B: alter database enable block change file
C: alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.fil
D: alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
E: alter system block change tracking on
创建基于函数的索引时必须具有（）权限。
A:Query Rewrite系统权限
B:创建Synonym的权限
C:创建public Synonym的权限
D:创建Sequence的权限
Which two statements about sequences are true? （）
A:You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
B:You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
C:You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
D:You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
E:If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
F:You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）
A:It will display a list of files that need incremental backup
B:It will display a list of files that need backup after five days
C:It will display a list of files that were backed up in the last five days
D:It will display a list of files that have not been backed up in the last five days
E:It will apply the current retention policy to determine the files that need to be backed up
首页 <上一页 23 24 25 26 27 下一页> 尾页