单项选择题
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
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. -
单项选择题
UsersinyourPRODdatabasecomplainabouttheslowresponseofthetransactions.Whileinvestigatingthereason，youfindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）
A.increase the undo retention
B.create more undo segments
C.create another undo tablespace
D.increase the size of the undo tablespace
