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

Which command creates an image copy?

Answer :
  • BACKUP AS COPY

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 of the following is not a recovery technique?

Answer :
  • Two-phase commit

In which the database can be restored up to the last consistent state after the system failure?

Answer :
  • Recovery

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

Answer :
  • system recovery

In log based recovery, the log is sequence of .........

Answer :
  • records
  • blocks
  • numbers

The _________ process performs process recovery when a user process fails.

Answer :
  • PMON

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