多项选择题
In which two environments would intra-partition parallelism be used? （）
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
