PrepAway - Latest Free Exam Questions & Answers

True or false?

Under ODBC, every SQL statement is automatically committed in auto-commit
mode. True or false?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply