Review Questions
1. Which of these failure situations best describe a media failure and will require recovery? (Choose all that apply.)
A. A deleted data file
B. All control files deleted
C. A failed disk controller with access to disks storing data files
D. A disk drive crash on a non-mirrored storage array containing data files
E. All of the above
Answer: E
All these failures will require media recovery. Each failure will make a database file unavailable, which will mean that a restoration and recovery is needed.
Chapter: 10
2. In which of these modes must a database be in order for a complete database recovery up to the point of failure to be performed?
A. NOARCHIVELOG
B. ARCHIVELOG
C. Export
D. LOG
Answer: B
Complete recovery up to the point of failure can only be performed when the database is in ARCHIVELOG mode.
Chapter: 10
3. What is the type of recovery being performed when transactions are not applied and the database is NOARCHIVELOG mode?
A. Complete recovery
B. Partial recovery
C. Incomplete recovery
D. No recovery
Answer: A
Complete recovery in NOARCHIVELOG mode is the correct answer. Even though you are performing a complete recovery, not all transactions are being applied and there can be data missing. This is because the database is not in ARCHIVELOG mode or is not generating archived logs.
Chapter: 10
4. What command is required to relocate files in a user-managed recovery?
A. ALTER DATABASE RENAME FILE
B. SET NEWNAME
C. ALTER DATABASE SET NEWNAME
D. ALTER DATABASE NEWNAME FILE
Answer: A
The ALTER DATABASE RENAME FILE command is used for user-managed backups.
Chapter: 10
5. You make cold database backups including a read-only tablespace and then you make the tablespace read-write. Before the next weekly backup, the tablespace is made read-write and you need to perform recovery on that tablespace. What option must be performed?
A. No recovery is needed because the tablespace was backed up read-only.
B. No recovery is needed because the tablespace did not have many changes made in it after it was made read-write.
C. Recovery is needed because the tablespace was made read-write and the backup was read-only.
D. Restoring the read-only tablespace is all that is needed.
Answer: C
Recovery is needed when a read-only tablespace is made read-write and the backup was taken when the tablespace was read-only. This means that the SCNs in the headers of the data files have changed and will need to be resynchronized with the rest of the database during the recovery process.
Chapter: 10
6. What RMAN command is required to recover a database in NOARCHIVELOG mode?
A. RESTORE
B. RECOVER
C. SET NEWNAME
D. SWITCH
Answer: A
The RESTORE command is responsible for the recovery process when the database is in NOARCHIVELOG mode because no recovery is necessary.
Chapter: 10
7. What RMAN command is responsible for applying incremental backups and archived logs?
A. RESTORE
B. RECOVER
C. SET NEWNAME
D. SWITCH
Answer: B
The RECOVER command applies incremental backups and archived logs to the recovery process.
Chapter: 10
8. When using RMAN, what mode does the database need to be in to perform a database restore and recovery?
A. Opened
B. Nomount
C. Closed
D. Mount
Answer: D
The database should be mounted to perform a database restore and recovery so that the control file can be read and the target database can be connected.
Chapter: 10
9. The SWITCH command is responsible for which of the following activities during the relocation process of database files?
A. Renaming the location
B. Updating the control file
C. Moving the physical files
D. Updating the files in the data dictionary
Answer: B
The SWITCH command is responsible for updating the control file with the new location of the files that have been moved.
Chapter: 10
10. Which of the following recoveries doesn't require you to recover the database?
A. Read-only tablespace backup and tablespace was read-only when recovered
B. Read-only tablespace backup and tablespace was read-write when recovered
C. Read-write tablespace backup and tablespace was read-only when recovered
D. Read-write tablespace backup and tablespace was read-write when recovered
Answer: A
When the tablespace is read-only for the backup and read-only during the recovery, no recovery is needed. The data files of the read-only tablespace can be restored because there is no change to the SCN of data file headers.
Chapter: 10
11. What are the read-only tablespace recovery scenarios? (Choose all that apply.)
A. Read-only backup to read-only recovery
B. Read-only backup to read-write recovery
C. Read-write backup to read-write recovery
D. Read-write backup to read-only recovery
Answer: A, B, D
The scenarios for read-only tablespace recovery are read-only backup to read-only recovery, read-only backup to read-write recovery, and read-write backup to read-only recovery.
Chapter: 10
12. What type of read-only recovery could the DBA avoid if they are following recommended procedures?
A. Read-only backup to read-only recovery
B. Read-only backup to read-write recovery
C. Read-write backup to read-write recovery
D. Read-write backup to read-only recovery
Answer: D
Every time you make a tablespace read-only, you should conduct a backup shortly thereafter. This eliminates the need to conduct a recovery in the read-write backup to read-only recovery scenario.
Chapter: 10
13. What is unique about a RMAN image copy?
A. It can only back up data files.
B. It can only back up to tape.
C. It can only back up to disk.
D. It cannot back up control files.
Answer: C
The RMAN image copy is similar to an OS copy. It can only be performed to disk.
Chapter: 10
14. Which of the following is a true statement about a backup set?
A. It is not stored in a special RMAN format.
B. It can contain multiple data files.
C. It can contain multiple data files and archived logs.
D. It can only contain one data file per backup set.
Answer: B
A backup set can contain multiple data files within the same backup set, but it cannot contain data files and archived logs in the same backup set. A backup set is stored in a special RMAN format, unlike an image copy.
Chapter: 10
15. Which RMAN command is responsible for copying files from the backup media?
A. RESTORE
B. RENAME
C. RECOVER
D. SWITCH
Answer: A
The RESTORE command is responsible for copying files from the backup media to the desired location.
Chapter: 10
1. Which of these failure situations best describe a media failure and will require recovery? (Choose all that apply.)
A. A deleted data file
B. All control files deleted
C. A failed disk controller with access to disks storing data files
D. A disk drive crash on a non-mirrored storage array containing data files
E. All of the above
Answer: E
All these failures will require media recovery. Each failure will make a database file unavailable, which will mean that a restoration and recovery is needed.
Chapter: 10
2. In which of these modes must a database be in order for a complete database recovery up to the point of failure to be performed?
A. NOARCHIVELOG
B. ARCHIVELOG
C. Export
D. LOG
Answer: B
Complete recovery up to the point of failure can only be performed when the database is in ARCHIVELOG mode.
Chapter: 10
3. What is the type of recovery being performed when transactions are not applied and the database is NOARCHIVELOG mode?
A. Complete recovery
B. Partial recovery
C. Incomplete recovery
D. No recovery
Answer: A
Complete recovery in NOARCHIVELOG mode is the correct answer. Even though you are performing a complete recovery, not all transactions are being applied and there can be data missing. This is because the database is not in ARCHIVELOG mode or is not generating archived logs.
Chapter: 10
4. What command is required to relocate files in a user-managed recovery?
A. ALTER DATABASE RENAME FILE
B. SET NEWNAME
C. ALTER DATABASE SET NEWNAME
D. ALTER DATABASE NEWNAME FILE
Answer: A
The ALTER DATABASE RENAME FILE command is used for user-managed backups.
Chapter: 10
5. You make cold database backups including a read-only tablespace and then you make the tablespace read-write. Before the next weekly backup, the tablespace is made read-write and you need to perform recovery on that tablespace. What option must be performed?
A. No recovery is needed because the tablespace was backed up read-only.
B. No recovery is needed because the tablespace did not have many changes made in it after it was made read-write.
C. Recovery is needed because the tablespace was made read-write and the backup was read-only.
D. Restoring the read-only tablespace is all that is needed.
Answer: C
Recovery is needed when a read-only tablespace is made read-write and the backup was taken when the tablespace was read-only. This means that the SCNs in the headers of the data files have changed and will need to be resynchronized with the rest of the database during the recovery process.
Chapter: 10
6. What RMAN command is required to recover a database in NOARCHIVELOG mode?
A. RESTORE
B. RECOVER
C. SET NEWNAME
D. SWITCH
Answer: A
The RESTORE command is responsible for the recovery process when the database is in NOARCHIVELOG mode because no recovery is necessary.
Chapter: 10
7. What RMAN command is responsible for applying incremental backups and archived logs?
A. RESTORE
B. RECOVER
C. SET NEWNAME
D. SWITCH
Answer: B
The RECOVER command applies incremental backups and archived logs to the recovery process.
Chapter: 10
8. When using RMAN, what mode does the database need to be in to perform a database restore and recovery?
A. Opened
B. Nomount
C. Closed
D. Mount
Answer: D
The database should be mounted to perform a database restore and recovery so that the control file can be read and the target database can be connected.
Chapter: 10
9. The SWITCH command is responsible for which of the following activities during the relocation process of database files?
A. Renaming the location
B. Updating the control file
C. Moving the physical files
D. Updating the files in the data dictionary
Answer: B
The SWITCH command is responsible for updating the control file with the new location of the files that have been moved.
Chapter: 10
10. Which of the following recoveries doesn't require you to recover the database?
A. Read-only tablespace backup and tablespace was read-only when recovered
B. Read-only tablespace backup and tablespace was read-write when recovered
C. Read-write tablespace backup and tablespace was read-only when recovered
D. Read-write tablespace backup and tablespace was read-write when recovered
Answer: A
When the tablespace is read-only for the backup and read-only during the recovery, no recovery is needed. The data files of the read-only tablespace can be restored because there is no change to the SCN of data file headers.
Chapter: 10
11. What are the read-only tablespace recovery scenarios? (Choose all that apply.)
A. Read-only backup to read-only recovery
B. Read-only backup to read-write recovery
C. Read-write backup to read-write recovery
D. Read-write backup to read-only recovery
Answer: A, B, D
The scenarios for read-only tablespace recovery are read-only backup to read-only recovery, read-only backup to read-write recovery, and read-write backup to read-only recovery.
Chapter: 10
12. What type of read-only recovery could the DBA avoid if they are following recommended procedures?
A. Read-only backup to read-only recovery
B. Read-only backup to read-write recovery
C. Read-write backup to read-write recovery
D. Read-write backup to read-only recovery
Answer: D
Every time you make a tablespace read-only, you should conduct a backup shortly thereafter. This eliminates the need to conduct a recovery in the read-write backup to read-only recovery scenario.
Chapter: 10
13. What is unique about a RMAN image copy?
A. It can only back up data files.
B. It can only back up to tape.
C. It can only back up to disk.
D. It cannot back up control files.
Answer: C
The RMAN image copy is similar to an OS copy. It can only be performed to disk.
Chapter: 10
14. Which of the following is a true statement about a backup set?
A. It is not stored in a special RMAN format.
B. It can contain multiple data files.
C. It can contain multiple data files and archived logs.
D. It can only contain one data file per backup set.
Answer: B
A backup set can contain multiple data files within the same backup set, but it cannot contain data files and archived logs in the same backup set. A backup set is stored in a special RMAN format, unlike an image copy.
Chapter: 10
15. Which RMAN command is responsible for copying files from the backup media?
A. RESTORE
B. RENAME
C. RECOVER
D. SWITCH
Answer: A
The RESTORE command is responsible for copying files from the backup media to the desired location.
Chapter: 10
