Storage and File Structure MCQs Quiz Online PDF Book Download

Storage and file structure multiple choice questions (MCQs), storage and file structure quiz answers to learn data analytics online courses. Database transactions MCQs, storage and file structure quiz questions and answers for online computer science degree programs. Learn transactions management in dbms, transaction isolation levels, storage structure in databases, storage and file structure test prep for data science certification.

Learn database transactions test MCQs: state in which transaction stays while it is executing is termed as, with choices active, partially committed, initial, and both a and c for online computer science degree programs. Practice merit scholarships assessment test, online learning storage and file structure quiz questions for competitive assessment in computer science major for data analytics certification.

MCQ on Storage and File Structure Quiz Book 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