单项选择题
You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）
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 -
单项选择题
WhichbackgroundprocesssequentiallywritesFlashbackDatabasedatafromtheflashbackbuffertotheFlashbackDatabaselogs？（）
A. DBWn
B. RECO
C. RVWR
D. LGWR -
单项选择题
YouaremanagingasingleinstanceOracle10gdatabasethatutilizesthefollowingparameters：WhichofthefollowingsetofcommandsmustyouexecutetoenableFlashbackDatabase？（）
A. STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
B. STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
C. STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
D. STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
