单项选择题

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.

单项选择题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

单项选择题Thecustomerandordertablesareoftenusedinjoins，therebyresultingincomplexqueries.Youcreatedviewstosimplifythewritingofqueries.Theseviewsarestoredin（）.

A.user tables
B.view segment
C.table segment
D.data dictionary
E.object segment
F.performance tables