Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?

Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
A . All held LOB locators are retained
B . All locks that are implicitly acquired during the unit of recovery are retained
C . All rows and all logical work files of every created temporary table of the application process are deleted
D . All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated

View Answer

Answer: D

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html