单项选择题
In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()
A. when all the online redo log groups are multiplexed and one of the members of a group is missing
B. when all the online redo log groups are not multiplexed and one log group is missing
C. when all the control files are missing
D. when some important tables are deleted from the database and purged from the Recycle Bin
相关考题
-
单项选择题
YouareperforminganincompleterecoverybecausesomeimportanttableshavebeendroppedandpurgedfromtheRecycleBin.WhichclausecanyouNOTusetoperformtheincompleterecoverybyusingtheRMANutility?()
A. UNTIL CANCEL
B. UNTIL SCN
C. UNTIL SEQUENCE
D. UNTIL TIME -
单项选择题
YouaremaintainingyourdatabaseinOracle10g.Youareperforminganincompleterecoverybecausethetablespace,DATA1,wasdroppedandpurgedfromtheRecycleBin.Afterperforminganincompleterecovery,youopenthedatabasewiththeRESETLOGSoption.WhatwillNOTbetheimpactofusingtheRESETLOGSoption?()
A. The log sequence for the database will restart from 1.
B. The log sequence number will be written to the control file.
C. The log sequence number will be written to the datafile headers.
D. The log sequence number will be written to the initialization parameter file. -
单项选择题
Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?()
A. The control file will be multiplexed.
B. The control file will be recreated.
C.The script containing the CREATE CONTROLFILE statement will be created.
D. The binary backup of the control file will be created.
