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

1. User USER1 successfully creates a table USER1.TABLE1 and successfully creates a package USER1.PKG1 for an application containing the SQL shown below: EXEC SQL UPDATE user1.table1 SET col1 =:hvar1 WHERE col1 IS NULL Assuming user USER2 can connect to the database, but has no other relevant authorities, which command must user USER1 issue to permit user USER2 to run the application?

A) GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2
B) GRANT ALTER ON TABLE user1.table1 TO USER user2
C) GRANT UPDATE ON TABLE user1.table1 TO USER user2
D) GRANT BIND ON PACKAGE user1.pkg1 TO USER user2

2. A table and a sequence were created with the statements shown below: CREATE TABLE orders(oid INTEGER, info VARCHAR(200));
CREATE SEQUENCE order_num AS INTEGER
START WITH 1;
Autocommitis on and the statements shown are executed:
INSERT INTO orders VALUES (NEXT VALUE FOR order_num, 'Order A');
INSERT INTO orders VALUES (PREVIOUS VALUE FOR order_num, 'Order B');
SELECT * FROM orders;
What is the output?

A) OID INFO 1 Order A 2 Order B
B) OID INFO 2 Order A 2 Order B
C) OID INFO 0 Order A 1 Order B
D) OID INFO 1 Order A 1 Order B

3. While developing a Java JDBC application, you use the set of statements shown below:
Connection con;
PreparedStatementpstmt;
intnumUpd;
pstmt= con.prepareStatement("UPDATE EMPLOYEE SET PHONENO='4657' WHERE
EMPNO=?");
pstmt.setString(0, "000010");
numUpd= pstmt.executeUpdate();
pstmt.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 give a syntax error.
C) Statements will give a runtime exception.
D) Statements will be executed successfully.

4. The table PERSON is declared as shown below:
CREATE TABLE xmltest (id BIGINT, info XML)
What is the column type for the result of the following statement?
SELECT t.* FROM
xmltest,
XMLTABLE (
'$INFO/question'
) AS t

A) BLOB
B) XML
C) VARCHAR
D) CLOB

5. The table shown below exists in the database:
CREATE TABLE team.workitems ( priority INTEGER, last_update TIMESTAMP, details XML )
User USER1 has CREATEIN authority on the TEAM schema and can SELECT from the
TEAM.WORKITEMS table. An SQL routine is created that performs a positioned update using a
cursor declared as shown below:
DECLARE c_workitem CURSOR FOR SELECT priority, last_update FROM team.workitems FOR
UPDATE;
Which additional privilege is required?

A) ALTER privilege on TEAM.WORKITEMS table
B) EXECUTE privilege on TEAM schema
C) UPDATE privilege on TEAM.WORKITEMS table
D) BINDADD privilege on TEAM schema

質問と回答：