All control files are opened
All redo files are opened
The password file is opened
The parameter file is opened
All online data files are opened
第1题:
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第2题:
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
第3题:
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
第4题:
After the recovery is complete, which command should you execute?()
第5题:
You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()
第6题:
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第7题:
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
第8题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
第9题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第10题:
our database is in the MOUNT state and you execute the following command to open it: ALTER DATABASE OPEN What two actions are performed as a result of this command?()