单项选择题
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
相关考题
-
单项选择题
InwhichscenariowillyouusetheFlashbackVersionQueryfeature？（）
A. when you want to restore a table that has been dropped from the Recycle Bin
B. when you want to identify the transaction ID of the transaction that deleted some important records from a table
C. when you want to recover the schema of a dropped user
D.when you want to restore a dropped tablespace -
单项选择题
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）
A. V$FLASHBACK_DATABASE_LOG
B. V$FLASHBACK_DATABASE_STAT
C. V$DATABASE
D. V$UNDOSTAT -
单项选择题
YouhavejoinedaneworganizationasaDatabaseAdministrator.TheSecurityAdministratorinyourorganizationhaskepthumanerrors，suchaserroneouslydroppingusers，tables，andimportantdata，toaminimumbycarefullygrantingonlythenecessaryprivilegestoeachuser.Asaresultofseveralongoingtransactionswithinyourdatabase，youdiscoverthattheflashbacklogsarerapidlyincreasingintheflashrecoveryarea.Toavoidout-of-spaceerrors，youdecidetodeletetheflashbacklogsfromtheflashrecoveryarea.Howcanyoudeletetheflashbacklogsfromthedatabaseifyourdatabaseisupandrunning？（）
A. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
B. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
C. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
D. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
