You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

A、 DB_RECOVERY_FILE_DEST only

B、 DB_FLASHBACK_RETENTION_TARGET only

C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only

D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only

E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and

F、 DB_FLASHBACK_RETENTION_TARGET

相关问题推荐

• 下列选项中不符合良好程序设计风格的是()。

  A．源程序要文档化

  B．数据说明的次序要规范化

  C．避免滥用goto语句

  D．模块设计要保证高耦合、高内聚

  查看答案

• In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

  A

   The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

  B

   The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

  C

   The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

  D

   If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

  E

   Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看答案

• You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

  A、back up the control file to trace

  B、bring database to the MOUNT state

  C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

  D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

  查看答案

• You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

  A、 The statement will fail.

  B、 The statement will be executed successfully， and the new time zone will be set for the database.

  C、 The statement will be executed successfully， but the new time zone will be set for the current session.

  D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

  查看答案

• You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）

  A、 Oracle Enterprise Manager

  B、 The V$LOG view

  C、 The V$LOGFILE view

  D、 The V$FLASHBACK_DATABASE_LOGS view

  查看答案