3. |
If the SET IMPLICIT_TRANSACTIONS option is NOT set to ON, what will happen?
Please select the best answer.
|
|
A.
|
The database will not support implicit transactions.
|
|
B.
|
The database will support explicit transactions only.
|
|
C.
|
The database will support auto-commit transactions.
|
|
D.
|
The database will not support transactions.
|
|
The correct answer is C.
The database will support auto-commit transactions if the SET IMPLICIT_TRANSACTIONS option is not set to ON (or it is set to OFF). A is incorrect because it will support auto-commit transactions, which is an implicit transaction. B is incorrect because explicit transactions are supported, along with auto-commit transactions. D is incorrect because the database WILL support transactions.
|