Exam : 000-730
Title : DB2 9 Family Fundamentals������
���
Ver : 08-31-07
000-730
Actualtests.com - The Power of Knowing
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
000-730
Actualtests.com - The Power of Knowing
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 occurs that causes all of them to activate, which trigger will be activated
first?
A. TRIG_A
B. TRIG_B
C. TRIG_C
D. TRIG_D
000-730
Actualtests.com - The Power of Knowing
Answer: A
QUESTION 8
Which of the following will DELETE all of the rows from the table T03?
A. DELETE * FROM TABLE T03
B. DELETE ALL FROM T03
C. DELETE * FROM T03
D. DELETE FROM T03
Answer: D
QUESTION 9
Which of the following tools for DB2 V9 allows a user to create and debug a SQL
stored procedure?
A. Control Center
B. Development Center
C. Developer Workbench
D. Stored Procedure Builder
Answer: C
QUESTION 10
Application A is designed to execute the following SQL statements within a Single
Unit of Work(UOW).
Application A and Application B execute their first SQL statements at the same
time. When Application A and Application B try to execute their Second SQL
statement, a deadlock occurs. What will happen?
A. The database manager will rollback the transaction in both applications
B. The database manager will rollback the transaction in one of the two applications
C. Application B will successfully update the EMPLOYEE and DEPARTMNET tables;
Application A will placed in a lock wait state
D. Application A will successfully update the EMPLOYEE and DEPARTMNET tables;
Application B will terminate when the lock timeout value is reached
Answer: B
QUESTION 11
Which of the following DB2 tools allows a user to execute an SQL statement and
view a graphical representation of the access plan?
000-730
Actualtests.com - The Power of Knowing
A. Task Center
B. Command Editor
C. Developer Workbench
D. Command Line Processor
Answer: B
QUESTION 12
Assuming PUBLIC has been granted all privileges on table T1, which of the
following statements would continue to permit any user to add rows to table T1 but
not remove them?
A. REVOKE DROP ON T1 FROM PUBLIC
B. REVOKE UPDATE ON T1 FROM PUBLIC
C. REVOKE DELETE ON T1 FROM PUBLIC
D. REVOKE CONTROL ON T1 FROM PUBLIC
Answer: C
QUESTION 13
When defining a referential constraints between the parent table T2 and the
dependent table T1, which of the following is true?
A. The list of column names in the FOREIGN KEY clause can be a subset of the list of
column names in the primary key of T2 or a UNIQUE constraint that exists on T2.
B. The list of column names in the FOREIGN KEY clause can be a subset of the list of
column names in the primary key of T1 or a UNIQUE constraint that exists on T1
C. The list of column names in the FOREIGN KEY clause must be identical to the list of
column names in the primary key of T2 or a UNIQUE constraint that exists on T2
D. The list of column names in the FOREIGN KEY clause must be identical to the list of
column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
Answer: C
QUESTION 14
An alias can be an alternate name for which DB2 object?
A. Sequence
B. Trigger
C. Schema
D. View
Answer: D
