Database Transactions Multiple Choice Questions Test 1 Tests pdf Download

Practice database transactions multiple choice questions (MCQs), db test 1 online to learn. Practice 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 answer key with choices as 3 ways, 2 ways, 4 ways and 5 ways of multiple choice questions (MCQ) as durability can be ensured in different to test learning skills. Study to learn transaction model quiz questions to practice MCQ based online 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. State in which 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 aborted stage, available system's options are of

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

A

MCQ. Usage of concurrent execution of transactions improves

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

D