Home › Quizzes › Relational Database Recovery

Relational Database Recovery

This test is useful for the students who are preparing for the GATE, Information technology, IT certified programs exams. This test represents RMAN components architecture, database transactions and different RAID LEVEL etc....

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 optional when using RMAN because RMAN stores its metadata in the control file of each target database?

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

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

  1. Oracle flashback database
  2. Proxy archived log backups
  3. Automatic datafile creation
  4. Registration of database
  5. Disk topology and automatic performance tuning
Question 3 Multiple Choice (Single Answer)

In which of the following transaction's properties, once a transaction is committed, the system must guarantee that the results of operations will never be lost independent of subsequent failures?

  1. Durability
  2. Serializability
  3. Shared mode
  4. Growing phase
  5. Local agents
Question 4 Multiple Choice (Single Answer)

RMAN can use which of the following during RMAN restore and recover operations?

  1. Image copies
  2. Media management application
  3. Media management catalog
  4. Logical standby database
  5. Detection of failure
Question 5 Multiple Choice (Single Answer)

In which of the following RAID levels, hamming codes error correction is calculated across correspondings bits on disks?

  1. One-safe
  2. RAID level 2
  3. RAID level 0
  4. RAID level 1
  5. Registration of database
Question 6 Multiple Choice (Single Answer)

During which of the following phases, recovery manager sends the remote procedure calls to the target database, monitors their progress and collects the results?

  1. Compilation phase
  2. Growing phase
  3. Exclusive mode
  4. Execution phase
  5. Command language interpreter
Question 7 Multiple Choice (Single Answer)

RMAN can create, backup or recover which of the following components of the RMAN environment?

  1. Physical standby database
  2. Duplicate database
  3. Media management application
  4. Media management catalog
  5. Growing phase
Question 8 Multiple Choice (Single Answer)

Which of the following components of RMAN environment contains the control files, datafiles and optional archived redo logs?

  1. Local agent
  2. Media management application
  3. Target database
  4. Duplicate database
  5. Media management catalog
Question 9 Multiple Choice (Single Answer)

Which of the following transaction's properties requires that if a transaction is interrupted by a failure its partial results are not at all taken into consideration?

  1. Serializability
  2. Exclusive mode
  3. Shrinking phase
  4. Atomicity
  5. Local agent
Question 10 Multiple Choice (Single Answer)

Which of the following RAID levels makes larger RAID groups more practical, especially for high availability systems?

  1. Registration of database
  2. RAID level 6
  3. RAID level 0
  4. RAID level 1
  5. One-safe
Question 11 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 application
  3. Duplicate database
  4. Media management catalog
  5. Growing phase
Question 12 Multiple Choice (Single Answer)

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

  1. Oracle flashback database
  2. Proxy archived log backup
  3. Flash recovery area
  4. Private SQL area
  5. SQL work area
Question 13 Multiple Choice (Single Answer)

Which of the following nodes participating in the session tree sends all of the distributed transaction's SQL statements, remote procedure calls and so forth to the directly referenced nodes thus forming the session tree?

  1. Database server
  2. Local coordinator
  3. Local agent
  4. Shared mode
  5. Global coordinator
Question 14 Multiple Choice (Single Answer)

In which of the following RAID levels, upon drive failure any subsequent reads can be calculated from the distributed parity?

  1. RAID level 0
  2. RAID level 1
  3. RAID level 5
  4. One-safe
  5. Registration of database
Question 15 Multiple Choice (Single Answer)

Which of the following nodes participating in the session tree acts as a client when it references information from another node's database?

  1. Local coordinator
  2. Client
  3. Database server
  4. Local agent
  5. Exclusive mode
← Back to Quizzes