What DB2 command when issued displays what migration mode the catalog is in?

Which authority level allows a user to run utilities that change the data in an application database?

Which trace gives information about frequent log space shortages?

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?

Row and column level security can be implemented using mask and permissions. Which two DB2
authorities are able to create a mask or permission? (Choose two.)

Which connection type can exploit trusted connections?

What should be implemented in order to audit all the activity of the install SYSADM?

Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth
table space?

Which ALTER TABLE statement will generate a new table space version?

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?