database transactions

mcqspedia.com has 5 Question/Answers about Topic database transactions

How to turn off automatic commit depends on specific

How to turn off automatic commit depends on specific
  • A. Database system
  • B. Queries execution
  • C. SQL implementation
  • D. Structure design
  • Correct Answer: Option C

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

Rollback work cannot undo, once a transaction has executed by the
  • A. Commit work
  • B. Traceback work
  • C. Trace work
  • D. Transmit work
  • Correct Answer: Option A

All statements between keywords begin atomic …end form a/an

All statements between keywords begin atomic …end form a/an
  • A. Single transaction
  • B. NO transaction
  • C. Multiple transactions
  • D. 2 parallel transactions only
  • Correct Answer: Option A

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

In case of power outage or other system crash, when system restarts, action known to be occur is of
  • A. Rollback work
  • B. Trace work
  • C. Traceback work
  • D. Commit work
  • Correct Answer: Option A

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

Once a transaction has executed commit work, its effects can no longer be undone by
  • A. Trace work
  • B. Transmit work
  • C. Rollback work
  • D. Traceback work
  • Correct Answer: Option C