1.
A user invoking a user-defined function requires which DB2 privilege?
2.
Which of the following is a characteristics of a schema ?
3.
Which of the following commands is used retrieve database names from the local catalog for DRDA host database on System I and System Z?
4.
Which of the following privileges permits a user to update the comment on a sequence?
5.
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?
6.
Which of the following best describes the age of the data in an OLTP system?
7.
A programmer wants to generate values for a numeric ID Column in their EXPENSE table. The ID Column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. When DB2 object can be referenced by an INSERT statement to meet this requirement?
8.
Which of the following best describes how locks are used in DB2?
9.
On which of the following database objects may the SELECT privilege be controlled?
10.
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?