Transaction Isolation Levels MCQs & Quiz Online PDF Download

Transaction isolation levels MCQs, transaction isolation levels quiz answers pdf to study online data science degree course. Learn database transactions Multiple Choice Questions and Answers (MCQs), "transaction isolation levels" quiz questions and answers for applied computer science. Learn transaction isolation and atomicity, storage and file structure, transaction model, transaction isolation levels test prep for online degrees.

"Performing concurrent execution of transactions reduces" Multiple Choice Questions (MCQ) on transaction isolation levels with choices waiting time, buffer time, queue time, and evaluation time for applied computer science. Practice merit scholarships assessment test, online learning transaction isolation levels quiz questions for competitive exams in computer science major for online computer engineering programs.

MCQs on Transaction Isolation Levels PDF Online Download

MCQ: Performing concurrent execution of transactions reduces

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

A

MCQ: The usage of concurrent execution of transactions improves

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

D

MCQ: Serializability of schedules can be ensured through a mechanism called

  1. Concurrency control policy
  2. Evaluation control policy
  3. Execution control policy
  4. Cascading control policy

A

MCQ: Schedules should preferably be

  1. Cascading
  2. Cascadeless
  3. Dependent
  4. Non-modifying

B

MCQ: A schedule can be tested against the con?ict serializability by constructing

  1. Histogram
  2. Gantt chart
  3. Precedence graph
  4. Bar-graph

C