多项选择题
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）
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. -
单项选择题
YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）
A. ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
B. ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
C. ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
D. ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’； -
单项选择题
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）
A. V$DATABASE
B. V$FLASHBACK_DATABASE_STAT
C. V$FLASHBACK_DATABASE_LOG
D. V$RECOVERY_FILE_DEST
