Oracle Database Backup Scheme

Oracle database backup scheme Java/Oracle /C/C++Oracle

15 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment is a replica of the primary database that is updated using archived logs created by the primary database?

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

During which of the following phases, if more than one channel is allocated, the RMAN can execute certain commands in parallel so that all of the channel's target database sessions are concurrently executing an RPC call?

  1. Execution phase
  2. Compilation phase
  3. Shrinking phase
  4. Two-very-safe
  5. Registration
Question 3 Multiple Choice (Single Answer)

Which of the following classifications of the degree of durability avoids the problem of lost transactions?

  1. Two-very-safe
  2. Detection of failure
  3. Two-safe
  4. Compilation phase
  5. Shrinking phase
Question 4 Multiple Choice (Single Answer)

In which of the following classifications of the degree of durability, a transaction commits as soon as its commit log record is written to stable storage at the primary site?

  1. Two-very-safe
  2. Detection of failure
  3. Compilation phase
  4. Shrinking phase
  5. One-safe
Question 5 Multiple Choice (Single Answer)

Which of the following RAID levels is known as memory-style error correcting-code organization?

  1. RAID level 1
  2. RAID level 6
  3. RAID level 2
  4. Proxy archived log backups
  5. Registration
Question 6 Multiple Choice (Single Answer)

Which of the following is a block of RMAN job commands that is stored in the recovery catalog?

  1. Command file
  2. Compilation phase
  3. Shared mode
  4. Stored script
  5. Registration
Question 7 Multiple Choice (Single Answer)

Which of the following areas includes archived redo logs and flashback logs?

  1. Recovery through resetlog
  2. Proxy archived log backup
  3. SQL work area
  4. Detection of failure
  5. Flash recovery area
Question 8 Multiple Choice (Single Answer)

In which of the following RAID levels, disk controllers can detect whether a sector has been read correctly?

  1. RAID level 3
  2. RAID level 1
  3. RAID level 6
  4. Two-very-safe
  5. Proxy archived log backups
Question 9 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment contains the metadata that RMAN uses to perform its backup and recovery operations?

  1. Duplicate database
  2. Media management catalog
  3. Recovery catalog database
  4. Proxy archived log backup
  5. Recovery through resetlogs
Question 10 Multiple Choice (Single Answer)

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

  1. Shared mode
  2. Shrinking phase
  3. Local agent
  4. Command file
  5. Exclusive mode
Question 11 Multiple Choice (Single Answer)

Which of the following refers block-interleaved parity organization, and uses block-level striping?

  1. RAID level 1
  2. RAID level 4
  3. RAID level 6
  4. Shrinking phase
  5. Registration
Question 12 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment manages backup and recovery operations for a target database?

  1. Client
  2. RMAN client
  3. Media management catalog
  4. Global coordinates
  5. Image copy
Question 13 Multiple Choice (Single Answer)

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

  1. Command file
  2. Command language interpreter
  3. Compilation phase
  4. Database writer
  5. Process monitor
Question 14 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment allows RMAN to backup to a storage system such as tape?

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

Which of the following RAID levels refers to disk arrays with striping at the level of blocks, but without any replication?

  1. RAID level 0
  2. RAID level 1
  3. RAID level 6
  4. Two-very-safe
  5. Registration