单项选择题

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)

<上一题目录下一题>

热门试题

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

多项选择题GivenaSHEAPTHRESvalueof2560,inwhichtwocaseswillaSHEAPTHRES_SHRvalueof1024bemeaningful?（）

A.INTRA_PARALLEL NO
B.MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
C.MAX_AGENTS 100, MAX_CONNECTIONS 2000
D.MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
E.INTRA_PARALLEL YES

多项选择题Inwhichtwoenvironmentswouldintra-partitionparallelismbeused?（）

A.Single database partition, single processor
B.Single database partition, multiple processors
C.Multiple database partitions, single processor
D.Multiple database partitions, multiple processors

单项选择题AdatabaseadministratorwouldliketoexaminerepartitioningoptionsforapartitioneddatabasenamedPRODDB.Aworkloadhasbeencapturedonthesystem(Windows)andisstoredinafilenamedWORKLOAD.SQL.WhatisthepropercommandtoruntheDesignAdvisorsothatitwillevaluatetheinformationstoredinthefileandgiveadviceonre-partitioning?（）

A.db2advis -d proddb -i workload.sql -P
B.db2advis -d proddb -i workload.sql -partitioning
C.db2advis -d proddb -i workload.sql -m P
D.db2advis -d proddb -i workload.sql -m ALL