单项选择题
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?（）
单项选择题 Abatchapplicationexecutesalargenumberofupdatestatements.Theservicelevelagreementfortheapplicationstatesthattheapplicationmustcompleteitsworkasquicklyaspossibletoensurethatdependentworkloadscanstartontime.Whatisonewaytohelptheapplicationcompletequickly?（）
单项选择题 IfthesortheapthresholdparameterSHEAPTHRES_SHRissettoavalueof0,whatwillhappen?（）