Database Transactions Multiple Choice Questions and Answers 1 pdf eBooks Download

Learn database transactions multiple choice questions (MCQs), db test 1 online for exams. 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 helping 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 for viva exam preparation and job's interview questions. Study to learn transaction model quiz questions to practice online 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. 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