nerdexam
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)
  • A
    4% (2)
  • B
    6% (3)
  • C
    12% (6)
  • D
    78% (38)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice