Transaction Isolation Levels MCQs Quiz Online PDF Download

Learn transaction isolation levels MCQs online, database management system test for e-learning degree online courses, career test prep. Practice database transactions 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.

Study bachelors and masters degree courses, online computer science degree programs MCQ: performing concurrent execution of transactions reduces with options waiting time, buffer time, queue time and evaluation time for online tutoring, subjective theory tests and online associate of science degree preparation. Free skills assessment test is for online learning transaction isolation levels quiz questions with MCQs, exam preparation questions and 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