Quiz for COMMIT and ROLLBACK

Q1: Which SQL command is used to save a transaction permanently?

A. ROLLBACK B. SAVEPOINT C. COMMIT D. EXIT

Q2: Which SQL command is used to undo changes made by a transaction?

A. COMMIT B. SAVEPOINT C. ROLLBACK D. END

Q3: After a COMMIT, which of the following is true?

A. Changes can still be rolled back B. The transaction is still open C. Changes are permanently saved D. None of the above

Q4: Which command marks the end of a successful transaction?

A. ROLLBACK B. COMMIT C. START TRANSACTION D. SAVEPOINT

Q5: If no COMMIT is issued, what happens when a program ends abruptly?

A. Changes are saved B. Changes are lost C. Partial changes are saved D. Only metadata is saved

Q6: ROLLBACK can be used to undo which of the following?

A. Only the last statement B. All uncommitted changes C. Only committed changes D. DDL statements

Q7: Can a ROLLBACK undo changes after a COMMIT?

A. Yes B. No C. Only for SELECT D. Only in stored procedures

Q8: Which of the following commands ends a transaction in SQL?

A. COMMIT B. INSERT C. SELECT D. JOIN

Q9: Which command is used to revert to a specific SAVEPOINT?

A. RELEASE SAVEPOINT B. ROLLBACK TO C. COMMIT D. END

Q10: Which of the following is not a TCL command?

A. COMMIT B. ROLLBACK C. SAVEPOINT D. DELETE

Q11: COMMIT is automatically issued after which command?

A. INSERT B. ROLLBACK C. DDL commands like CREATE D. UPDATE

Q12: Which command is used to make a transaction permanent?

A. ROLLBACK B. SAVEPOINT C. COMMIT D. ABORT

Q13: How can you prevent a COMMIT from being issued automatically?

A. Use AUTOCOMMIT OFF B. Use BEGIN C. Use TRANSACTION D. It is not possible

Q14: What happens if ROLLBACK is used after a SAVEPOINT?

A. All changes are lost B. Only changes after the SAVEPOINT are undone C. Transaction ends D. Nothing happens

Q15: Which of the following does NOT initiate a transaction?

A. SELECT B. INSERT C. UPDATE D. DELETE

Q16: Can you COMMIT inside a stored procedure?

A. Yes B. No C. Only in triggers D. Only with permission

Q17: What is the default behavior of SQL in terms of transactions?

A. Auto rollback B. Manual commit C. Auto commit D. No transaction support

Q18: How does COMMIT affect a SAVEPOINT?

A. Deletes it B. Persists it C. Invalidates it D. Resets it

Q19: What is the purpose of COMMIT?

A. To pause transaction B. To save the state temporarily C. To permanently save changes D. To delete data

Q20: Which command ensures that all changes are saved and the transaction is ended?

A. ROLLBACK B. COMMIT C. SAVEPOINT D. ABORT