A. Immediately after the ALTER TABLE DETACH statement is executed.

B. Immediately after asynchronous partition detach processing completes for this data partition.

C. After a SET INTEGRITY statement is executed.

D. After a truncate table operation is performed in the background.

A. Cascaded

B. Remote

C. Local

D. Client

E. Server

A. 3 dimension-block indexes and 1 composite-block index

B. 3 dimension-block indexes and 3 composite-block indexes

C. 1 dimension-block index and 3 composite-block indexes

D. 1 dimension-block index and 1 composite-block index

A. SECADM

B. SQLADM

C. SYSADM

D. DBADM

A. SYSTOOLSSPACE

B. TEMPSPACE1

C. USERSPACE1

D. SYSCATSPACE

A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.

B. You can specify that tables be compressed by using either a table-level dictionary only, page-level dictionaries only, or both table-level andpage-level dictionaries.

C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.

D. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.

A. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.

B. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.

C. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.

D. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.

A. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.

B. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.

C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.

D. A trusted context defines a trust relationship for a connection between the database and an external entity.

A. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).

B. Users with SECADM authority are exempt from RCAC rules.

C. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.

D. When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.

A. Associate the SEC_POLICY security policy with the SALES table.

B. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

C. Add a column with the DB2SECURITYLABEL data type to the SALES table.

D. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.