MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following are TCL commands?

A	UPDATE and TRUNCATE
B	SELECT and INSERT
C	GRANT and REVOKE
D	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.