Storage and File Structure MCQs Quiz Online PDF Download

Learn storage and file structure MCQs online, database management system test for e-learning degree online courses, career test prep. Practice database transactions multiple choice questions (MCQs), storage and file structure quiz questions and answers, types of storage structure, transaction isolation levels, storage and file structure tutorials for online DBMS theory courses distance learning.

Study bachelor's and master's degree courses, online computer science degree programs MCQs: state in which transaction stays while it is executing is termed as with options active , partially committed, initial and both a and c with distance learning, competitive exams preparation for national and international universities' admissions. Free skills assessment test is for online learning storage and file structure quiz questions with MCQs, exam preparation questions and answers.

MCQs on Storage and File Structure Quiz PDF Download

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: Effects of a committed transaction can be undo by executing a

  1. Compound transaction
  2. Composite transaction
  3. Compensating transaction
  4. Common transaction

C

MCQ: A transaction must be in one of states from

  1. 3 states
  2. 4 states
  3. 5 states
  4. 6 states

C

MCQ: Recovering schemes manages transactions aborts by maintaining a/an

  1. Log
  2. Process
  3. File directory
  4. Command

A

MCQ: Managing transactions aborts is responsibility of

  1. Evaluation scheme
  2. Recovery scheme
  3. Control scheme
  4. Execution scheme

B