You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）

A、 The backup metadata will be maintained in the control file for 100 days.

B、 The backup metadata will be maintained in the recovery catalog for 100 days.

C、 The backup metadata will be maintained in the flash recovery area for 100 days.

D、 After 100 days， the backup sets and image copies will be deleted from the media.

相关问题推荐

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A、 MMAN

  B、 PMON

  C、 MMON

  D、 MMNL

  查看答案

• You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

  A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.

  B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.

  C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.

  D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.

  查看答案

• In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

  A、REBUILD

  B、CASCADE

  C、TRUNCATE

  D、ROW MOVEMENT

  E、SHRINK SPACE COMPACT

  F、SHRINK SPACE CASCADE

  查看答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A

   The DBWn process writes to the datafile.

  B

   Changes in the background process are recorded.

  C

   The log file is updated with the current SCN number.

  D

   The System Change Number （SCN） is recorded in the control file.

  E

   The changes to the listener configuration in the listener.ora file are recorded.

  查看答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  A

  SYSDATE should not be used with TIMESTAMP.

  B

  The database must have multiplexed redo log files.

  C

  The database must be in the MOUNT state to execute the command.

  D

  The database must be opened with the RESETLOGS option after the flashback operation.

  E

  The entire database needs to be restored from the most recent backup before the flashback operation.

  查看答案