单项选择题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
A. Query the V$FLASHBACK_DATABASE_LOG view.
B. Query the V$FLASHBACK_DATABASE_STAT view.
C. Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
D. Query the V$RECOVERY_FILE_DEST view.
相关考题
-
多项选择题
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
A. when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B. when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C. when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D. when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E. never， because FLASHBACK TABLE is not a valid command in Oracle 10g. -
单项选择题
You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）
A. The sort area is very small.
B. There is no more space in the Undo tablespace.
C. The flash recovery area is full.
D. The online redo log file is full. -
多项选择题
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
A. DB_CREATE_FILE_DEST
B. DB_RECOVERY_FILE_DEST
C. DB_RECOVERY_FILE_DEST_SIZE
D. DB_ONLINE_LOG_DEST_n
