单项选择题
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.
相关考题
-
单项选择题
TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1,C2andC3together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?（）
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) -
单项选择题
Abatchapplicationexecutesalargenumberofupdatestatements.Theservicelevelagreementfortheapplicationstatesthattheapplicationmustcompleteitsworkasquicklyaspossibletoensurethatdependentworkloadscanstartontime.Whatisonewaytohelptheapplicationcompletequickly?（）
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. -
单项选择题
IfthesortheapthresholdparameterSHEAPTHRES_SHRissettoavalueof0,whatwillhappen?（）
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.
