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

1. Click the Exhibit button. PRODUCTS ID NAME QUANTITY
1 Orange juice 30
2 Milk 25 Given the table shown in the exhibit.
Which values will be returned by query shown below?
SELECT XMLGROUP(
id as "Id",name as "Name",quantity as "Quantity"
OPTION ROW "Product") as Products
FROM products

A)
1Orange juice30
2Milk25

B)
1Orange
juice30 2Milk25
C)
1Orange juice30
2Milk25

D) 1Orange juice30
2MIlk25

2. Which type of join condition specifies that the result table will contain a row for each row from the Table to the left, concatenated with each row from the table to the right?

A) INNER JOIN
B) CROSS JOIN
C) FULL OUTER JOIN
D) EXCEPTION JOIN

3. Given the table shown below:
COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
User USER1 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses
ON COMMIT PRESERVE ROWS;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
INSERT INTO session.tempcourses VALUES (3, 'ECE102', 'Databases');
SELECT max(ID) FROM db2user.courses;
User USER2 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
ON COMMIT PRESERVE ROWS;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
INSERT INTO session.tempcourses VALUES (4, 'ECE103', 'Algorithms');
SELECT max(ID) FROM session.tempcourses;
Which results do USER1 and USER2 obtain?

A) User USER1 obtains the value 2; User USER2 obtains the value 4
B) User USER1 obtains the value 3; User USER2 obtains the value 4
C) User USER1 obtains the value 2; User USER2 obtains the value 2
D) User USER1 obtains the value 2; User USER2 obtains the value 3
E) User USER1 obtains no value; User USER2 obtains no value

4. What are two valid connection options that you can use while creating a connection in PHP using the IBM_DB2 extension? (Choose two.)

A) "DB2_ATTR_CASE" => DB2_CASE_UPPER
B) "autocommit" => DB2_AUTOCOMMIT_FALSE
C) "CURSOR" => DB2_SCROLLABLE_SENSITIVE
D) "trustedcontext" => DB2_TRUSTED_CONTEXT_ENABLE

5. 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 UPDATE ON TABLE user1.table1 TO USER user2
B) GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2
C) GRANT BIND ON PACKAGE user1.pkg1 TO USER user2
D) GRANT ALTER ON TABLE user1.table1 TO USER user2

質問と回答：