Question

A transaction is delimited by statements (or function calls) of the form __________

(a) Begin transaction and end transaction

(b) Start transaction and stop transaction

(c) Get transaction and post transaction

(d) Read transaction and write transaction

The question was asked at a job interview.

Question is taken from Transaction Concept in chapter Transactions of Database Management

Answer 1

The correct choice is (a) Begin transaction and end transaction

The explanation is: The transaction consists of all operations executed between the begin transaction and end transaction.