最新のA2090-730問題集で試験を準備する

IBM A2090-730 試験概要:

IBM A2090-730 試験シラバストピック:

IBM Assessment: DB2 9 Family Fundamentals 認定 A2090-730 試験問題：

1. Given the following two tables:
TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY
A 21 C 22 D 23
The following results are desired:
C1 C2 CX CY A 11 A 21 C 13 C 22 -- -- D 23
Which of the following queries will yield the desired results?

A) SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
B) SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
C) SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D) SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

2. Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?

A) Configuration Assistant
B) Performance Advisor
C) Design Advisor
D) Visual Explain

3. Which kind of non-sourced UDF can be created so that it only returns a single value?

A) Column
B) Row
C) Scalar
D) Table

4. User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?

A) GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC
B) GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC
C) GRANT EXECUTE ON PROCEDUREgen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
D) GRANT CALL ON PROCEDUREgen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;

5. Which of the following will begin a new unit of work?

A) The BEGIN TRANSACTION statement
B) The CONNECT statement
C) The first FETCH of a cursor
D) The first executable SQL statement

質問と回答：