Storage and File Structure MCQs Quiz Online PDF Download

Learn storage and file structure MCQs, database management system test for learning online courses and test prep to practice. Database transactions quiz has multiple choice questions (MCQ), 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.

Database management system practice test MCQ: state in which transaction stays while it is executing is termed as with choices active , partially committed, initial and both a and c problem solving skills for summative and formative assessment, competitive exam prep, interview questions with answer key. Free study guide is for online learning storage and file structure quiz with MCQs to practice test questions with 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