IBM Exam C2090-320 Topic 8 Question 7 Discussion

Actual exam question for IBM's C2090-320 exam

Question #: 7
Topic #: 8

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

AAll held LOB locators are retained

BAll locks that are implicitly acquired during the unit of recovery are retained

CAll rows and all logical work files of every created temporary table of the application process are deleted

DAll cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated

Show Suggested Answer

Suggested Answer: C

by Lili at May 08, 2022, 06:59 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!