Home › Quizzes › Oracle RMAN and Database Recovery

Oracle RMAN and Database Recovery

Test your knowledge of Oracle Recovery Manager (RMAN) backup and recovery operations, including RMAN components, commands, execution phases, and Oracle-specific backup features.

11 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

The user within which of the following components of RMAN environment owns the metadata tables maintained by RMAN?

  1. Standby database
  2. Recovery catalog schema
  3. Duplicate database
  4. Media management application
  5. Detection of failure
Question 2 Multiple Choice (Single Answer)

Which of the following areas is a directory, file system or automatic storage management disk group that includes multiplexed copies of the control file and online redo logs?

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

In which of the following is it possible to lock at the file level, i.e. to lock at the fragment level?

  1. Shared mode locking
  2. Exclusive mode locking
  3. The local agents
  4. Recovery through resetlogs
  5. Granularity of locking
Question 4 Multiple Choice (Single Answer)

Recovery manager uses which of the following that can execute commands in batch mode?

  1. Command file
  2. Compilation phase
  3. READ ONLY
  4. Command language interpreter
  5. Database server
Question 5 Multiple Choice (Single Answer)

In which of the following, it is possible to lock at the file level i.e to lock at the fragment level?

  1. Shared mode locking
  2. Exclusive mode locking
  3. The local agents
  4. Recovery through resetlogs
  5. Granularity of locking
Question 6 Multiple Choice (Single Answer)

Which of the following is available to any RMAN client that connects to the catalog and the target database?

  1. The archive file
  2. Instance creation
  3. Stored script
  4. Command file
  5. Compilation phase
Question 7 Multiple Choice (Single Answer)

During which of the following phases, if more than one channel is allocated, then recovery manager can execute certain commands in parallel so that all of the channel's target database sessions are concurrently executing a remote procedure call?

  1. Compilation phase
  2. Execution phase
  3. Shrinking phase
  4. Command file
  5. Media management application
Question 8 Multiple Choice (Single Answer)

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

  1. Media management application
  2. Duplicate database
  3. RAMN client
  4. Standby database
  5. Client
Question 9 Multiple Choice (Single Answer)

Which of the following features of the RMAN describes the number and size of the input and output disk buffers?

  1. Instance creation
  2. The stream pool
  3. Proxy archived log backup
  4. Oracle flashback database
  5. Disk topology and automatic performance tuning
Question 10 Multiple Choice (Single Answer)

By using which of the following, is it possible to write a portable programmatic interface to RMAN?

  1. Member method
  2. RMAN pipe interface
  3. Log writer
  4. Command file
  5. Compilation phase
Question 11 Multiple Choice (Single Answer)

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

  1. Standby database
  2. Target database
  3. Duplicate database
  4. Proxy archived log backups
  5. The archive file
← Back to Quizzes