Transaction Isolation Levels MCQs Quiz Online PDF Download

Transaction isolation levels MCQs, learn dbms online test prep for IT degree, online courses. Practice database transactions multiple choice questions (MCQs), transaction isolation levels quiz questions and answers. Career test prep on types of storage structure, transaction isolation levels, storage and file structure, transaction model aptitude test for online SQL commands courses distance learning.

Study database transactions aptitude test MCQs: performing concurrent execution of transactions reduces, for free online computer science courses with choices waiting time, buffer time, queue time , 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