Youplantotakeacloseddatabasebackupusingoperatingsystemcommands.WhichthreeSHUTDOWNoptionsareappropriateforthistypeofbackup?()
ABORT
B. NORMAL
C. IMMEDIATE
D. TRANSACTIONAL
Youareattemptingtoclearanunarchivedredologfile.Inordertomanuallyenactalogswitch,whichofthefollowingstatementsisappropriate?()
ALTERDATABASE
B. ALTERSYSTEM
C. ALTERUSER
D. ALTERREDOLOG
Inwhichthreecasesdoesacheckpointoccur?()
A. Everythreeminutes.
B. Whenalogswitchoccurs.
C. Whenforcesbyanadministrator.
D. Whenatablespaceistakenofflinenormal.
E. Whentheredobufferisone-thirdfull.
WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()
A. TARGET_REDO_BLKS
B. FAST_START_IO_TARGET
C. LOG_CHECKPOINT_TIMEOUT
D. RECOVERY_ESTIMATED_IOS
E. LOG_FILE_SIZE_REDO_BLKS
F. LOG_CHECKPOINT_INTERVAL