Home › Quizzes › Oracle Database Backup

Oracle Database Backup

Oracle RMAN backup and recovery concepts, including media management, RAID storage configurations, and RMAN components and operations

14 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following RAID level provides improved performance and additional storage but no fault tolerance?

  1. RAID level 2
  2. RAID level 4
  3. RAID level 0
  4. One-safe
  5. Proxy archived log backups
Question 2 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment is a vendor-specific repository of information about a media management application?

  1. Media management application
  2. Media management catalog
  3. Recovery catalog database
  4. Proxy archived log backups
  5. Registration
Question 3 Multiple Choice (Single Answer)

Which of the following areas is a directory, file system or automatic storage management disk group includes RMAN back ups?

  1. Oracle flashback database
  2. SQL work area
  3. The stream pool
  4. Registration
  5. Flash recovery area
Question 4 Multiple Choice (Single Answer)

Which of the following RAID level provides fault tolerance from disk errors and single disk failure?

  1. RAID level 1
  2. One-safe
  3. RAID level 2
  4. RAID level 4
  5. Media management application
Question 5 Multiple Choice (Single Answer)

During which of the following phase, recovery manager constructs a sequence of RPCs that instruct the server sessions on the target database to perform the desired operations?

  1. Compilation phase
  2. Execution phase
  3. Shrinking phase
  4. Exclusive mode
  5. Registration
Question 6 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment is a copy of the primary database that you can use for testing purposes?

  1. Recovery catalog database
  2. Duplicate database
  3. Media management application
  4. Proxy archived log backups
  5. Command file
Question 7 Multiple Choice (Single Answer)

Which of the following can be executed against any target database in the catalog?

  1. Command file
  2. Registration
  3. Recovery catalog database
  4. Stored scripts
  5. The archive file
Question 8 Multiple Choice (Single Answer)

In which of the following RAID level, distributed parity requires all drives but one to be present to operate?

  1. RAID level 6
  2. RAID level 2
  3. RAID level 4
  4. One-safe
  5. Media management application
Question 9 Multiple Choice (Single Answer)

One can fail over to which of the following components of the RMAN environment if the primary database goes down?

  1. Recovery catalog database
  2. Media management application
  3. Standby database
  4. Proxy archived log backups
  5. RECOVER
Question 10 Multiple Choice (Single Answer)

Which of the following is an exact copy of a single datafiles, archives redo log file or control file?

  1. Recovery catalog database
  2. Image copy
  3. Proxy archived log backups
  4. Media management application
  5. Command file
Question 11 Multiple Choice (Single Answer)

Which of the following features of the RMAN describes the level of multiplexing?

  1. Oracle flashback database
  2. Disk topology and automatic performance tuning
  3. Proxy archived log backups
  4. Recovery catalog database
  5. Detection of failure
Question 12 Multiple Choice (Single Answer)

RMAN uses which of the following that can execute commands in interactive mode?

  1. Command file
  2. Execution phase
  3. Command language interpreter
  4. READ ONLY
  5. ABORT
Question 13 Multiple Choice (Single Answer)

Using which of the following, RMAN obtains commands and sends output by using the DBMS_PIPE PL/SQL package?

  1. Command file
  2. Member method
  3. Execution phase
  4. RMAN pipe interface
  5. Registration
Question 14 Multiple Choice (Single Answer)

Which of the following RAID levels provides an improved performance and fault tolerance but with a dedicated parity disk rather than rotated parity stripes?

  1. Recovery through resetlogs
  2. One-safe
  3. RAID level 2
  4. RAID level 4
  5. RAID level 3
← Back to Quizzes