Which of the following kinds of table spaces 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?

DB2 Enterprise Server Edition (ESE) is running on Linux and needs to validate the userids and passwords on the z/OS server for the DB2 clients connecting to DB2 for z/OS. Which of the following authentication levels satisfies this while providing authentication for other DB2 clients at the DB2 ESE server?

Which of the following is not a statistic collected during RUNSTATS

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

What table space characteristic can affect how your compiler operates?