Quiz for SAVEPOINT

Q1: What is the purpose of SAVEPOINT in SQL?

A. To save data permanently B. To mark a point for partial rollback C. To reset all transactions D. To end a session

Q2: What is the purpose of a SAVEPOINT in SQL?

A. To mark a point to which you can roll back later B. To commit a transaction C. To end a transaction D. To start a transaction

Q3: Which command is used to define a SAVEPOINT?

A. DEFINE SAVEPOINT B. SAVEPOINT C. MARK D. ROLLBACK TO

Q4: What will happen if you ROLLBACK to a SAVEPOINT?

A. All transactions will be undone B. Only committed changes are undone C. Changes after the savepoint will be undone D. Nothing will happen

Q5: Can you create multiple SAVEPOINTs in a single transaction?

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

Q6: Which command is used to remove a SAVEPOINT?

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

Q7: After rolling back to a SAVEPOINT, can you still COMMIT the transaction?

A. Yes B. No C. Only if all changes are rolled back D. Only if savepoint is released

Q8: Which of the following is TRUE about SAVEPOINTs?

A. They can be nested B. They cannot be used with ROLLBACK C. They are automatically committed D. They are permanent

Q9: What is the default scope of a SAVEPOINT?

A. Session B. Transaction C. Database D. Table

Q10: When are SAVEPOINTs invalidated?

A. After a commit B. After a rollback C. After creation D. Never

Q11: What happens if you ROLLBACK after a RELEASE SAVEPOINT?

A. Rollback fails B. Transaction ends C. Previous savepoint is used D. All savepoints are recreated

Q12: Which SQL standard introduced SAVEPOINTs?

A. SQL-92 B. SQL:1999 C. SQL:2003 D. SQL-86

Q13: Is SAVEPOINT supported in all RDBMS?

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

Q14: How do you rollback to a named SAVEPOINT?

A. ROLLBACK named B. ROLLBACK TO name C. ROLLBACK name D. ROLLBACK SAVE name

Q15: Which command creates a savepoint named S1?

A. SAVEPOINT S1 B. ROLLBACK S1 C. BEGIN S1 D. DEFINE S1

Q16: Which of the following invalidates all SAVEPOINTs?

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

Q17: SAVEPOINTs are mostly used in which situations?

A. To enhance performance B. For partial rollback C. To improve security D. To log transactions

Q18: Which of the following is the correct use of SAVEPOINT?

A. SAVEPOINT myPoint; B. SAVE myPoint; C. CREATE SAVEPOINT myPoint; D. SAVEPOINT = myPoint;

Q19: What happens if you try to rollback to a non-existent SAVEPOINT?

A. System creates it B. Ignored C. Error occurs D. Transaction commits