Why is an explicit transaction end statement needed in SQL but not an explicit begin statement?
What will be an ideal response?
A transaction is an atomic operation. It has only one way to begin, that is, with "Begin
Transaction" command but it could end up in two ways: Successfully installs its updates to the database (i.e., commit) or Removes its partial updates (which may be incorrect) from the database (abort). Thus, it is important for the database systems to identify the right way of ending a transaction. It is for this reason an "End" command is needed in SQL2 query.
You might also like to view...
A linked list has the functions insertAtFront, removeFromFront, insertAtBack, and removeFromBack, which perform operations on nodes exactly as their names describe. Which two functions would most naturally model the operation of a queue?
a) insertAtBack and removeFromBack. b) insertAtBack and removeFromFront. c) insertAtFront and removeFromFront. d) insertAtFront and removeFromBack.
An ____________ allows data to flow from your program.
(a) input stream (b) output stream (c) file name (d) all of the above