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

IBM A2090-543 試験概要:

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

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

1. Function XMLPARSE is used in a INSERT statement.
In which two situations will boundary whitespaces be stripped? (Choose two.)

A) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="preserve" attribute.
B) When the PRESERVE WHITESPACE option is used.
C) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="default" attribute.
D) When the CURRENT IMPLICIT XMLPARSE OPTION special register is set to 'STRIP WHITESPACE' and no XMLPARSE option is used.

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 1 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 2 Order B

3. Which three SQL/XML functions support the default parameter's passing behavior? (Choose three.)

A) XMLSERIALIZE()
B) XMLTABLE()
C) XMLTRANSFORM()
D) XMLEXISTS()
E) XMLQUERY()

4. The scope of a cursor is limited to ____.

A) the transaction in which the cursor is declared
B) the source program in which it is defined
C) all remotely called routines
D) applications local to the DB2 server

5. 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 *

質問と回答：