nerdexam
IBM

C2090-610 · Question #46

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which…

The correct answer is A. BIND. See the full explanation below for the reasoning.

Question

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

Options

  • ABIND
  • BREBIND
  • CBINDADD
  • DBIND_REBIND

How the community answered

(34 responses)
  • A
    74% (25)
  • B
    3% (1)
  • C
    9% (3)
  • D
    15% (5)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice