Storage and File Structure MCQs & Quiz Online PDF Download

Storage and file structure MCQs, storage and file structure quiz answers pdf to study online database course. Learn database transactions Multiple Choice Questions and Answers (MCQs), "storage and file structure" quiz questions and answers for computer majors. Learn transaction isolation levels, storage structure in databases, storage and file structure test prep for free online classes.

"The state in which the transaction stays while it is executing is termed as" Multiple Choice Questions (MCQ) on storage and file structure with choices active, partially committed, initial, and both a and c for computer majors. Practice merit scholarships assessment test, online learning storage and file structure quiz questions for competitive exams in computer science major for best online schools for computer science.

MCQs on Storage and File Structure PDF Online Download

MCQ: The state in which the transaction stays while it is executing is termed as

  1. Active
  2. Partially committed
  3. Initial
  4. Both A and C

D

MCQ: The 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 the 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 the responsibility of

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

B