Database Transactions Multiple Choice Questions 1 PDF Download

Practice database transactions multiple choice questions (MCQs), db test 1 for online course prep exams. Learn transaction model MCQs questions and answers on transaction model, storage and file structure, transaction isolation levels, types of storage structure with answers.

Free database transactions quiz online, study guide has multiple choice question on durability can be ensured in different with options 3 ways, 2 ways, 4 ways and 5 ways to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn transaction model quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Database Transactions Quiz PDF Download Test 1

MCQ. Durability can be ensured in different

  1. 2 ways
  2. 3 ways
  3. 4 ways
  4. 5 ways

A

MCQ. The state in which the transaction stays while it is executing is termed as

  1. Active
  2. Partially committed
  3. Initial
  4. Both A and C

D

MCQ. Performing concurrent execution of transactions reduces

  1. Waiting time
  2. Buffer time
  3. Queue time
  4. Evaluation time

A

MCQ. When a transaction is rolled back and entered at the aborted stage, the available system's options are of

  1. 2 types
  2. 3 types
  3. 4 types
  4. 5 types

A

MCQ. The usage of concurrent execution of transactions improves

  1. Utilization
  2. Response time
  3. Throughput
  4. Both A and C

D