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.

Computer Science & Information Technology

You might also like to view...

What role does the virtual file system (VFS) perform within the CentOS 7 kernel?

What will be an ideal response?

Computer Science & Information Technology

Internet Explorer and Safari are types of ________ software

Fill in the blank(s) with correct word

Computer Science & Information Technology

To plot a data series on a secondary vertical axis, begin by clicking theĀ  _____.

A. field name in the appropriate field section B. reference command of the tool you want to use C. data series that you want to plot D. existing external data source you want to use

Computer Science & Information Technology

In a pretest loop, what initializes the loop condition by providing its first value?

A. sentinel value B. update read C. priming read D. none of the above

Computer Science & Information Technology