MCQ Practice Single Best Answer Topic: Module 14: Database Manipulation

Q What are the three keywords associated with the Transaction Tracking System?

Question ID
#9397
Subchapter
Module 14: Database Manipulation
Action
Choose one option below

Choose Your Answer

Click an option to check whether your answer is correct.

  • A ttsBegin
  • B ttsCommit
  • C ttsAbort
  • D All
Correct Answer: D

Explanation

Justification:

  • ttsBegin- You mark the beginning of the transaction with ttsbegin.
  • ttsCommit - You mark the successful end of a transaction with a ttscommit.
  • ttsEnd is not a valid command for the transaction tracking system.
  • ttsCommence is not a valid command for the transaction tracking system.
  • ttsAbort - This can be used as an exception to make a transaction be aborted and rolled back to its state before the ttsbegin. You insert a ttsAbort wherever you want this to occur.
  •  

    Related Lesson: Transaction Integrity Checking

Share This Question

Share this MCQ with your friends or study group.