Technical Interview Questions DBMS Interview Questions PDF Download

Learn technical interview questions dbms interview questions, dbms FAQs for online MCQs based test prep. These frequently asked questions has multiple choice questions (MCQ), dbms quiz questions and answers as state of transaction, when a transaction nishes its nal statement, it enters , answer key with choices as partially committed state, committed state , active state and evaluate state for competitive exam preparation. Free frequently asked questions are to learn technical interview questions dbms interview questions quiz online with MCQs to practice test questions with answers.

FAQs Technical Interview Questions DBMS Interview Questions PDF Download

MCQ. State of transaction, when a transaction ?nishes its ?nal statement, it enters

  1. Partially committed state
  2. Committed state
  3. Active state
  4. Evaluate state

A

MCQ. In concurrency control, a scheme named time stamp-ordering scheme ensures

  1. Serializability
  2. Cascadeness
  3. Atomicity
  4. Consistency

A

MCQ. Concurrency-control schemes are introduced to ensure

  1. Serializability
  2. Consistency
  3. Timeouts
  4. Locking states

A

MCQ. A state of transaction, in which basic transaction operation starts is said to be

  1. Active state
  2. Partially committed state
  3. Committed state
  4. Execute state

A

MCQ. In concurrent transactions, deadlocks can be broken down by

  1. Committing one or more transactions
  2. Aborting one or more transactions
  3. Rolling back one or more transactions
  4. Terminating one or more transactions

C