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 an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
D. A buffer pool is a logical storage grouping composed of one or more containers.
正解:C
質問 2:
What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
B. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
C. STMM allows DBAs to inspect the current memory allocation by buffer pools.
D. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
正解:D
質問 3:
What are some of the benefits of DB2 Express?
A. DB2 Express is designed for development and testing. It is not used as a production database.
B. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
C. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
D. DB2 Express is fastest and most powerful DB2 edition.
正解:B
質問 4:
Which one of the following options is TRUE about DB2 pureScale?
A. DB2 pureScale feature does not support range-partitioning tables.
B. DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).
C. A DB2 pureScale installation is only supported on AIX platform.
D. DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).
正解:D
松田** -
内容もしっかりしているし、かなりコスパが高いです。非常に役に立っています。