COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following are TCL commands?
|
UPDATE and TRUNCATE
|
|
SELECT and INSERT
|
|
GRANT and REVOKE
|
|
ROLLBACK and SAVEPOINT
|
Explanation:
Detailed explanation-1: -There are three main commands in TCL: Commit. Rollback. Savepoint.
Detailed explanation-2: -TCL (Transaction Control Language) : COMMIT: Commit command is used to permanently save any transaction into the database. ROLLBACK: This command restores the database to last committed state. It is also used with savepoint command to jump to a savepoint in a transaction.
Detailed explanation-3: -The TCL commands are: COMMIT. ROLLBACK. SAVEPOINT.
Detailed explanation-4: -There are basically 3 TCL commands: Commit, Rollback, and Savepoint. The COMMIT command is used to permanently save any transaction into the database. The ROLLBACK command basically restores the database to the last committed state.
There is 1 question to complete.