What would indicate intra-partition parallelism in an Optimizer Plan?（）

单项选择题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.

单项选择题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.