Quiz for RELEASE SAVEPOINT

Q1: What does RELEASE SAVEPOINT do?

A. Deletes the transaction B. Reverts to a savepoint C. Removes a previously set savepoint D. Starts a transaction

Q2: What does the RELEASE SAVEPOINT command do?

A. Deletes a savepoint B. Commits the transaction C. Rollbacks to the savepoint D. Creates a new savepoint

Q3: Can you rollback to a savepoint after it has been released?

A. Yes B. No C. Only if within the same session D. Only for read operations

Q4: Which SQL command is used to remove a savepoint?

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

Q5: When is it beneficial to use RELEASE SAVEPOINT?

A. To reduce overhead B. To log transactions C. To rollback changes D. To start a new transaction

Q6: What happens if you try to release a non-existent savepoint?

A. It will rollback B. It will throw an error C. It will be ignored D. A new savepoint is created

Q7: In which transaction control category does RELEASE SAVEPOINT fall?

A. DCL B. DDL C. TCL D. DML

Q8: Which is a valid syntax for releasing a savepoint named sp1?

A. DELETE SAVEPOINT sp1; B. REMOVE SAVEPOINT sp1; C. RELEASE SAVEPOINT sp1; D. ROLLBACK TO SAVEPOINT sp1;

Q9: Does RELEASE SAVEPOINT commit the transaction?

A. Yes B. No C. Only partially D. Depends on database

Q10: Can you release a savepoint after a COMMIT?

A. Yes B. No C. Only with special privileges D. Only in Oracle

Q11: Which of these is not related to savepoints?

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

Q12: Is RELEASE SAVEPOINT available in all SQL dialects?

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

Q13: Which command can you use after creating a savepoint?

A. RELEASE SAVEPOINT B. DROP SAVEPOINT C. UNDO SAVEPOINT D. END SAVEPOINT

Q14: What is the main reason to use RELEASE SAVEPOINT?

A. Security B. Performance C. Syntax clarity D. Debugging

Q15: Can you reuse a savepoint name after releasing it?

A. Yes B. No C. Only in stored procedures D. Only after rollback

Q16: Does RELEASE SAVEPOINT end the transaction?

A. Yes B. No C. Only in MySQL D. Only for temporary transactions

Q17: How many savepoints can be released in a transaction?

A. Only 1 B. Only 2 C. Unlimited D. None

Q18: What does RELEASE SAVEPOINT do in PostgreSQL?

A. Ends the transaction B. Deletes a savepoint C. Reverts changes D. Starts a transaction

Q19: Which of the following is true?

A. RELEASE SAVEPOINT removes a named point in a transaction B. It creates a new savepoint C. It is used only after commit D. It changes table structure

Q20: Which command follows this sequence: BEGIN → SAVEPOINT → ? → COMMIT

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

Q21: Why should you release unused savepoints?

A. To reduce memory usage B. To prevent commit C. To prevent deadlock D. To avoid primary key conflict