单项选择题
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
A.RECOVER LOGFILE BLOCK GROUP 2；
B.ALTER DATABASE DROP LOGFILE GROUP 2；
C.ALTER DATABASE CLEAR LOGFILE GROUP 2；
D.ALTER DATABASE RECOVER LOGFILE GROUP 2；
E.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
相关考题
-
单项选择题
Youareusingthefollowingcommandtoclearthelogfilegroup：ALTERDATABASECLEARLOFFILEGROUP2；Inwhichcasewouldthecommandbesuccessful？（）
A.Group 2 is the active group.
B.Group 2 is the current group.
C.Database is in the MOUNT state.
D.Group 2 has been already archived. -
单项选择题
You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces， and dropped a couple of tablespaces. This morning， due to hardware failure， you lost all your control files. How would you recover the database from this situation？（）
A.A
B.B
C.C
D.D
E.E -
单项选择题
IntheinstanceofthePRODdatabase，thecheckpoint（CKPT）processrunsaftereveryminute.AdatabaseuserupdatestherowsoftheORDERStable.Becauseoftheconfiguration，theCKPTprocessgetsinitiatedbeforetheusercommitsthetransaction.WhatwouldhappentothemodifiedblockswhentheCKPTprocessisstarted？（）
A.The modified blocks would be written to the data files.
B.The modified blocks would be written to the temp files.
C.The modified blocks would be written to the control file.
D.The modified blocks would be written to the redo log files.
E.The modified blocks would be written to the archived redo log files.
F.The modified blocks would be retained in the database buffer cache.
