單項(xiàng)選擇題

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；

你可能感興趣的試題

單項(xiàng)選擇題

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.

單項(xiàng)選擇題

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

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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？（）

你可能感興趣的試題

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？（）

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？（）

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？（）