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
单项选择题Adatabaseadministratorwantstodesignamulti-partitiondatabasethatcantakeadvantageofbothintra-partitionparallelismandinter-partitionparallelism.Whichconfigurationwillallowtheuseofthesetypesofparallelismwhileusingtheleastnumberofhardwarecomponents(servers,processors)?()
A.one server having at least two processors B.two servers having one processor and one logical database partition C.one server having four processors and two logical database partitions D.two servers each having four processors and two logical database partitions
多项选择题WhenadatabaseadministratorchoosesthedimensionsforanMDCtable,whichtwocharacteristicsshouldbeconsidered?()
A.the query transaction rate B.numeric data versus character data C.extent size D.the cardinality of the candidate columns E.prefetch size
单项选择题Whichdataorganizationschemesaresupported?()
A.PARTITION BY HASH and ORGANIZE BY B.PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE C.PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE D.PARTITION BY RANGE and ORGANIZE BY
单项选择题IftheADDDBPARTITIONNUMcommandisusedtoaddanewdatabasepartitiontoanexistingDB2instance,whichstatementiscorrect?()
A.All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group. B.Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. C.Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. D.A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.