Quiz for COMMIT

Q1: What does the COMMIT command do in SQL?

A. Cancels a transaction B. Saves all changes permanently C. Rolls back all changes D. Starts a new transaction

Q2: What does the COMMIT statement do in SQL?

A. Saves changes made by the transaction B. Rolls back changes C. Starts a transaction D. Ends the session

Q3: Which keyword makes changes permanent in a transaction?

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

Q4: After a COMMIT is issued, what can be done to undo changes?

A. Use UNDO B. Use ROLLBACK C. Restart the session D. Nothing

Q5: When is COMMIT automatically executed?

A. After DELETE B. At the end of a successful DML operation C. When a session is closed normally D. During syntax check

Q6: Which of the following best describes COMMIT?

A. Makes all changes temporary B. Reverts changes C. Makes all changes permanent D. Creates backup

Q7: Can COMMIT be used without a transaction block?

A. Yes, always B. No C. Only in triggers D. It depends on the DBMS

Q8: What is the result of COMMIT if there are no changes?

A. Error is thrown B. Previous transaction is committed again C. Nothing happens D. Rollback occurs

Q9: Which of these is true about COMMIT?

A. It releases all locks held B. It retains locks C. It aborts transaction D. It deletes logs

Q10: What is the default behavior of DML statements in most SQL environments?

A. Auto-commit is ON B. Auto-commit is OFF C. They fail by default D. They rollback automatically

Q11: Which command is used to end a successful transaction?

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

Q12: Which statement is true after issuing COMMIT?

A. You can still undo changes B. Changes are saved permanently C. Transaction is still active D. Locks are retained

Q13: What is the behavior of COMMIT in a nested transaction in SQL Server?

A. Commits entire transaction stack B. Commits only the inner transaction C. Raises error D. Creates savepoint

Q14: Which of the following comes after COMMIT in transaction flow?

A. BEGIN B. SAVEPOINT C. Another transaction or END D. LOCK TABLE

Q15: Which keyword is opposite in function to COMMIT?

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

Q16: How can you avoid losing changes if a system crash occurs?

A. Use COMMIT frequently B. Never use COMMIT C. Only use SELECT D. Use ROLLBACK

Q17: What happens to savepoints after COMMIT?

A. They remain active B. They are deleted C. They are locked D. They are backed up

Q18: Which SQL clause is commonly used with COMMIT to handle errors?

A. EXCEPTION B. TRY C. CATCH D. None, SQL uses error handling outside COMMIT

Q19: Which transaction control command is used before COMMIT to save state?

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

Q20: When using COMMIT, which property of ACID is directly fulfilled?

A. Atomicity B. Consistency C. Isolation D. Durability

Q21: Which SQL command sequence is correct?

A. BEGIN, SAVEPOINT, COMMIT B. COMMIT, BEGIN, ROLLBACK C. ROLLBACK, SAVEPOINT, COMMIT D. SAVEPOINT, BEGIN, COMMIT