Database Transactions Multiple Choice Questions 1 PDF Download

Learn database transactions multiple choice questions (MCQs), database management system test 1 for online course prep exams. Practice transaction model MCQs questions and answers on transaction model, storage and file structure, transaction isolation levels, types of storage structure test for online SQL inner join courses distance learning.

Free database transactions quiz online, study guide has multiple choice question: durability can be ensured in different with choices 3 ways, 2 ways, 4 ways and 5 ways with online eLearning for international exams' preparation like ETS GRE exam for good GRE scores. Study to learn transaction model quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Database Transactions Test 1 Quiz PDF Download

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