单项选择题
What would indicate intra-partition parallelism in an Optimizer Plan?（）
A.BTQ
B.LTQ
C.IP
D.DTQ
相关考题
-
单项选择题
TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1andC2together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?（）
A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)
B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2)
C. CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)
D. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1） -
单项选择题
Whenistheconnectionconcentratorenabled?（）
A.When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS.
B.When the value of MAX_AGENTS is greater than the value of MAX_CLIENTS.
C.When the value of NUM_AGENTS is greater than the value of MAX_AGENTS.
D.When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS. -
单项选择题
Whichaction(s)willcauseacompressiondictionarytoberemovedfromatable?（）
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.
