[Free] 2018(Jan) Dumps4cert Examcollection IBM C2090-543 Dumps with VCE and PDF 21-30

By | February 1, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-543
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-543.html

DB2 9.7 Application Development

Question No: 21 – (Topic 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 quot;Idquot;,name as quot;Namequot;,quantity as quot;Quantityquot; OPTION ROW quot;Productquot;) as Products

FROM products

  1. lt;rowsetgt;

    lt;Productgt;lt;Idgt;1lt;/Idgt;lt;Namegt;Orange juicelt;/Namegt;lt;Quantitygt;30lt;/Quantitygt;lt;/Productgt;

    lt;Productgt;lt;Idgt;2lt;/Idgt;lt;Namegt;Milklt;/Namegt;lt;Quantitygt;25lt;/Quantitygt;lt;/Productgt;

    lt;/rowsetgt;

  2. lt;Productgt;lt;Idgt;1lt;/Idgt;lt;Namegt;Orange juicelt;/Namegt;lt;Quantitygt;30lt;/Quantitygt;lt;/Productgt;

    lt;Productgt;lt;Idgt;2lt;/Idgt;lt;Namegt;MIlklt;/Namegt;lt;Quantitygt;25lt;/Quantitygt;lt;/Productgt;

  3. lt;Productsgt;

    lt;Productgt;lt;Idgt;1lt;/Idgt;lt;Namegt;Orange juicelt;/Namegt;lt;Quantitygt;30lt;/Quantitygt;lt;/Productgt;

    lt;Productgt;lt;Idgt;2lt;/Idgt;lt;Namegt;Milklt;/Namegt;lt;Quantitygt;25lt;/Quantitygt;lt;/Productgt;

    lt;/Productsgt;

  4. lt;PRODUCTSgt;

lt;PRODUCTgt;lt;IDgt;1lt;/IDgt;lt;NAMEgt;Orange juicelt;/NAMEgt;lt;QUANTITYgt;30lt;/QUANTITYgt;lt;/PRODUCTgt;

lt;PRODUCTgt;lt;IDgt;2lt;/IDgt;lt;NAMEgt;Milklt;/NAMEgt;lt;QUANTITYgt;25lt;/QUANTITYgt;lt;/PRODU CTgt;

lt;/PRODUCTSgt;

Answer: A

Question No: 22 – (Topic 1)

Function XMLPARSE is used in a INSERT statement.

In which two situations will boundary whitespaces be stripped? (Choose two.)

  1. When the CURRENT IMPLICIT XMLPARSE OPTION special register is set to #39;STRIP WHITESPACE#39; and no

    XMLPARSE option is used.

  2. When the STRIP WHITESPACE option is used, the XML element contains the xml:space=quot;preservequot; attribute.

  3. When the STRIP WHITESPACE option is used, the XML element contains the xml:space=quot;defaultquot; attribute.

  4. When the PRESERVE WHITESPACE option is used.

Answer: A,C

Question No: 23 – (Topic 1)

An application uses the statement shown below to give employees in department quot;E11quot; 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?

  1. DECLARE c1 CURSOR FOR SELECT bonus FROM emp WHERE workdept = 11??

  2. DECLARE c1 CURSOR FOR SELECT bonus FROM emp WHERE workdept = 11?FOR UPDATE OF bonus

  3. DECLARE c1 CURSOR FOR SELECT * FROM emp WHERE workdept = 11? FOR UPDATE

  4. DECLARE c1 CURSOR FOR SELECT * FROM emp WHERE workdept = 11? FOR UPDATE OF *

Answer: B

Question No: 24 – (Topic 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?

  1. GRANT ALTER ON TABLE user1.table1 TO USER user2

  2. GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2

  3. GRANT UPDATE ON TABLE user1.table1 TO USER user2

  4. GRANT BIND ON PACKAGE user1.pkg1 TO USER user2

Answer: B

Question No: 25 – (Topic 1)

An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?

A. 2009.08.07.12.22.22.0000

B. 2009-08-07 12:22:22.0000

C. 07/08/2009-12:22:22:0000

D. 07-08-2009 12.22.22.0000

Answer: B

Question No: 26 – (Topic 1)

Which three data types are supported as output of the XMLSERIALIZE function? (Choose three.)

  1. CLOB

  2. CHAR

  3. DOUBLE

  4. BLOB

  5. GRAPHIC

Answer: A,B,D

Question No: 27 – (Topic 1)

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?

  1. EXECUTE privilege on TEAM schema

  2. ALTER privilege on TEAM.WORKITEMS table

  3. BINDADD privilege on TEAM schema

  4. UPDATE privilege on TEAM.WORKITEMS table

Answer: D

Question No: 28 – (Topic 1)

Which set of SQL statements must be run prior to the EXECUTE statement shown below so that the

INSERT statement can be executed successfully? EXECUTE s1 USING :v1;

  1. SET :stmt = #39;INSERT INTO tab1 VALUES(?)#39;; PREPARE s1 FROM :stmt

  2. SET :stmt = #39;INSERT INTO tab1 VALUES(:v1)#39;; PREPARE s1 FROM :stmt;

  3. SET :stmt = #39;INSERT INTO tab1 VALUES(?v1)#39;; PREPARE s1 FROM :stmt;

  4. SET :stmt = #39;INSERT INTO tab1 VALUES(?)#39;; PREPARE s1 FROM :stmt DESCRIBE :v1;

Answer: A

Question No: 29 – (Topic 1)

Click the Exhibit button. VEMPLOYEE

———- EMPNO CHAR(6)

LASTNAME VARCHAR(30) SALARY DEC(9,2) DEPTNO CHAR(3) VDEPARTMENT

———– DEPTNO CHAR(3)

DEPTNAME VARCHAR(20) MGRNO CHAR(6)

VPROJECT

——– PROJNO CHAR(6)

PROJNAME VARCHAR(20) DEPTNO CHAR(6) RESPEMP CHAR(6)

A JOIN operation references three views in the exhibit; the SELECT statement used does not contain a WHERE clause.

When the SELECT statement is executed, what will the result set contain?

  1. one row from each table

  2. no rows

  3. unordered rows from one of three tables

  4. the Cartesian product

Answer: D

Question No: 30 – (Topic 1)

Click the Exhibit button.

INSERT INTO table1 VALUES(1,11); INSERT INTO table1 VALUES(2,11);

SAVEPOINT sp1 ON ROLLBACK RETAIN CURSORS; INSERT INTO table1 VALUES(3,11);

INSERT INTO table1 VALUES(4,11); INSERT INTO table1 VALUES(5,11);

SAVEPOINT sp2 ON ROLLBACK RETAIN CURSORS; INSERT INTO table1 VALUES(6,11);

INSERT INTO table1 VALUES(7,11); ROLLBACK TO SAVEPOINT sp2;

INSERT INTO table1 VALUES(8,11);

SAVEPOINT sp3 ON ROLLBACK RETAIN CURSORS; INSERT INTO table1 VALUES(9,11);

ROLLBACK;

Application1 executes the SQL statements shown in the exhibit against table TABLE1 in manual commit mode. How many rows will be inserted in TABLE1?

  1. 0

  2. 5

  3. 7

  4. 9

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:C2090-543 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-543 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.