网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
A
The database would open normally.
B
The database would not open， and it would stop at mount stage.
C
The database would open after automatically performing instance recovery.
D
The database would not open， and you have to perform database recovery to open it.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A The database would open normally.B The database would not open， and it would stop at mount stage.C The database would open after automatically performing instance recovery.D The database would not open， and you have to perform database recovery to open it.” 相关考题
考题
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state， but all the background processes will be restarted.
考题
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
考题
You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid， so would have to be aborted.D、The instance would remain open， but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file
考题
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure
考题
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A、The database would open normally.B、The database would not open， and it would stop at mount stage.C、The database would open after automatically performing instance recovery.D、The database would not open， and you have to perform database recovery to open it.
考题
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（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
考题
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（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked
考题
Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）A、The database remains open.B、The database gets dismounted.C、The database becomes read only.D、The database instance gets aborted.E、The database gets shut down automatically.F、The status of the database depends on the status of the USERS tablespace.
考题
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？（）A、Execute the ALTER DATABASE ARCHIVELOG statementB、Select ARCHIVELOG option in the database control and restart the database to apply the changes.C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
考题
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？（）A、Shut down the instance， copy the control file to the third location and open the database.B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.E、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.
考题
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A、 clear the redo log groupB、 perform redo log file importC、 perform an incomplete recoveryD、 perform a redo log recovery using Recovery Manager （RMAN）E、 shut down the database and open the database in the NOARCHIVELOG mode
考题
Examine the following scenario： -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure？（） A、 Restore the latest whole backup，perform complete recovery，and open the database normally B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the RESETLOGS option.C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.
考题
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）A、Execute the ALTER DATABASE ARCHIVELOG statement B、Select ARCHIVELOG option in the database control and restart the database to apply the changes. C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
考题
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？（）A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）A、The backups would be consistent. B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure.
考题
单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A
The instance would normally abort.B
The instance would not be affected.C
The instance would be invalid， so would have to be aborted.D
The instance would remain open， but the LGWR process would fail.E
The instance would remain open and would automatically create the missing file
考题
多选题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（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.
考题
单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A
The instance would hang.B
The instance needs to be shut down.C
The instance would be in the open state.D
The instance would abort in such cases.E
The instance would be in the open and invalid state.F
The instance would in the open state， but all the background processes will be restarted.
考题
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
考题
单选题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？（）A
Start the instance and open the database， instance recovery automatically recoverscontrol filesB
Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC
Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）D
Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E
Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
考题
单选题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？（）A
Start the instance and open the database, instance recovery automatically recovers control files B
Create a file based on the contents of the trace file and save it to the control file locations and start the database C
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A
clear the redo log groupB
perform redo log file importC
perform an incomplete recoveryD
perform a redo log recovery using Recovery Manager （RMAN）E
shut down the database and open the database in the NOARCHIVELOG mode
考题
单选题Examine the following scenario： -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure？（）A
Restore the latest whole backup，perform complete recovery，and open the database normally B
Restore the latest whole backup，perform incomplete recovery，and open the database with the RESETLOGS option.C
Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.D
Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.
考题
多选题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（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
多选题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？（）AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
热门标签
最新试卷
