网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
In which of the scenarios will the DBA perform recovery（）
A
The alert log file is corrupted.
B
A tablespace is accidentally dropped.
C
One of the redo log members is corrupted.
D
A database user terminates the session abnormally.
E
The hard disk on which the data file is stored is corrupted.
参考答案
参考解析
解析：
暂无解析
更多 “多选题In which of the scenarios will the DBA perform recovery（）AThe alert log file is corrupted.BA tablespace is accidentally dropped.COne of the redo log members is corrupted.DA database user terminates the session abnormally.EThe hard disk on which the data file is stored is corrupted.” 相关考题
考题
Which of the following statements is NOT true about RMAN？（）A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations， with only full database backups.
考题
Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）A、1， 3， and 6B、4， 5， and 6C、3， 4， and 5D、1， 2， and 6
考题
You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A、 Whole databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs
考题
Which of the following is needed to perform an ASR restore in Windows XP?（）A、Operating system CDB、Recovery consoleC、Vendor recovery CDD、ERD disk
考题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A、The database crashes.B、The DBA needs to re-create the file.C、The file gets re-created automatically.D、The file gets restored automatically from the last backup.E、The DBA needs to perform a complete database recovery.F、The DBA needs to perform an incomplete database recovery.
考题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
考题
You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）A、 MOUNT modeB、 RESTRICTED modeC、 OPEN modeD、 NOMOUNT mode
考题
You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario？（）A、You must ensure that the SALES database is mounted or open.B、You must restore a backup control file to perform a block media recovery.C、You must take the tools01.dbf data file offline before you start a block media recovery.D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of individual data blocks is not supported.
考题
单选题Which of the following is needed to perform an ASR restore in Windows XP?（）A
Operating system CDB
Recovery consoleC
Vendor recovery CDD
ERD disk
考题
单选题Which of the following statements is NOT true about RMAN？（）A
It improves usability by enabling you to reuse the scripts to perform recovery operations.B
It detects block corruption while restoration and recovery operations.C
It enables you to perform block media recovery.D
It is capable to recover through unrecoverable operations， with only full database backups.
考题
单选题You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A
The database crashes.B
The DBA needs to re-create the file.C
The file gets re-created automatically.D
The file gets restored automatically from the last backup.E
The DBA needs to perform a complete database recovery.F
The DBA needs to perform an incomplete database recovery.
考题
单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A
control fileB
password fileC
listener controller fileD
control file and password file
考题
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
考题
单选题Given below is a list of scenarios： 1）A user terminates his session abnormally. 2）The connection between the server and the client application terminates because of a network failure. 3）A schema is accidentally dropped. 4）The tablespace is accidentally dropped from the database. 5）The hard disk gets corrupted and the data files in the disk are lost. 6）The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery（）A
4 and 5B
1，3，and 6C
4，5，and 6D
3，4，and 5E
1，2，and 6
考题
单选题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 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 are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A
Whole databaseB
TablespacesC
DatafilesD
Archive logsE
Redo logs
考题
单选题Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）A
1， 3， and 6B
4， 5， and 6C
3， 4， and 5D
1， 2， and 6
考题
单选题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
考题
单选题Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object？（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D
Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
考题
单选题You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）A
MOUNT modeB
RESTRICTED modeC
OPEN modeD
NOMOUNT mode
考题
多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs
考题
多选题In which of the scenarios will the DBA perform recovery（）AThe alert log file is corrupted.BA tablespace is accidentally dropped.COne of the redo log members is corrupted.DA database user terminates the session abnormally.EThe hard disk on which the data file is stored is corrupted.
考题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
单选题To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）A
OPENB
MOUNTC
NOMOUNTD
CLOSE
热门标签
最新试卷
