IBM Assessment: DB2 9.7 Application Development 認定 A2090-543 試験問題:

1. While developing a Java JDBC application, you use the set of statements shown below:
Connection con;
Statement stmt;
intnumUpd;
stmt = con.createStatement();
numUpd= stmt.executeUpdate("UPDATE EMPLOYEE SET PHONENO='4657' WHERE
EMPNO=?");
stmt.close();
con.close();
Assuming a connection has already been established, which statement is true?

A) Statements will execute successfully, but will not update rows in the database.
B) Statements will execute successfully.
C) Statements will give a syntax error.
D) Statements will give a runtime exception.

2. An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?

A) 07/08/2009-12:22:22:0000
B) 2009-08-07 12:22:22.0000
C) 07-08-2009 12.22.22.0000
D) 2009.08.07.12.22.22.0000

3. Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := $store/items/fruit,
$count := fn:count($items) return <itemcount>$count</itemcount> What is the output?

A) 1
B) $count
C) 2
D) 2

4. 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) REOPEN csr1;
FETCH;
FETCH;
FETCH;
B) CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH
C) FETCH ABSOLUTE 3
D) FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;

5. .You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below: CHAR(10) UNION VARCHAR(20)What will be the final data type?

A) CHAR(200)
B) CHAR(30)
C) VARCHAR(30)
D) VARCHAR(20)

質問と回答：