C2090-312 IBM DB2 11 DBA for z/OS

Loading demo links...

Showing 7–7 of 7 questions

Question 7

Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?

Select an option, then click Submit answer.

  • The first nn UPDATE operation(s) will use an indirect referencE.

  • Only the first nn UPDATE operation(s) on the table will be processeD.

  • nn% space is reserved per page for future UPDATE operations to reduce indirect referencE.

  • nn row locations per page are kept for future UPDATE operations to reduce indirect referencE.