Transaction Isolation Levels MCQs Quiz Online PDF Download

Learn transaction isolation levels MCQs, database management system test for learning online courses and test prep to practice. Database transactions quiz has multiple choice questions (MCQ), transaction isolation levels quiz questions and answers, types of storage structure, storage and file structure, transaction isolation levels tutorials for online SQL commands courses distance learning.

Database management system practice test MCQ: performing concurrent execution of transactions reduces with choices waiting time, buffer time, queue time and evaluation time problem solving skills for summative and formative assessment, competitive exam prep, interview questions with answer key. Free study guide is for online learning transaction isolation levels quiz with MCQs to practice test questions with answers.

MCQs on Transaction Isolation Levels Quiz PDF Download

MCQ. Performing concurrent execution of transactions reduces

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

A

MCQ. 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 con?ict serializability by constructing

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

C