IBM C2090-730 Actual Tests : DB2 9 Family Fundamentals

IBM C2090-730 Exam Syllabus Topics:

IBM DB2 9 Family Fundamentals Sample Questions:

1. Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

A) CREATE DISTINCT TYPE currency AS BIGINT
B) CREATE DISTINCT TYPE currency AS SMALLINT
C) CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
D) CREATE DISTINCT TYPE currency AS DOUBLE

2. Application A is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno='000010'
UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'
Application B is designed to execute the following SQL statements within a single Unit of Work
(UOW).
UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00'
UPDATE employee SET salary = salary * 0.5 WHERE empno='000010'
Application A and application B execute their first SQL statement 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 managerwill rollback the transaction in one of the two applications.
B) Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
C) The database managerwill rollback the transaction in both applications.
D) Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.

3. To which of the following resources can a lock be applied?

A) Alias
B) Bitmap
C) Row
D) Column

4. How does DB2 protect the integrity of indexes when data is updated?

A) Locks are acquired on index pages.
B) Locks are acquired on the data.
C) Locks are acquired on index pointers.
D) Locks are acquired on index keys.

5. Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?

A) Control Center
B) Activity Monitor
C) Task Center
D) Journal

Solutions: