多项选择题
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 -
单项选择题
YouaremaintaininganOLTPdatabaseinOracle10g.YouhaveconfiguredtheFlashRecoveryAreainyourdatabase.TheFlashRecoveryAreaisfullbecauseyouhavesettheretentionpolicytoNONE.Whatwillyoudotoresolvetheproblem？（）
A. Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B. Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D. Increase the value of the SGA_TARGET initialization parameter.
