本文发表在 rolia.net 枫下论坛Hi All,

I got several questions durning the test of IBM test website. Can anyone answer these questions?

1. Which of the following Command Center features is also accessible from the CLP?

a) Ability to scroll through the results of an explain snapshot

b) Ability to log commands in a history file

c) Ability to assist in creating SQL statements

d) Ability to limit the size of the output

2. Which of the following tasks is performed by the DB2 LOAD?

a) Reorganizing data

b) Creating the table

c) Altering table structure

d) Collecting table statistics

3. Given the catalog view
SYSSTAT.INDEXS
indschema indname nleaf nlevels firstkeycard fullkeycard clusterratio
ADMIN PAYPOLL1 -1 -1 -1 -1 -1
ADMIN PAYORLL2 -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

4.when will a specific performance variable enter one of the red zones in the performance monitoring graph?
a) When a variable exceeds a threshold defined by the DB2 server

b) When too many variables have been defined

c) When too many users are connecting to the database

d) When a variable exceeds a threshold defined by the user

e) When too much swapping occurs

Any reply will be appreciated. Thanks in advance.

Cat更多精彩文章及讨论，请光临枫下论坛 rolia.net