IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows 認定 A2090-611 試験問題:

1. Which statement about referential constraints is true?

A) A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.
B) A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.
C) A referential constraint can be defined against a catalog table.
D) A referential constraint can be defined on both tables and views.

2. Which statement about updating index statistics with the RUNSTATS command is true?

A) It cannot be accomplished without scanning the associated table.
B) It can be accomplished by sampling the index.
C) It must be executed against all indexes for the table.
D) It requires a full index scan.

3. What does the FLUSH PACKAGE CACHE statement do?

A) It removes all dynamic SQL statements from the package cache.
B) It causes all SQL statements in the package cache that are currently in use to be recompiled.
C) It removes only inactive SQL statements from the package cache.
D) It saves dynamic SQL stored in the package cache to an external file.

4. When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A) They are marked as "Move Pending."
B) They are automatically moved to the new table space.
C) They are marked as "Dropped Pending."
D) They are automatically dropped.

5. A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

A) TBSCAN
B) HSJOIN
C) IXSCAN
D) NLJOIN

質問と回答：