Transaction Management MCQs Quiz Online PDF Download

Learn transaction management MCQs, database management system test for learning online courses and test prep to practice. Introduction to dbms quiz has multiple choice questions (MCQ), transaction management quiz questions and answers, relational databases, database design, transaction management tutorials for online SQL injection distance learning.

Database management system practice test MCQ: detection of system failures and restoring database to state that existed prior to occurrence of failure, is known as with choices failure recovery , failure identification, failure response and failure management problem solving skills for summative and formative assessment, competitive exam prep, interview questions with answer key. Free study guide is for online learning transaction management quiz with MCQs to practice test questions with answers.

MCQs on Transaction Management Quiz PDF Download

MCQ. Detection of system failures and restoring database to state that existed prior to occurrence of failure, is known as

  1. Failure recovery
  2. Failure identification
  3. Failure response
  4. Failure management

A

MCQ. Controlling interaction among concurrent transactions, is responsibility of

  1. Concurrency-monitor manager
  2. Concurrency-manipulate manager
  3. Concurrency-control manager
  4. Concurrency manager

C

MCQ. Concurrency-control manager and recovery managers are part of

  1. Authorization manager
  2. Transaction manager
  3. Integrity manager
  4. File manager

B

MCQ. Ensuring atomicity and durability properties is responsibility of the

  1. Recovery manager
  2. Buffer manager
  3. Transaction manager
  4. File manager

A

MCQ. A collection of operations that performs a single logical function in a database application, is known as

  1. Transportation
  2. Communication
  3. Transaction
  4. Concatenation

C