최신IBM DB2 10.1 DBA for Linux, UNIX, and Windows - 000-611무료샘플문제

A. Insert, update, and delete operations can be performed against table TAB2.

B. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.

C. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.

D. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.

A. A table-level compression dictionary does not already exist for the table.

B. The table contains a sufficient amount of data.

C. The table does not have any indexes defined on it that have not been enabled for compression.

D. The table is not a system temporary table.

E. A page-level compression dictionary does not already exist for the table.

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

B. Add a SECURED WITH clause to every column in the SALES table.

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

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

A. SYSCTRL

B. SQLADM

C. SECADM

D. SYSADM

A. db2cfimp

B. db2ca

C. db2cfexp

D. db2cfgimp

A. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.

B. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.

C. An existing MDC table can be converted to an ITC table.

D. ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.