Quiz for SAVEPOINT

Q1: What does the SAVEPOINT command do in SQL?

A. Marks a point in a transaction B. Commits the transaction C. Rolls back the transaction D. Deletes data permanently

Q2: Which command allows rolling back to a specific point in a transaction?

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

Q3: Can multiple SAVEPOINTs be created in a single transaction?

A. Yes B. No C. Only two allowed D. Only one allowed

Q4: What happens if you COMMIT after setting SAVEPOINTs?

A. All SAVEPOINTs are released B. SAVEPOINTs are retained C. Only the last SAVEPOINT is kept D. Transaction fails

Q5: Which of the following best describes a SAVEPOINT?

A. Named point for rollback B. Backup of database C. User permission D. Temporary table

Q6: After issuing ROLLBACK TO SAVEPOINT, what happens to commands after that SAVEPOINT?

A. They are undone B. They are committed C. They are saved D. They are ignored

Q7: What is the syntax to set a SAVEPOINT named sp1?

A. SAVEPOINT sp1; B. SET SAVEPOINT sp1; C. SAVE sp1; D. BEGIN SAVEPOINT sp1;

Q8: What is required before using SAVEPOINT?

A. A transaction must be active B. A table must exist C. A trigger must fire D. An index must be created

Q9: What command removes a specific SAVEPOINT?

A. RELEASE SAVEPOINT B. DELETE SAVEPOINT C. REMOVE SAVEPOINT D. ROLLBACK SAVEPOINT

Q10: What is the effect of rolling back to a SAVEPOINT?

A. Restores the database to that point B. Deletes the SAVEPOINT C. Commits data up to that point D. Creates a backup

Q11: Is SAVEPOINT a DML, DDL, or TCL command?

A. TCL B. DDL C. DML D. None of the above

Q12: Can you rollback to a SAVEPOINT after releasing it?

A. No B. Yes C. Only in PostgreSQL D. Only in Oracle

Q13: SAVEPOINT can be used in which type of transaction?

A. Explicit transaction B. Implicit transaction C. DDL transaction D. None

Q14: Which database supports SAVEPOINT command?

A. PostgreSQL B. MySQL C. Oracle D. All of the above

Q15: What is the purpose of SAVEPOINT in nested transactions?

A. Provides rollback within nested blocks B. Ends the transaction C. Triggers nested commit D. Removes lock

Q16: Which of the following statements is true?

A. SAVEPOINT does not end a transaction B. SAVEPOINT ends a transaction C. SAVEPOINT starts a transaction D. SAVEPOINT commits a transaction

Q17: What does the ROLLBACK TO SAVEPOINT command do?

A. Reverts to the savepoint B. Deletes the savepoint C. Commits the savepoint D. Duplicates the savepoint

Q18: How do you name a SAVEPOINT in SQL?

A. SAVEPOINT mypoint; B. SAVE mypoint; C. SET POINT mypoint; D. DECLARE mypoint;

Q19: What happens if you ROLLBACK without SAVEPOINT?

A. Entire transaction is undone B. Only last command is undone C. Nothing D. Next command is skipped

Q20: SAVEPOINTs are released automatically when:

A. Transaction is committed B. ROLLBACK TO is used C. Next SAVEPOINT is set D. They expire after 5 min