DBMS Objective Questions and Answers FAQ PDF Download

Learn dbms objective questions and answers FAQ, dbms FAQ, competency based interview questions with MCQs based online test prep. These frequently asked questions has multiple choice questions (MCQs), dbms quiz questions and answers: transaction abort processes are managed by recovery schemes by maintaining a, answer key with options log, process, file directory and command for competitive exam preparation. Free FAQ, situational interview questions are to learn dbms objective questions and answers quiz online with MCQs to practice test questions with answers.

FAQ: DBMS Objective Questions and Answers PDF Download

MCQ: Transaction abort processes are managed by recovery schemes by maintaining a

  1. Log
  2. Process
  3. File directory
  4. Command

A

MCQ: If a transaction gets aborted, responsibility of managing it is of

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

B

MCQ: Database system by ensuring atomicity can trace values of any data on which a transaction performs

  1. Read operation
  2. Write operation
  3. Query operation
  4. Retrieval operation

B

MCQ: Structure in which metadata about relations are stored is known as

  1. Data Dictionary
  2. Functional dictionary
  3. Sequence dictionary
  4. Storage dictionary

A

MCQ: Structure in which relational schemas are stored is said to be

  1. Sequence dictionary
  2. Storage dictionary
  3. Data Dictionary
  4. Functional dictionary

C