Which of the following index type will cause the rows of the table to be arranged on the disk according to the ordering of their index keys?

Which COPY utility statements will backup table space DBTAB1.TS1 preparing 2 copies for local use and 2 copies for disater recovery use?

What is a deadlock?

what is the root page in DB2?

Which table space characteristics for a system Managed (SMS) table space can be modified with the ALTER TABLESPACE Statements?

Which can a DBA do to determine what an image copies, active logs and archive logs will  be required for the recovery of a table space?

Why would you want to specify an optimization class when compiling an SQL query?

When writing a query with a primary key, how would the DISTINCT clause be applied?

Which two of the following types of storage management methods are supported by DB2 OLAP Server?

A DBA wishes to audit all access to the non-audited table OWNER.Smartemp. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?

What object types is the lock mode S (Share) applicable to?