Oracle Database 19c: Backup and Recovery Quiz Questions and Answers

What does the SCN represent?

Answer :
  • The system change number, which is a marker indicating a point in time relative to transactions within a given database.

In Oracle Database 19c ‘Snapshot too old’ error are associated with which component tuning.

Answer :
  • UNDO

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

Answer :
  • Level 0

True or false: RMAN supports duplication of only the entire CDB to another CDB.

Answer :
  • FALSE

In Oracle Database 19c ‘DB_RECOVERY_FILE_DEST’ parameter uses OMF.

Answer :
  • True

In Oracle Database 19c Which memory buffer area is associated with copy of database block:

Answer :
  • DB Buffer Cache

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

Answer :
  • Backup set

How is block-change tracking enabled?

Answer :
  • With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

Why would you run the DELETE OBSOLETE command? (Choose all that apply.)

Answer :
  • To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
  • To delete backup set pieces associated with backups that are no longer needed due to retention criteria

How many database instances are used during a database-duplication process?

Answer :
  • Two