1.
What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?
2.
In the CFRM policy, what is the purpose of the PREFLIST?
3.
Which authority level allows a user to run utilities that change the data in an application database?
4.
Which trace gives information about frequent log space shortages?
5.
When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?
6.
Which connection type can exploit trusted connections?
7.
What should be implemented in order to audit all the activity of the install SYSADM?
8.
Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?
9.
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
10.
When defining a foreign key on a table, which statement is true?