Home › Quizzes › Oracle Database Recovery and Storage

Oracle Database Recovery and Storage

Covers RMAN recovery components, RAID storage levels, and database locking mechanisms for Oracle databases

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment is the database to be backed up or recovered?

  1. Duplicate database
  2. Target database
  3. Media management catalog
  4. Proxy archived log backups
  5. Database server
Question 2 Multiple Choice (Single Answer)

Which of the following areas includes files created by RESTORE and RECOVER commands?

  1. Flash recovery area
  2. SQL work area
  3. Redo log buffer
  4. Image copy
  5. Recovery through resetlogs
Question 3 Multiple Choice (Single Answer)

During which of the following phases of 2-phase locking mechanism, locks are only released?

  1. Growing phase
  2. Compilation phase
  3. Two-very-phase
  4. Shrinking phase
  5. Local agent
Question 4 Multiple Choice (Single Answer)

Which of the following RAID levels refers to striped set without parity and non-redundant array?

  1. RAID level 5
  2. RAID level 6
  3. RAID level 0
  4. Two-very-safe
  5. Detection of failure
Question 5 Multiple Choice (Single Answer)

A transaction can lock a data item in which of the following modes if it is not locked at all?

  1. Exclusive mode
  2. Local agents
  3. Growing phase
  4. Command file
  5. Shared mode
Question 6 Multiple Choice (Single Answer)

Which of the following RAID levels refers to mirrored set without parity?

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

Which of the following components of the RMAN environment is a separate database created to hold the recovery catalog?

  1. Catalog database
  2. Media management catalog
  3. Duplicate database
  4. Proxy archived log backups
  5. Local agents
Question 8 Multiple Choice (Single Answer)

Which of the following features of the RMAN describes the contents of the backup sets that defines which files are multiplexed?

  1. Disk topology and automatic performance tuning
  2. Oracle flashback database
  3. Proxy archived log backups
  4. Duplicate database
  5. Stream pool
Question 9 Multiple Choice (Single Answer)

Which of the following interfaces is an alternative method for issuing commands to RMAN and receiving the output from those commands?

  1. Command file
  2. RMAN pipe interface
  3. Media management application
  4. Two-very-safe
  5. Member method
Question 10 Multiple Choice (Single Answer)

Which of the following is a series of tables and views owned by a single user populated with backup and recovery information for one or more databases?

  1. Standby database
  2. Recovery catalog
  3. Duplicate database
  4. Media management catalog
  5. Registration
Question 11 Multiple Choice (Single Answer)

During which of the following phases, RMAN sends the remote procedure calls to the target database and remotes their progress?

  1. Growing phase
  2. Compilation phase
  3. Execution phase
  4. Two-very-safe
  5. Image copy
Question 12 Multiple Choice (Single Answer)

Which of the following RAID levels refers to redundancy through hamming code?

  1. RAID level 6
  2. RAID level 5
  3. RAID level 2
  4. Two-very-safe
  5. Image copy
Question 13 Multiple Choice (Single Answer)

Which of the following can be associated with a single database in the catalog?

  1. Command file
  2. Stored scripts
  3. Duplicate database
  4. Media management catalog
  5. Registration
Question 14 Multiple Choice (Single Answer)

Which of the following classifications of the degree of durability has the problem that updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing?

  1. Two-very-safe
  2. Detection of failuer
  3. Growing phase
  4. Exclusive mode
  5. One-safe
Question 15 Multiple Choice (Single Answer)

Which of the following RAID levels refers to striped set with dedicated parity?

  1. Two-very-safe
  2. RAID level 6
  3. RAID level 3
  4. Registration
  5. RAID level 5
← Back to Quizzes