IBM C9050-548 問題集

質問 1：
What are DB2 access plans?
A. An access plan is one that specifies an order of operations for accessing data in a SQL query. It lets
you view statistics for selected tables, indexes, or columns; properties for operators; global information,
such as table space and function statistics; and configuration parameters relevant to optimization.
B. An access plan is part of the security audit that is performed by the DBA, with assistance from the
network administrator, to list who will have access to database from the point of view of the operating
system.
C. An access plan is the result of the planning phase for the installation of the DB2 product. It takes into
account who will access the database and which permissions they will have.
D. An access plan is a plan that is created for each table, describing which users or queries will have
access to the data that is contained in that particular table.
正解：A

質問 2：
Your IMS System uses dual OLDS logging and the Archive job runs successfully and produces one SLDS
datasets and two RLDS dataset. Archiving will make which changes to RECON Log Records?
A. A PRISLD RECON record is created; the PRILOG record will be updated to include the primary RLDS
dataset name and the SECLOG record will be updated to include the secondary RLDS dataset name.
B. A PRISLD, a PRIRLDS and a SECRLDS RECON record are created; the PRILOG record will be
updated to include the primary RLDS dataset name and the SECLOG record will be updated to include
the Secondary RLDS dataset name.
C. A PRISLD and a SECSLD RECON record are created; the PRILOG record will be updated to include
the primary RLDS dataset name and the SECLOG record will be updated to include the secondary RLDS
dataset name.
D. A PRISLD RECON record is created; the PRILOG record will be updated to include the primary SLDS
dataset name and the SECLOG record will be updated to include the secondary RLDS dataset name.
正解：A

質問 3：
What is the DB2 load utility?
A. The DB2 load utility is a tool that stores all scripts that are required to create the database. Itdoes not
load data, but just loads the database metadata that was exported for a site backup.
B. The DB2 load utility is a tool that allows you to directly transfer data from one database into theone you
are currently working with.
C. The DB2 load utility does not exist in the DB2 product.
D. The DB2 load utility is a high-speed, low-level, data loading utility that loads data into a DB2database
in four phases.
正解：D

質問 4：
What is the purpose of the Adaptive, self-tuning memory allocation feature in DB2?
A. This feature does not exist in DB2.
B. This feature will detect memory allocation expansion in the database and deliver a warning to the DBA
to let them know when the database is nearing a threshold space allocation limit.
C. This feature will help to reduce the task of configuring your DB2 server by continuously updating
configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory
to be used by the database.
D. The purpose of this feature is for the system to deliver to you a report of tuning specifications for the
database so that you can update the configuration parameters by hand.
正解：C

質問 5：
What does the table partitioning feature in DB2 allow you to do?
A. Table partitioning allows you to create result set tables from a join query, which automaticallysplits the
data into smaller chucks, thereby increasing the performance of your DB2 database.
B. Table partitioning allows you to make smaller tables automatically from large tables, therebyincreasing
the performance of your DB2 database.
C. Table partitioning allows you to create very large tables that are divided across multiplestorage objects
and attach/detach large quantities of data quickly.
D. Table partitioning is not a feature in DB2.
正解：C

質問 6：
Which one of the following options is TRUE about High Availability and Disaster Recovery (HADR)
feature?
A. HADR allows up to five HADR standby databases.
B. HADR allows up to four HADR standby databases.
C. HADR allows up to two HADR standby databases.
D. HADR allows up to three HADR standby databases.
正解：D

質問 7：
The automatic maintenance wizard is a basic administration tool that is included in DB2. Which one of the
following activities does the automatic maintenance wizard help you with?
A. Using the automatic maintenance wizard is one of the quickest ways to set up your own database.
B. Using the automatic maintenance wizard, all DB table relationships will be created automatically based
upon the same column attribute naming being used in each table.
C. The automatic maintenance wizard simplifies your DB accounting activities to justify DB2.
D. The automatic maintenance wizard allows you to create 4GL scripts to query the database using plain
English language as a query language.
正解：A