Home › Quizzes › Oracle Database Backup and Recovery

Oracle Database Backup and Recovery

Covers Oracle Database backup and recovery concepts including RMAN, flashback database, standby databases, and recovery catalogs.

7 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In which of the following phases does RMAN send the RPC calls to the target database, monitors their progress and collects the results?

  1. Execution phase
  2. Compilation phase
  3. Command file
  4. Common language interpreter
  5. Duplicate database
Question 2 Multiple Choice (Single Answer)

RMAN periodically propagates metadata from the target database control file into which of the following?

  1. Duplicate database
  2. Recovery catalog schema
  3. Media management application
  4. Media management catalog
  5. Command file
Question 3 Multiple Choice (Single Answer)

Which of the following can use Oracle Net to connect to a target database?

  1. RMAN client
  2. Client
  3. Database server
  4. Duplicate database
  5. Media management application
Question 4 Multiple Choice (Single Answer)

Which of the following is a directory, file system or automatic storage management disk group that serves as the default storage area for files related to recovery?

  1. Duplicate database
  2. Flash recovery area
  3. Proxy archived log backups
  4. Automatic datafile creation
  5. One-safe
Question 5 Multiple Choice (Single Answer)

If the primary database goes down, then you can fail over to the which of the following databases?

  1. Duplicate database
  2. Media management catalog
  3. Database server
  4. Standby database
  5. Media management application
Question 6 Multiple Choice (Single Answer)

By which of the following can you quickly revert a database to a previous time without restoring datafiles and performing media recovery?

  1. Proxy archived log backups
  2. Automatic datafile creation
  3. Media management catalog
  4. Duplicate database
  5. Oracle flashback database
Question 7 Multiple Choice (Single Answer)

The work of backup and recovery is performed by server sessions running on which of the following databases?

  1. Media management catalog
  2. Target database
  3. Duplicate database
  4. Client
  5. Media management application
← Back to Quizzes