Storage Structure in Databases MCQs Quiz Online PDF Download

Learn storage structure in databases MCQs, database management system test for online learning courses, test prep to practice test. Database transactions MCQs, storage structure in databases multiple choice questions and answers, types of storage structure, transaction isolation levels, storage and file structure, storage structure in databases tutorials for online SQL basics courses distance learning.

Database management system practice test MCQ: examples of nonvolatile storage are magnetic disks and with options flash memory , main memory , cache memory and primary memory for formative assessment, summative assessment of students and jobs seekers with online courses and jobs tests. Free study guide is for online learning storage structure in databases quiz questions with MCQs to practice test questions with answers.

MCQs on Storage Structure in Databases Quiz PDF Download

MCQ: Examples of nonvolatile storage are magnetic disks and

  1. Flash memory
  2. Main memory
  3. Cache memory
  4. Primary memory

A

MCQ: When changes made by aborted transaction has been undone, transaction is said to be

  1. Committed
  2. Derived
  3. Rolled back
  4. Depicted

C

MCQ: Any changes made by aborted transaction to database, must be

  1. Completed
  2. Done
  3. Undone
  4. Displayed

C

MCQ: Examples of volatile storage are main memory and

  1. Cache memory
  2. Magnetic disk
  3. Flash memory
  4. Magnetic tapes

A

MCQ: If a transaction is not able to complete its execution successfully, it is said to be

  1. Rolled back
  2. Logged
  3. Terminated
  4. Aborted

D