7, 1, 5, 2, 3, 6, 4
1, 2, 3,7, 5, 6, 4
7, 1, 4, 5, 2, 3, 6
1, 7, 5, 4, 2, 3, 6
第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题:
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?()
第3题:
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?()
第4题:
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()
第5题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第6题:
Shut down the instance, copy the control file to the third location and open the database.
Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.
Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.
第7题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第8题:
7,1,5,2,3,6,4
1,5,7,2,3,6;step 4 is not required
7,1,5,2,3,6;step 4 is not required
1,2,3,5,6,4;step 7 is not required
第9题:
Start the instance and open the database, instance recovery automatically recovers control files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第10题:
The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
Before the instance starts, you receive an error about the missing redo log files of a group.
The instance starts and the database opens with an error message written to the alert log file.
The instance starts and the database opens because two redo log groups still exist.
The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
第11题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第12题:
7,1,5,2,3,6,4
1,2,3,7,5,6,4
7,1,4,5,2,3,6
1,7,5,4,2,3,6
第13题:
You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are opened. 4:Instance recovery is started. 5:Background processes are started. 6:Data file headers are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
第14题:
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()
第15题:
You work as a database administrator for Certkiller .com. 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?()
第16题:
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
第17题:
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
第18题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第19题:
Start the instance and open the database, instance recovery automatically recoverscontrol files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第20题:
7, 1, 5, 2, 3, 6, 4
1, 2, 3,7, 5, 6, 4
7, 1, 4, 5, 2, 3, 6
1, 7, 5, 4, 2, 3, 6
第21题:
7, 1, 5, 2, 3, 6, 4
1, 5, 7, 2, 3, 6; step 4 is not required
7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from =>> http://www.amaderforum.com
1, 2, 3, 5, 6, 4; step 7 is not required
第22题:
7, 1, 5, 2, 3, 6, 4
1, 5, 7, 2, 3, 6; step 4 is not required
7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from =>> http://www.amaderforum.com
1, 2, 3, 5, 6, 4; step 7 is not required
第23题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery