我做过的一份……天啊还要分成两部分：（

16)  
Which of the following will capture static SQL explain snapshots for an application?  
    a)   The EXPLAIN YES bind option  
    b)   The EXPLSNAP YES bind option  
    c)   The SET CURRENT EXPLAIN SNAPSHOT YES statement  
    d)   The SET CURRENT EXPLAIN SNAPSHOT EXPLAIN statement  
Single Select - Please select the best answer (one and only one choice must be selected).   
17)  
Given the following scenario:
GET SNAPSHOT FOR ALL DATABASES
       Database Snapshot
Database name                            = SAMPLE
..... Sort overflows                    = 18
Which of the following actions will NOT reduce sort overflows?   
    a)   Create an index  
    b)   Increase sort heap size  
    c)   Reorganize sorted tables  
   d)   Update statistics on sorted tables  
    e)   Decrease number of concurrent users  
Single Select - Please select the best answer (one and only one choice must be selected).   
18)  
In which of the following is the size of the buffer used during an online backup defined?  
    a)   DB2_BACKUPSZ registry variable  
    b)   DBM configuration of database instance  
    c)   DBM.INI file for the database instance  
    d)   DB configuration for database being backed up  
Single Select - Please select the best answer (one and only one choice must be selected).   
19)  
Which of the following in Visual Explain output indicates that intra-partition parallelism is being used in the access strategy?  
    a)   sort table queues  
    b)   local table queue   
    c)   remote table queue  
    d)   look-ahead table queue  
Single Select - Please select the best answer (one and only one choice must be selected).   
20)  
Which of the following DB2 utilities can insert data into a DRDA host database?  
    a)   LOAD  
    b)   EXPORT  
    c)   IMPORT  
    d)   UPLOAD  
    e)   FORCEIN  
Single Select - Please select the best answer (one and only one choice must be selected).   
21)  
Which of the following DB2 utilities can add data to a table with a primary key defined and have all rows which violate the primary key constraint stored in an exception table?  
    a)   LOAD  
   b)   FORCE   
   c)   EXPORT  
   d)   IMPORT   
   e)   UPLOAD  
Single Select - Please select the best answer (one and only one choice must be selected).   

22)  
Given the catalog view:
SYSSTAT.INDEXES
indschema indname nleaf nlevels firstkeycard fullkeycard clusterratio
ADMIN PAYROLL1   -1   -1   -1   -1   -1
ADMIN PAYROLL2   -1   -1   -1   -1   -1
Which of the following is the first step to improving query response time?   
    a)   Drop these indexes  
    b)   Reorganize the table based on index PAYROLL1  
    c)   Reorganize the table based on index PAYROLL2  
    d)   Run statistics on the base tables for these indexes  
Single Select - Please select the best answer (one and only one choice must be selected).   
23)  
Which of the following file formats allows for the creation of a table during import?  
    a)   ASC  
    b)   IXF  
    c)   MDB  
    d)   TXT  
    e)   WSF  
Single Select - Please select the best answer (one and only one choice must be selected).   
24)  
Online index reorganization is the ability to reclaim index free space after deletion of an index key. Which of the following options gives an index this capability?  
    a)   CREATE INDEX ..... ONLINE  
    b)   CREATE INDEX ..... RECLAIM  
    c)   CREATE INDEX .... MINPCTUSED  
    d)   CREATE INDEX .... REORGSPACE  
Single Select - Please select the best answer (one and only one choice must be selected).   
25)  
The location of the DB2DIAG.LOG file is specified in which of the following?  
    a)   db2.ini file  
    b)   DB2 registry  
    c)   Database directory  
    d)   Database configuration  
    e)   Database manager configuration  
Single Select - Please select the best answer (one and only one choice must be selected).