What is a federated database?

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

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?

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

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

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

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?

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

what is the root page in DB2?

What is a deadlock?

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