Distributed Database Transaction and Recovery Techni...

Distributed database transaction and recovery techniques Java/Oracle /C/C++Oracle

15 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

In which of the following transaction's properties are either all or none of the transaction's operations performed?

  1. Durability
  2. Shared mode
  3. Atomicity
  4. Growing phase
  5. The local agent
Question 2 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment containing the control files, datafiles etc. that RMAN backups or restore?

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

In which of the following RAID levels does any disk failure destroys the array, which becomes more likely with more disks in the arrary?

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

Which of the following RAID level provides fault tolerance from two drive failures and array continues to operate with up to two failed drives?

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

Which of the following is not stored in an RMAN-specific format?

  1. Image copy
  2. Stored script
  3. Standby database
  4. Media management catalog
  5. Registration
Question 6 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 reference nodes?

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

Which of the following transaction's properties states that an incomplete transaction can't disclose its result to other transactions until it is committed?

  1. Exclusive mode
  2. Durability
  3. Isolation
  4. Growing phase
  5. The local agent
Question 8 Multiple Choice (Single Answer)

Which of the following database is created as a separate database by RMAN because it has different DBID from its primary database?

  1. Logical standby database
  2. Registration
  3. Media management catalog
  4. Physical standby database
  5. Proxy archived log backups
Question 9 Multiple Choice (Single Answer)

Which of the following features of the RMAN describes the contents of the backup set that define which files are multiplexed and the level of multiplexing?

  1. Proxy archived log backups
  2. Recovery through Resetlogs
  3. Automatic datafiles creation
  4. Detection of failure
  5. Disk topology and automatic performance tuning
Question 10 Multiple Choice (Single Answer)

Duing which of the following phases does RMAN determine which object will the command access for example, resolving a tablespace name into its component datafiles?

  1. Execution phase
  2. Growing phase
  3. Shared mode
  4. Compilation phase
  5. Registration
Question 11 Multiple Choice (Single Answer)

In which of the following transaction's properties, if many transactions execute concurrently, the result must be same as if they were executed serially in the same order?

  1. Serializability
  2. Durability
  3. Shared mode
  4. Growing phase
  5. One-safe
Question 12 Multiple Choice (Single Answer)

Which of the following areas is a directory, filesystem etc., includes archived redo logs, flashback logs and RMAN backups?

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

In which of the following RAID levels does array continue to operate so long as at least one drive is functioning?

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

Which of the following files is a text file which contains RMAN commands as you would enter them at the command line?

  1. Stored script
  2. Command language interpreter
  3. Command file
  4. The archive file
  5. The parameter file
Question 15 Multiple Choice (Single Answer)

You can create which of the following components of the RMAN environment that contains the RMAN metadata for multiple target database unless you are using RMAN with a physical standby database?

  1. Media management application
  2. Media management catalog
  3. Recovery catalog database
  4. Duplicate database
  5. Registration