Under ODBC, every SQL statement is automatically committed in auto-commit
mode. True or false?
A.
True
B.
False
C.
True only if you are using the latest version of ODBC manager
D.
True only if you are accessing ODBC via ADO
E.
True only if you are accessing ODBC via OLE DB
F.
False for any data source running on Microsoft platforms
Explanation:
In auto-commit mode, every SQL statement is a complete transaction,
which is automatically committed. In manual-commit mode, a transaction consists
of one or more statements. In manual-commit mode, when an application submits
an SQL statement and no transaction is open, the driver implicitly begins a
transaction. The transaction remains open until the application commits or rolls
back the transaction with SQLTransact.