DATABASE MANAGEMENT SYSTEM
What TCL commands are supported by SQL?
Ans. SQL supports following TCL commands
BEGIN |START TRANSACTION-Marks the beginning of a transaction COMMIT-Ends the current transaction by saving database changes and starts a new transaction. ROLLBACK-Ends the current transaction by discarding changes and starts a new transaction.SAVEPOINT-Defines breakpoints for the transactions to allow partial rollbacks. SET AUTOCOMMIT-Enables or disable the default autocommit mode.
0 Comments