000-N18 試験問題を無料オンラインアクセス

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

• A.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.
• B.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.
• C.STMM allows DBAs to inspect the current memory allocation by buffer pools.
• D.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.

The following are true about the Configuration Advisor, EXCEPT:

• A.To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
• B.By default, the Configuration Advisor is automatically executed when you create a new database.
• C.It creates database objects such as indexes and MQTs to improve performance.
• D.It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.

Which of the following options does NOT describe a benefit of DB2's Row Compression?

• A.Compression allows you to reduce CPU workload because there is less data to process.
• B.Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).
• C.Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
• D.Compression allows you to cache more data in the buffer pools using the same amount of space.

What is a table space in DB2?

• A.A table space is a space reserved for catalog tables and base table data.
• B.A table space is a logical storage grouping that can be composed of one or more containers.
• C.A table space 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 table space is a DB2 component that manages access to databases.

The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?

• A.Adaptive Compression
• B.Temporary Tables Compression
• C.Declared Global Temporary Tables Compression
• D.Classic Row Compression