Home › Quizzes › Relational Database Transaction Scheme

Relational Database Transaction Scheme

Relational database transaction scheme Java/Oracle /C/C++Oracle

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following RAID levels refers to memory-style error correcting codes and redundancy through hamming code?

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

Which of the following nodes participating in the session tree instructs the commit point site to initiate the global commit of the transaction?

  1. Global coordinator
  2. Local coordinator
  3. Client
  4. Stream pool
  5. Command language interpreter
Question 3 Multiple Choice (Single Answer)

The contents of the which of the files will be interpreted as if entered at the command line?

  1. Read only
  2. Parameter file
  3. Archive file
  4. Command file
  5. Command language interpreter
Question 4 Multiple Choice (Single Answer)

Which of the following transaction properties has to be strictly followed to avoid a problem called cascading aborts?

  1. Local agent
  2. Shrinking phase
  3. Shared mode
  4. Serializability
  5. Isolation
Question 5 Multiple Choice (Single Answer)

Which of the following components of the RMAN environment contains the control files, recovery meta data etc.?

  1. Mounting the database
  2. Target database
  3. Duplicate database
  4. Media management catalog
  5. Media management application
Question 6 Multiple Choice (Single Answer)

Which of the following can be executed against any control files in the catalog?

  1. Recover
  2. Global stored script
  3. Duplicate database
  4. Media management catalog
  5. Archive file
Question 7 Multiple Choice (Single Answer)

In which of the following is it possible to lock individual tuples?

  1. Mounting the database
  2. Local agents
  3. Granularity of locking
  4. Shared mode locking
  5. Shrinking phase
Question 8 Multiple Choice (Single Answer)

Which of the following RAID levels refers to mirrored set without parity and mirrored disk?

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

Which of the following components of the RMAN environment spawn server sessions on the target database to do work of backup?

  1. Stream pool
  2. Duplicate database
  3. RMAN client
  4. Client
  5. Media management application
Question 10 Multiple Choice (Single Answer)

Which of the following areas is an automatic storage management group that includes RMAN backup, flashback logs etc.?

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

Which of the following features of the RMAN describes the level of multiplexing and defines which files are multiplexed?

  1. Java pool
  2. Media management application
  3. Proxy archived log backup
  4. Oracle flashback database
  5. Disk topology and automatic performance tuning
Question 12 Multiple Choice (Single Answer)

What is the activity of providing durability of the transaction called?

  1. Recover
  2. Database recovery
  3. Concurrency control
  4. Exclusive mode
  5. Growing phase
Question 13 Multiple Choice (Single Answer)

Which of the following is/are identical to the results of copying a file with operating system commands?

  1. Image copies
  2. Command language interpreter
  3. Media management catalog
  4. Logical standby database
  5. Archive file
Question 14 Multiple Choice (Single Answer)

Which of the following levels refers to striped set with dedicated parity and bit-interleaved parity organization?

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

Which of the following nodes participating in the session tree hosts a database from which a client requests data?

  1. Database buffer cache
  2. Database server
  3. Client
  4. Local coordinator
  5. Oracle database
← Back to Quizzes