Database Transactions MCQs & Quiz Online PDF Book Download

Database transactions multiple choice questions (MCQs), database transactions quiz answers to learn online CS courses for database management online classes. Sql concepts and queries MCQs, database transactions quiz questions and answers for online MS degree in computer science. Learn sql data types and schemas, database views, database transactions test prep for data science certification.

Learn sql concepts and queries MCQ: once a transaction has executed commit work, its effects can no longer be undone by, with choices trace work, transmit work, rollback work, and traceback work for online MS degree in computer science. Practice merit scholarships assessment test, online learning database transactions quiz questions for competitive exams in computer science major .

MCQs on Database Transactions PDF Book Download

MCQ: Once a transaction has executed commit work, its effects can no longer be undone by

  1. Trace work
  2. Transmit work
  3. Rollback work
  4. Traceback work

C

MCQ: In case of power outage or other system crash, when system restarts, action known to be occur is of

  1. Rollback work
  2. Trace work
  3. Traceback work
  4. Commit work

A

MCQ: All statements between keywords begin atomic ...end form a/an

  1. Single transaction
  2. NO transaction
  3. Multiple transactions
  4. 2 parallel transactions only

A

MCQ: Rollback work cannot undo, once a transaction has executed by the

  1. Commit work
  2. Traceback work
  3. Trace work
  4. Transmit work

A

MCQ: How to turn off automatic commit depends on specific

  1. Database system
  2. Queries execution
  3. SQL implementation
  4. Structure design

C