failures because a data file is renamed by error
failures when no standby database is configured
failures that require no archive logs to be applied for recovery
failures due to loss of connectivity-for example, an unplugged disk cable
第1题:
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第2题:
Which two activities are NOT supported by the Data Recovery Advisor?()
第3题:
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist()
第4题:
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第5题:
In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?()
第6题:
Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? ()
第7题:
Which two activities are NOT supported by the Data Recovery Advisor (DRA)()
第8题:
Restore the data file and perform incomplete recovery.
Restore the data file and perform point-in-time recover.
Drop the tablespace and lose all data in the tablespace.
Restore the database and lose all data since the last backup.
第9题:
failures because a data file is renamed by error
failures when no standby database is configured
failures that require no archive logs to be applied for recovery
failures due to loss of connectivity-for example, an unplugged disk cable
第10题:
Flash back all the tables in the data file, one by one.
Restore the data file to a new location and perform a media recovery.
Flash back the database, there is no need to restore the data file.
Restore the data file from the most recent backup and flash the database.
第11题:
to support PUSH-based active database duplication
to support synchronization of a standby database with the primary database in a Data environment
To support PULL-based active database duplication
To support file restores over the network in a Data Guard environment
To support file recovery over the network in a Data Guard environment
第12题:
The user has dropped an important table that needs to be recovered.
The database files are corrupted when the database is open.
You are not able to start up the database instance because the required database files are missing.
The archived log files are missing for which backup is not available.
第13题:
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第14题:
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
第15题:
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()
第16题:
Identify two situations in which you can use Data Recovery Advisor for recovery.()
第17题:
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
第18题:
Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)
第19题:
failure when no standby database is configured
failure because a data file is renamed accidentally
failure that requires no archive logs to be applied for recovery
failure due to loss of connectivity-for example, an unplugged disk cable
第20题:
Failure when no standby database is configured
Failure because a data file is renamed accidentally
Failure that requires no archive logs to be applied for recovery
Failure due to loss of connectivity-for example, an unplugged disk cable
第21题:
Diagnose and repair a data file corruption offline.
Diagnose and repair a data file corruption online.
Diagnose and repair failures on a standby database.
Recover from failures in the Real Application Cluster (RAC) environment.
第22题:
The user has dropped an important table that needs to be recovered.
The database files are corrupted when the database is open.
You are not able to start up the database instance because the required database files are missing.
The archived log files are missing for which backup is not available.
第23题:
Recover from failures in the RAC environment.
Diagnose and repair a data file corruption online.
Diagnose and repair a data file corruption offline.
Diagnose and repair failures on a standby database
第24题:
BMR lowers the mean time to recover (MTTR).
BMR supports point-in-time recovery of individual data blocks.
BMR enables you to use incremental backups for block recovery.
BMR enables recovery even when the database is not mounted or open.
BMR enables you to use proxy backups to perform block media recovery.
BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.