A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?

Which is correct about the EXPLAIN statement

Which table space allows LOBs to use the filesystem cache?

What is intra-partition parallelism?

What is a technique to access non-contiguous data pages more efficiently?

Which can be done by a user who is granted the CONTROL privilege on an INDEX?

Which explicit system privileges allows the user to create new plans and packages without being able to also execute them?

An audit trace shows that TSO user TSOID1 with DBADM authority, is continually attempting to update a table in DB2 subsystem DSN1 that is not supposed to be updated. Which of the following will prevent access to the DB2 subsystem?

If you have a poorly clustered index with random synchronous I/Ss, what clause would you use to prevent an impending delay?

Given that there are two containers in table space Smart1 and the following statement: ALTER TABLESPACE Smart1 REDUCE (ALL 100 M) Which of the following will happen?

Given the following table definition: CREATE TABLE smarterer_list (empid INTEGER, points INTEGER CONSTRAINT chk CHECK (points <= 100) NOT ENFORCED ) and the statement: INSERT INTO smarterer_list VALUES (98, 100), (123,123), (101, 98) How many records will be retrieved by the following statement? SELECT * FROM smarterer_list