Question

Which of the following sql vendors does not include autocommit?

a. mysql
b. oracle
c. ms sql server
d. all of the above
e. none of the above

Answer 1

Oracle is the SQL vendor that does not enable autocommit by default, unlike MySQL and MS SQL Server which usually have autocommit enabled.

Step-by-step explanation:

Among the SQL vendors mentioned, Oracle does not include autocommit as part of its default behavior. In Oracle, a transaction needs to be explicitly committed or rolled back by the user. However, MySQL and MS SQL Server typically operate with autocommit mode enabled by default. Therefore, the correct answer to which of the following SQL vendors does not include autocommit is b. Oracle.