Oracle Database 12c R2: Backup and Recovery Workshop Ed 3 Quiz Questions and Answers

What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)

Answer :
  • RECOVERY_CATALOG_OWNER

Explanation :

The RECOVERY_CATALOG_OWNER privilege is required to create the recovery catalog. The DBA privilege includes RESOURCE and CONNECT and will work, but this role has many additional privileges that are unneeded. SELECT ANY DICTIONARY is not required.

Which type of backup must be performed first with an incremental backup?

Answer :
  • Level 0

Explanation :

A level-0 backup is the first backup that is performed when implementing an incremental backup strategy. A level-0 backup copies all the used blocks as a baseline.

Which of the following best describes a full backup?

Answer :
  • All data files of a database

Explanation :

A full backup is best described as backing up all the used blocks in a data file or any database file. A full backup can be taken on one database file.

Compressed backups work with which of the following commands?

Answer :
  • BACKUP

Explanation :

Compressed backups work only with backup sets, not image copies. Thus, compressed backups will work only with the BACKUP command.

Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

Answer :
  • Differential incremental backup

Explanation :

A differential incremental backup backs up only blocks that have been modified since a backup at the same level or lower.