IBM C2090-543 - DB2 9.7 Application Development Exam
Page: 1 / 21
Total 100 questions
Question #1 (Topic: Topic 1)
Using the default lock timeout and isolation level, user USER1 drops table TABLE1
however, the transaction is not committed. Subsequently, user USER2 attempts to access
table TABLE1 using the default isolation level. What will occur?
however, the transaction is not committed. Subsequently, user USER2 attempts to access
table TABLE1 using the default isolation level. What will occur?
A. User USER2 receives an error immediately.
B. User USER2 will wait until user USER1 issues a COMMIT or ROLLBACK statement.
C. User USER1 will receive an error.
D. User USER2 will be able to access the table successfully.
Answer: B
Question #2 (Topic: Topic 1)
Which statement is true of an application that only uses static SQL?
A. The authorization ID of program creator is used to qualify explicitly qualified table references on a DROP statement.
B. Static SQL uses SQLDA to determine the number of rows successfully fetched on a FETCH statement.
C. The authorization ID of application creator is used to qualify implicitly qualified view references on an UPDATE statement.
D. The authorization ID of application invoker used by DB2 to perform authorization checking of an embedded OPEN statement during execution.
Answer: C
Question #3 (Topic: Topic 1)
The statement below was used to create a cursor named CSR1:
DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in
the result set associated with cursor CSR1, application TEST1 needs to fetch the third row
of the result set again.
Which steps will allow application TEST1 to fetch the third row again?
DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in
the result set associated with cursor CSR1, application TEST1 needs to fetch the third row
of the result set again.
Which steps will allow application TEST1 to fetch the third row again?
A. FETCH ABSOLUTE 3
B. CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH
C. REOPEN csr1; FETCH; FETCH; FETCH;
D. FETCH PRIOR; FETCH PRIOR; FETCH PRIOR; FETCH PRIOR;
Answer: B
Question #4 (Topic: Topic 1)
A database contains two tables with the same definition and authorities:
A. trigger
B. procedure
C. alias
D. sequence
Answer: C
Question #5 (Topic: Topic 1)
A table named INVENTORY was created by executing the SQL statement shown below:
CREATE TABLE inventory (part_no INTEGER, quantity INTEGER, price DECIMAL(7,2),
status CHAR(2));
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY to
zero, which SQL statement updates the INVENTORY table to indicate that all items with
part numbers below 150 are out of stock?
CREATE TABLE inventory (part_no INTEGER, quantity INTEGER, price DECIMAL(7,2),
status CHAR(2));
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY to
zero, which SQL statement updates the INVENTORY table to indicate that all items with
part numbers below 150 are out of stock?
A. UPDATE inventory SET status = 'NULL', quantity = 0 WHERE part_no < 150
B. UPDATE inventory SET status = NULL, SET quantity = 0 WHERE part_no < 150
C. UPDATE inventory SET (status, quantity) = ('NULL', 0) WHERE part_no < 150
D. UPDATE inventory SET (status, quantity) = (NULL, 0) WHERE part_no < 150
Answer: D
