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?
Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package namedCORPDATA.PKGA?
Which of the following privileges allow a user to update the comment on a sequence?
Which statement is valid about the Row and Column Access Control (RCAC) feature?
Which type of table should you use if you want to define specific time periods when data is valid?
Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?
