Free C2090-312 – IBM DB2 11 DBA for z/OS Practice Test Question

Free demo downloads

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.