IBM Information Management DB2 10 Technical Mastery Test v3 認定 P2090-018 試験問題:

1. Which one of the following options contains a benefit of the Java Generic Table Functions?

A) Java Generic Table Functions can be implemented in any programming language.
B) Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
C) Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
D) Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

2. What is a table space in DB2?

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

3. With respect to DB2 security, what is authorization?

A) Authorization is the process where the DBA gathers information to see who will have access to the database.
B) Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.
C) Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.
D) Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.

4. Which one of the following sentences does NOT describe a benefit of Temporal Tables?

A) 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) 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 provide a quick and easy way to track and record data changes in the table.

質問と回答：