Transaction Control Language (TCL) MCQs in DBMS

1. Which of the following is not a TCL command?

(A) COMMIT

(B) SAVEPOINT

(C) ROLLBACK

(D) SELECT

2. What does the COMMIT command do in a transaction?

(A) It ends the current transaction and makes all changes made by the transaction permanent.

(B) It saves the current state of the transaction.

(C) It undoes all the changes made in the current transaction.

(D) It starts a new transaction.

3. Which command is used to undo all the changes made in the current transaction?

(A) COMMIT

(B) SAVEPOINT

(C) ROLLBACK

(D) GRANT

4. What is the purpose of the SAVEPOINT command?

(A) To end a transaction and make all changes permanent.

(B) To save the current state of a transaction so that changes can be rolled back to that point if needed.

(C) To undo all changes made in the current transaction.

(D) To start a new transaction.

5. Which command is used to roll back a transaction to a specific savepoint?

(A) COMMIT

(B) SAVEPOINT

(C) ROLLBACK TO SAVEPOINT

(D) GRANT

6. If a transaction has several savepoints and you issue a ROLLBACK TO SAVEPOINT command, what happens to the changes made after the savepoint?

(A) They are committed.

(B) They are undone.

(C) They remain unchanged.

(D) None of the above.

7. In which scenario would you use the ROLLBACK command?

(A) When you want to make the changes made by the transaction permanent.

(B) When you want to undo changes made in a transaction due to an error or user decision.

(C) When you want to create a new savepoint.

(D) When you want to grant privileges to a user.

8. What happens if you issue a COMMIT command within a transaction that has savepoints?

(A) Only changes after the last savepoint are committed.

(B) All changes made by the transaction, including those before and after savepoints, are committed.

(C) Changes are committed only up to the first savepoint.

(D) The transaction is rolled back.

9. Which command is used to permanently save all the transactions in the database?

(A) COMMIT

(B) SAVEPOINT

(C) ROLLBACK

(D) REVOKE

10. What is the primary purpose of Transaction Control Language (TCL) commands in DBMS?

(A) To manage and control the execution of transactions to maintain data integrity.

(B) To define the structure of the database.

(C) To grant and revoke privileges to users.

(D) To retrieve data from the database.