单项选择题
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?（）
多项选择题 Inwhichtwoenvironmentswouldintra-partitionparallelismbeused?（）
单项选择题 AdatabaseadministratorwouldliketoexaminerepartitioningoptionsforapartitioneddatabasenamedPRODDB.Aworkloadhasbeencapturedonthesystem(Windows)andisstoredinafilenamedWORKLOAD.SQL.WhatisthepropercommandtoruntheDesignAdvisorsothatitwillevaluatetheinformationstoredinthefileandgiveadviceonre-partitioning?（）