Home › Quizzes › Distributed Transaction Management and Concurrency Control

Distributed Transaction Management and Concurrency Control

Questions covering distributed transaction coordination, locking mechanisms, transaction isolation, recovery protocols, and concurrency control in database systems

10 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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
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, if all nodes prepare successfully?

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

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
Question 4 Multiple Choice (Single Answer)

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
Question 5 Multiple Choice (Single Answer)

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
Question 6 Multiple Choice (Single Answer)

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
Question 7 Multiple Choice (Single Answer)

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
Question 8 Multiple Choice (Single Answer)

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
Question 9 Multiple Choice (Single Answer)

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
Question 10 Multiple Choice (Single Answer)

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

  1. abort
  2. growing phase
  3. concurrency control
  4. database recovery
  5. registration
← Back to Quizzes