DB2认证考试-730.pdf

Exam : 000-730 Title : DB2 9 Family Fundamentals�� ���� �� � Ver : 08-31-07 000-730 QUESTION 1 Which object may be used during query optimization to improve the performance for a subset of SELECT queries? A. MQT B. Trigger C. Read Only Cursor D. Stored Procedure Answer: A QUESTION 2 Which of the following commands is used to retrieve database named from the local catalog for DRDA host databases on system I and system z? A. List DB Directory B. List DCS Directory C. List Node Directory D. List Active Databases Answer: B QUESTION 3 Which of the following describes the object of a DB2 database and their relationship? A. Instance B. Table Space C. System Catalog D. Schema Repository Answer: C QUESTION 4 Which of the following is a characteristic of a sequence? A. A sequence will never generate duplicate values B. The MAXVLAUE of a sequence can be equal to the MINVALUE C. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero D. When a sequence cycles back to the either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries Answer: B A - The Power of Knowing 000-730 QUESTION 5 Which of the following database objects can be used to raise an error if a table is updated? A. Package B. Trigger C. Stored Procedure D. Informational Constraint Answer: B QUESTION 6 A Trusted Client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords? A. User ID/Password File B. Communications Layer C. Client Applications D. Operating System Answer: D QUESTION 7 The following triggers were defined for table TAB1 in the order shown: If an event oc