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. Classic Row Compression
D. Declared Global Temporary Tables Compression
正解:A
質問 2:
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
質問 3:
What does the table partitioning feature in DB2 allow you to do?
A. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.
B. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.
C. Table partitioning allows you to partition the table data based on the hash values of the primary key.
D. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.
正解:D
質問 4:
Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A. Temporal tables provide a quick and easy way to track and record data changes in the table.
B. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
C. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
D. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
正解:B
石井** -
P2090-018問題集一つで万全の試験対策、素敵です。無事試験にごうかくしました。