632 お客様のコメント
質問 1：
What is the DB2 health center?
A. The DB2 health center is a command-line interface to the health of the DB2 installation. Youcan make corrective changes to the DB2 installation using command line entries and query the heath of the DB2 database.
B. The DB2 health center is a GUI tool that allows you to monitor the state of the databaseenvironment and make any necessary changes to the environment.
C. The DB2 health center is the name for the support desk for the DB2 product. If you have avalid DB2 license and maintenance agreement, you may contact the heath center and havethe center monitor your DB2 installation remotely.
D. The health center does not exist in DB2.
正解：B
質問 2：
What is a buffer pool in DB2?
A. A buffer pool is a DB2 component that manages connections to databases.
B. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
C. A buffer pool is a logical storage grouping composed of one or more containers.
D. A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data asit is read from the physical media.
正解：D
質問 3：
What are some of the benefits of DB2 Express?
A. DB2 Express is faster and more powerful than the DB2 product.
B. DB2 Express is designed for development and testing. It is not used as a production database.
C. DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2 version of software.
D. DB2 Express has affordable licensing terms with all of the features of the DB2 engine.
正解：D
質問 4：
What is a DB2 transaction?
A. A DB2 transaction is a set of rules that can be imposed on data values in a table.
B. A DB2 transaction is an action that is performed by the database to ensure that tables that arereplicated are kept synchronized.
C. A DB2 transaction is a sequence of one or more statements that must complete in its entiretyor not at all. It is also referred to as a unit of work.
D. A DB2 transaction is the interface that is developed between tables, relating one table to theother.
正解：C
質問 5：
Which one of the following options contains a benefit of the Java Generic Table Functions?
A. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
B. Java Generic Table Functions can be implemented in any programming language.
C. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
D. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
正解：C
質問 6：
Each database has its own system catalog tables and views. These store metadata about the database objects. You can query them just like any other tables or views. Which of the following are some of the system catalog tables?
A. SYSMANAGEMENT, SYSCREATE, and SYSSTORE
B. SYSIBM, SYSCAT, and SYSSTAT
C. SYSLOAD, SYSALL, and SYSPASS
D. SYSSTART, SYSBACKUP, and SYSOPEN
正解：B
What is the DB2 health center?
A. The DB2 health center is a command-line interface to the health of the DB2 installation. Youcan make corrective changes to the DB2 installation using command line entries and query the heath of the DB2 database.
B. The DB2 health center is a GUI tool that allows you to monitor the state of the databaseenvironment and make any necessary changes to the environment.
C. The DB2 health center is the name for the support desk for the DB2 product. If you have avalid DB2 license and maintenance agreement, you may contact the heath center and havethe center monitor your DB2 installation remotely.
D. The health center does not exist in DB2.
正解：B
質問 2：
What is a buffer pool in DB2?
A. A buffer pool is a DB2 component that manages connections to databases.
B. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
C. A buffer pool is a logical storage grouping composed of one or more containers.
D. A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data asit is read from the physical media.
正解：D
質問 3：
What are some of the benefits of DB2 Express?
A. DB2 Express is faster and more powerful than the DB2 product.
B. DB2 Express is designed for development and testing. It is not used as a production database.
C. DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2 version of software.
D. DB2 Express has affordable licensing terms with all of the features of the DB2 engine.
正解：D
質問 4：
What is a DB2 transaction?
A. A DB2 transaction is a set of rules that can be imposed on data values in a table.
B. A DB2 transaction is an action that is performed by the database to ensure that tables that arereplicated are kept synchronized.
C. A DB2 transaction is a sequence of one or more statements that must complete in its entiretyor not at all. It is also referred to as a unit of work.
D. A DB2 transaction is the interface that is developed between tables, relating one table to theother.
正解：C
質問 5：
Which one of the following options contains a benefit of the Java Generic Table Functions?
A. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
B. Java Generic Table Functions can be implemented in any programming language.
C. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
D. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
正解：C
質問 6：
Each database has its own system catalog tables and views. These store metadata about the database objects. You can query them just like any other tables or views. Which of the following are some of the system catalog tables?
A. SYSMANAGEMENT, SYSCREATE, and SYSSTORE
B. SYSIBM, SYSCAT, and SYSSTAT
C. SYSLOAD, SYSALL, and SYSPASS
D. SYSSTART, SYSBACKUP, and SYSOPEN
正解：B
浅丘** -
二回目で合格することができました。カスタマーサービスのアドバイス通りに勉強したことで、合格することができました。どうもありがとうございました。