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

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

Answer :
  • UNDO

Your database backup scripts keep failing on the ALTER TABLESPACE BEGIN BACKUP command. Your junior DBA informs you that the failure is because the database is in ARCHIVELOG mode. Is he correct?

Answer :
  • No

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.

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

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

Answer :
  • FALSE

In Oracle Database 19c Block change tracking helps in faster image copy backps.

Answer :
  • False

In Oracle Database 19c you want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). Examine the steps required to perform the migration: 1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12. 2. Place all tablespaces in read-only mode on the source database. 3. Upgrade the source database to Oracle Database 12c. 4. Copy the dump file and data files to the desired location in the target database. 5. Create a new PDB in the target CDB. 6. Synchronize the PDB on the target CDB. 7. Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.

Answer :
  • 2, 5, 1, 4, 7, and 6

In Oracle Database 19c Loss of control file of database won’t impact the database availability.

Answer :
  • False

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

Answer :
  • True