IBM
C2090-320 · Question #56
Which type of lock is obtained when using a `WITH UR' clause on an SQL SELECT statement in a data-sharing environment?
The correct answer is D. No lock is obtained. See the full explanation below for the reasoning.
Question
Which type of lock is obtained when using a `WITH UR' clause on an SQL SELECT statement in a data-sharing environment?
Options
- AU-lock
- BS-lock
- CP-lock
- DNo lock is obtained
How the community answered
(31 responses)- A3% (1)
- B6% (2)
- C13% (4)
- D77% (24)
Community Discussion
No community discussion yet for this question.