单项选择题

Which action(s) will cause a compression dictionary to be removed from a table?（）

A.Set the table COMPRESS attribute to NO.
B.Set the table COMPRESS attribute to NO; run REORG against the table.
C.Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.
D.Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

点击查看答案

上一题目录下一题

相关考题

单项选择题

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）

A.CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
B.CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
C.CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
D.CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)

单项选择题

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

A.Code the application to issue a LOCK TABLE statement.
B.Code the application to issue a LOCK ROW statement.
C.Decrease the number of I/O servers.
D.Increase the locklist parameter.

单项选择题

If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）

A.All sorts will be done in a temporary table space.
B.The shared sort memory allocation will be calculated by DB2
C.No shared memory is allocated for sorting.
D.All sorts will be done in shared memory.