IBM C2090-543 - DB2 9.7 Application Development Exam

Page:    1 / 20   
Total 100 questions

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?

  • 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

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

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?

  • 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

A database contains two tables with the same definition and authorities:

  • A. trigger
  • B. procedure
  • C. alias
  • D. sequence


Answer : C

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?

  • 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

Page:    1 / 20   
Total 100 questions