Home › Quizzes › Oracle Database Recovery

Oracle Database Recovery

Oracle database backup and recovery concepts including RMAN, flash recovery area, flashback database, and RAID storage configurations for data protection

13 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following RAID levels refers to non-redundant striping?

  1. RAID level 2
  2. RAID level 3
  3. RAID level 0
  4. Duplicate database
  5. Registration
Question 2 Multiple Choice (Single Answer)

In which of the following degrees of durability, if only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site?

  1. One-safe
  2. Detection of failure
  3. Proxy achived log backups
  4. Media management application
  5. Two-safe
Question 3 Multiple Choice (Single Answer)

The problem with which of the following classifications of degree of durability is that transaction processing cannot proceed, if either the primary or the backup site is down?

  1. One-safe
  2. Two-very-safe
  3. Detection of failure
  4. Proxy archived log backups
  5. Media management application
Question 4 Multiple Choice (Single Answer)

Which of the following refers to block-interleaved distributed parity organization?

  1. RAID level 3
  2. RAID level 2
  3. One-safe
  4. Image copy
  5. RAID level 5
Question 5 Multiple Choice (Single Answer)

Which of the following areas includes multiplexed copies of the control file and online redo logs?

  1. Proxy archived log backups
  2. Recovery through resetlogs
  3. SQL work area
  4. Flash recovery area
  5. Duplicate database
Question 6 Multiple Choice (Single Answer)

Which of the following RAID levels refers to a mirrored organization that holds four disks worth of data?

  1. RAID level 1
  2. RAID level 2
  3. RAID level 3
  4. Proxy archived log backups
  5. Duplicate database
Question 7 Multiple Choice (Single Answer)

Which of the following is a vendor-specific container of information about a media management application?

  1. Media management application
  2. Duplicate database
  3. Target database
  4. Registration of database
  5. Media management catalog
Question 8 Multiple Choice (Single Answer)

RMAN is able to tune its parameter automatically according to which of the following information?

  1. Automatically data file creation
  2. Proxy archived log backups
  3. Recovery through resetlogs
  4. Disk topology
  5. Media management application
Question 9 Multiple Choice (Single Answer)

On enabling which of the following features does the database automatically create, delete and manage flashback logs inside the flash recovery area?

  1. Recovery through resetlogs
  2. Proxy archived log backups
  3. Oracle flashback database
  4. Duplicate database
  5. Registration
Question 10 Multiple Choice (Single Answer)

In which of the following phases does RMAN construct a sequence of RPCs that instructs the server sessions on the target database to perform the desired operation?

  1. Execution phase
  2. Compilation phase
  3. One-safe
  4. Shrinking phase
  5. Recovery through resetlogs
Question 11 Multiple Choice (Single Answer)

Which of the following RAID levels refers to block-interleaved parity organization and uses block-level striping?

  1. RAID level 4
  2. RAID level 2
  3. RAID level 3
  4. Proxy archived log backups
  5. Target database
Question 12 Multiple Choice (Single Answer)

Which of the following is a replica of the primary database that you can use for testing purposes?

  1. Proxy archived log backups
  2. Recovery catalog schema
  3. Recovery through resetlogs
  4. Incrementally updated backups
  5. Duplicate database
Question 13 Multiple Choice (Single Answer)

Which of the following RAID levels refers to the P + Q redundancy scheme?

  1. RAID level 2
  2. RAID level 3
  3. RAID level 6
  4. One-safe
  5. Image copy
← Back to Quizzes