IBM Assessment DB2 10 DBA for zOS Set 3

When is changing an index from non-clustering to clustering NOT allowed?

To monitor the storage used above and below the 2GB bar, what must occur?

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?

What is the maximum levels of backup that DB2 plan stability can support?

The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement?

What must be done in order to audit read access to a table?