IBM
C2090-312 · Question #126
Which statement applies to the command STOP DB(MYDB) SP() AT(COMMIT)?
The correct answer is C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point. See the full explanation below for the reasoning.
Question
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
Options
- ADoes not apply to threads that were defined with RELEASE(COMMIT).
- BDoes not apply to threads that were defined with RELEASE(DEALLOCATE).
- CApplies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.
- DApplies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at
How the community answered
(19 responses)- A5% (1)
- B5% (1)
- C79% (15)
- D11% (2)
Community Discussion
No community discussion yet for this question.