IBM
C2090-312 · Question #167
Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?
The correct answer is D. nn row locations per page are kept for future UPDATE operations to reduce indirect reference. See the full explanation below for the reasoning.
Question
Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?
Options
- AThe first nn UPDATE operation(s) will use an indirect reference.
- BOnly the first nn UPDATE operation(s) on the table will be processed.
- Cnn% space is reserved per page for future UPDATE operations to reduce indirect reference.
- Dnn row locations per page are kept for future UPDATE operations to reduce indirect reference.
How the community answered
(49 responses)- A4% (2)
- B6% (3)
- C12% (6)
- D78% (38)
Community Discussion
No community discussion yet for this question.