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

1. For which two database objects can an ALIAS be created? (Choose two.)

A) trigger
B) sequence
C) module
D) schema

2. A database contains a table and a view declared as shown below:
CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );
CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;
A system administrator successfully executes the following code:
GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;
GRANT INSERT ON TABLE s1.t1 TO user1;
GRANT CONTROL ON s1.v1 TO user1;
Which SQL statement does user USER1 have privileges to execute?

A) SELECT * FROM s1.t1 WHERE c2 < 100
B) CREATE VIEW user1.v2 AS SELECT * FROM s1.v1
C) UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL
D) CREATE PUBLIC ALIAS a1 FOR s1.v1

3. Which return codes will be returned by SQLFetch() when there are no more records to be retrieved in a result data set?

A) SQL_WARNING
B) SQL_NO_MORE_DATA
C) SQL_NO_DATA_FOUND
D) SQL_SUCCESS

4. An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary: UPDATE emp SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1; Which statement should be used to define cursor C1?

A) DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE
B) DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11??
C) DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11?FOR UPDATE OF bonus
D) DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE OF *

5. Given the two tables shown below: TAB1 LETTER GRADE A 80 B 70 C 60 TAB2 LETTER GPA A 4 C 2 D 1 and the successful execution of the following query: SELECT * FROM tab1 FULL OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?

A) 2
B) 3
C) 6
D) 4

質問と回答：