nerdexam
IBM

C2090-320 · Question #54

C2090-320 Question #54: Real Exam Question with Answer & Explanation

Sign in or unlock C2090-320 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.

Question

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

Options

  • 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
  • DAll cursors are closed, all prepared statements are retained, and any cursors that are associated

Unlock C2090-320 to see the answer

You've previewed enough free C2090-320 questions. Unlock C2090-320 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full C2090-320 Practice