0

Concurrency Control

Description: Concurrency control Test contains questions on Information Technology for IT certification and Database questions of Oracle
Number of Questions: 15
Created by:
Tags: Concurrency control in oracle Oracle test IT questions DB questions Java/Oracle /C/C++ Oracle
Attempted 0/15 Correct 0 Score 0

When the user requests the execution of an application, which of the followings starts the whole transaction?

  1. Root agent

  2. Agent

  3. The local agent

  4. Exclusive mode

  5. Client


Correct Option: A
Explanation:

When the user requests the execution of an application, root agent starts the whole transaction.

Which of the following RAID level refers striped set with distributed parity and block-interleaved distributed parity?

  1. Mounting the database

  2. One-safe

  3. RAID level 1

  4. RAID level 2

  5. RAID level 5


Correct Option: E
Explanation:

This RAID level refers striped set with distributed parity and block-interleaved distributed parity.

Which of the following databases described as the control file contains recovery metadata i.e. information about backups?

  1. Target database

  2. Logical standby database

  3. Duplicate database

  4. Media management catalog

  5. Instance creation


Correct Option: A
Explanation:

This database described as control file contains recovery meta data i.e. information about backups.

Which of the following areas is a directory that serves as the default storage area for files related recovery?

  1. Recover

  2. SQL work area

  3. Proxy archived log backups

  4. Flash recovery area

  5. Oracle flashback database


Correct Option: D
Explanation:

This area is a directory that serves as the default storage area for files related to recovery.

Which of the following nodes participating in the session tree instructs the commit point site to initiate the global commit of the transaction, if all nodes prepare successfully?

  1. Shared mode

  2. Global coordinator

  3. Database server

  4. Client

  5. The local agent


Correct Option: B
Explanation:

This node participating in the session tree instructs the commit point site to initiate the global commit of the transaction, if all nodes prepare successfully.

Which of the following locking mechanisms is used to lock at the fragment level?

  1. Read only

  2. Granularity of locking

  3. Shared mode

  4. Shrinking phase

  5. The local agent


Correct Option: B
Explanation:

This locking mechanism is used to lock at the fragment level.

Which of the following nodes participating in the session tree is responsible for coordinating the transaction among the nodes?

  1. Mounting the database

  2. The local agent

  3. Client

  4. Local coordinator

  5. Database server


Correct Option: D
Explanation:

This node participating in the session tree is responsible for coordinating the transaction among the nodes?

The activity of ensuring atomicity in the presence of transaction aborts is called __________________.

  1. Force

  2. exclusive mode

  3. transaction recovery

  4. database recovery

  5. registration


Correct Option: C
Explanation:

The activity of ensuring atomicity in the presence of transaction aborts is called transaction recovery.

Which of the following operations is performed to determine all non-committed transactions that have to be undone?

  1. The stream pool

  2. Agent

  3. Durability

  4. Registration

  5. Checkpoint


Correct Option: E
Explanation:

This operation is performed to determine all non-committed transactions that have to be undone.

Two transactions are in which of the following mode, if they want to lock the same data item with shared and exclusive modes?

  1. Conflict locking

  2. Shared mode

  3. Exclusive mode

  4. Majority locking

  5. Read only


Correct Option: A
Explanation:

Two transactions are in conflict, if they want to lock the same data item with shared and exclusive modes.

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

  1. Growing phase

  2. One-safe

  3. RAID level 4

  4. RAID level 1

  5. RAID level 2


Correct Option: C
Explanation:

This RAID level refers block level parity and block-interleaved parity organization, uses block-level striping.

Which of the following files is one way to automate scheduled backups through an operating system?

  1. Opening the database

  2. Command file

  3. Command language interpreter

  4. The archive file

  5. The parameter file


Correct Option: B
Explanation:

This file is one way to automate scheduled backups through an operating system.

Which of the following nodes participating in the session tree that commits or rolls back the transaction, as instructed by the global coordinator?

  1. The stream pool

  2. Commit point site

  3. Client

  4. Database server

  5. Command language interpreter


Correct Option: B
Explanation:

This node participating in the session tree that commits or rolls back the transaction as instructed by the global coordinator.

Isolation property has to be strictly followed to avoid a problem called ______________.

  1. cascading abort

  2. database recovery

  3. abort

  4. agent

  5. shrinking phase


Correct Option: A
Explanation:

Isolation property has to be strictly followed to avoid a problem called cascading abort.

The activity of providing serializability of the transaction is called ______________.

  1. abort

  2. growing phase

  3. concurrency control

  4. database recovery

  5. registration


Correct Option: C
Explanation:

The activity of providing serializability of the transaction is called concurrency control.

- Hide questions