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

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

Answer :
  • Level 0

What type of backup is stored in a proprietary RMAN format?

Answer :
  • Backup set

Which backup option defines a user-defined name for a backup?

Answer :
  • TAG

What command would you issue to enable automated backups of control files?

Answer :
  • CONFIGURE CONTROLFILE AUTOBACKUP ON

How is block-change tracking enabled?

Answer :
  • With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

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

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

Answer :
  • RECOVERY_CATALOG_OWNER

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

Answer :
  • BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

Failure recovery and media recovery fall under ........

Answer :
  • system recovery

Which command creates an image copy?

Answer :
  • BACKUP AS COPY