1. Among the failure events, which is the most serious and may cause data loss?
A. The loss of an entire redo log-file group but no loss in any other group
B. The loss of one member of each redo log-file group
C. The failure of the ARCn background process
D. The failure of the LGWR background process
2. When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?
A. The last redo log file switch
B. The last checkpoint position
C. The last commit
D. The last incremental backup using RMAN
3. Which is a true statement regarding image copies and backup sets.
A. An image copy stores one data file per image copy, and a backup set can store many data files in a single file.
B. An image copy stores one data file per image copy, and a backup set consists of one file per data file backed up.
C. Both image copies and backup sets use a single file to store all objects to be backed up.
D. A backup set stores each data file in its own backup file, but an image copy places all data files into a single output file.
4. Which of the following is not a step in configuring your database to archive redo log files?
A. Place the database in ARCHIVELOG mode.
B. Multiplex the online redo log files.
C. Specify a destination for archived redo log files.
D. Specify a naming convention for your archived redo log files.
5. Why are online backups known as inconsistent backups?
A. Because not all control files are synchronized to the same SCN until the database is shut down
B. Because both committed and uncommitted transactions are included in a backup when the database is online
C. Because a database failure while an online backup is in progress can leave the database in an inconsistent state
D. Because online backups make copies of data files while they are not consistent with the control file
6. Which of the following initialization parameters specifies the location where the control file trace backup is sent?
A. DIAGNOSTIC_DEST
B. BACKGROUND_DUMP_DEST
C. LOG_ARCHIVE_DEST
D. CORE_DUMP_DEST
7. Which of the following pieces of information is not available in the control file?
A. Instance name
B. Database name
C. Tablespace names
D. Log sequence number
8. Which statement adds a member /logs/redo22.log to redo log-file group 2?
A. ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
B. ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
C. ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
D. ALTER DATABASE ADD LOGFILE '/logs/redo22.log';
9. To place the database into ARCHIVELOG mode, in which state must you start the database?
A. MOUNT
B. NOMOUNT
C. OPEN
D. SHUTDOWN
E. Any of the above
10. Which of the following substitution-variable formats are always required for specifying the names of the archived redo log files? Choose all that apply.
A. %d
B. %s
C. %r
D. %t
11. Which of the following initialization parameters controls the mean time to recover the database, in seconds, after an instance failure?
A. FAST_START_IO_TARGET
B. LOG_CHECKPOINT_TIMEOUT
C. FAST_START_MTTR_TARGET
D. MTTR_TARGET_ADVICE
E. FAST_START_TARGET_MTTR
12. Identify the statement that is not true regarding the loss of a control file.
A. A damaged control file can be repaired by using one of the remaining undamaged control files, assuming there are at least two copies of the control file.
B. The missing or damaged control file can be replaced while the instance is still active.
C. You can temporarily run the instance with one fewer control file, as long as you remove one of the references to the missing control file in the spfile or init.ora file.
D. An instance typically fails when one of the multiplexed control files is lost or damaged.
13. Which failures can be detected by the Data Recovery Advisor, which then provides repair recommendations? Choose all that apply.
A. Instance failure
B. Accidental deletion of a data file
C. Disk containing one redo log member is offline
D. User accidentally dropped a table
14. The instance can still be started even if some data files are missing; this rule does not apply to which tablespaces? (Choose all that apply.)
A. USERS
B. SYSTEM
C. TEMP
D. SYSAUX
E. UNDO
15. Select the statement that is not true regarding media failure. A media failure occurs when:
A. The network card on the server fails.
B. The DBA accidentally deletes one of the data files for the SYSTEM tablespace.
C. There is a head crash on all physical drives in the RAID controller box.
D. A corrupted track on a CD containing a read-only tablespace causes a query to fail.
16. Choose the correct statement about the Data Recovery Advisor.
A. The Data Recovery Advisor is a standalone tool.
B. The Data Recovery Advisor does not support RAC databases.
C. The CHANGE FAILURE command can be used in a SQL*Plus session.
D. The REPAIR FAILURE command works only after LIST FAILURE .
17. Place the following events or actions leading up to and during instance recovery in the correct order. 1. The database is opened and available. 2. Oracle uses undo segments in the undo tablespace to roll back uncommitted trans- actions. 3. The DBA issues the STARTUP command at the SQL*Plus prompt. 4. Oracle applies the information in the online redo log files to the data files.
A. 4, 3, 2, 1
B. 3, 4, 1, 2
C. 2, 1, 3, 4
D. 2, 1, 4, 3
E. 3, 2, 4, 1
F. 3, 4, 2, 1
18. You’ve noticed that when an instance crashes, it takes a long time to start up the data- base. Which advisor can be used to tune this situation?
A. The Undo Advisor
B. The SQL Tuning Advisor
C. The Database Tuning Advisor
D. The MTTR Advisor
E. The Instance Tuning Advisor
19. In ARCHIVELOG mode, the loss of a data file for any tablespace other than the SYSTEM or UNDO tablespace affects which objects in the database?
A. The loss affects only objects whose extents reside in the lost data file.
B. The loss affects only the objects in the affected tablespace, and work can continue in other tablespaces.
C. The loss will not abort the instance but will prevent other transactions in any tablespace other than SYSTEM or UNDO until the affected tablespace is recovered.
D. The loss affects only those users whose default tablespace contains the lost or damaged data file.
20. Which of the following conditions prevents the instance from progressing through the NOMOUNT , MOUNT , and OPEN states?
A. One of the redo log-file groups is missing a member.
B. The instance was previously shut down uncleanly with SHUTDOWN ABORT .
C. Either the spfile or init.ora file is missing.
D. One of the five multiplexed control files is damaged.
E. The USERS tablespace is offline, with one of its data files deleted.
