Storage and File Structure MCQs Quiz Online PDF Download

Storage and file structure MCQs, learn database management system online test prep for distance education, online courses. Practice database transactions multiple choice questions (MCQs), storage and file structure quiz questions and answers. ETS GRE test prep on types of storage structure, transaction isolation levels, storage and file structure, transaction model tutorials for online DBMS theory courses distance learning.

Study bachelors and masters in data science degree MCQs, state in which transaction stays while it is executing is termed as, for free online courses with choices active , partially committed, initial, 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