Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-543
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-543.html

DB2 9.7 Application Development

Question No: 51 – (Topic 2)

Click the Exhibit button.

CREATE TABLE gradereport(sid INTEGER, info XML); INSERT INTO gradereport VALUES (1,

#39;lt;studentinfo sid=quot;1quot;gt;

lt;namegt;John Smithlt;/namegt;

lt;honoursgt;Nolt;/honoursgt;

lt;gradesgt;

lt;coursegt;lt;namegt;ECE100lt;/namegt;lt;gradegt;80lt;/gradegt;lt;/coursegt;

lt;coursegt;lt;namegt;CSC100lt;/namegt;lt;gradegt;70lt;/gradegt;lt;/coursegt;

lt;coursegt;lt;namegt;MAT100lt;/namegt;lt;gradegt;60lt;/gradegt;lt;/coursegt;

lt;/gradesgt;

lt;phone type=quot;mobilequot;gt;416-333-8725lt;/phonegt;

lt;/studentinfogt;#39;);

Given the statements shown in the exhibit, which two queries can be used to return the semester average of the student? (Choose two.)

  1. XQUERY for $studinfo in db2-fn:xmlcolumn(#39;GRADEREPORT.INFO#39;)/studentinfo let $sum := fn:sum($studinfo/grades/course/grade),

    $count := fn:count($studinfo/grades/course/grade) return $sum div $count

  2. XQUERY for $studinfo in db2-fn:xmlcolumn(#39;GRADEREPORT.INFO#39;)/studentinfo let $average := fn:average($studinfo/grades/course/grade)

    return $average

  3. XQUERY for $studinfo in db2-fn:xmlcolumn(#39;GRADEREPORT.INFO#39;)/studentinfo let $avg := fn:avg($studinfo/grades/course/grade)

    return $avg

  4. XQUERY for $studinfo in db2-fn:xmlcolumn(#39;GRADEREPORT.INFO#39;)/studentinfo let $avg := fn:avg($studinfo/grades/course)

return $avg

Answer: A,C

Question No: 52 – (Topic 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;

Autocommit is on and the statements shown are executed:

INSERT INTO orders VALUES (NEXT VALUE FOR order_num, #39;Order A#39;); INSERT INTO orders VALUES (PREVIOUS VALUE FOR order_num, #39;Order B#39;); SELECT * FROM orders;

What is the output?

  1. OID INFO 1 Order A

    1 Order B

  2. OID INFO 0 Order A

    1. Order B

  3. OID INFO 1 Order A

    1. Order B

  4. OID INFO 2 Order A

2 Order B

Answer: A

Question No: 53 – (Topic 2)

Click the Exhibit button.

lt;personinfogt;

lt;namegt;John Waynelt;/namegt;

lt;address type=quot;privatequot;gt;

lt;citygt;New Yorklt;/citygt;

lt;countrygt;USlt;/countrygt;

lt;phonegt;850-734-6672lt;/phonegt;

lt;/addressgt;

lt;phone type=quot;mobilequot;gt;796-858-1272 lt;/phonegt;

lt;phone type=quot;securityquot;gt;646-252-1053lt;/phonegt;

lt;/personinfogt;

lt;personinfogt;

lt;namegt;Barbara Waynelt;/namegt;

lt;address type=quot;privatequot;gt;

lt;citygt;New Yorklt;/citygt;

lt;countrygt;USlt;/countrygt;

lt;phonegt;850-734-6672lt;/phonegt;

lt;/addressgt;

lt;phone type=quot;mobilequot;gt;796-858-1231 lt;/phonegt;

lt;phone type=quot;securityquot;gt;646-252-1153lt;/phonegt;

lt;/personinfogt;

The table PERSON is declared as shown below: CREATE TABLE person (id BIGINT, info XML)

The documents shown in the exhibit are successfully inserted into the table. How many phone numbers will be affected by the statement shown below?

UPDATE xmlapp.person

SET info = xmlquery( #39;copy $new := $INFO modify for $j in $new/personinfo//phone return do replace value of $j with quot;444-444-4444quot; return $new#39; )

WHERE XMLEXISTS(#39;$INFO/personinfo[name=quot;John Waynequot;]#39;)

  1. 0

  2. 3

  3. 4

  4. 6

Answer: B

Question No: 54 – (Topic 2)

While developing a Java JDBC application, you use the set of statements shown below: Connection con;

PreparedStatement pstmt; int numUpd;

pstmt = con.prepareStatement(quot;UPDATE EMPLOYEE SET PHONENO=#39;4657#39; WHERE EMPNO=?quot;);

pstmt.setString(0, quot;000010quot;); numUpd = pstmt.executeUpdate(); pstmt.close();

Assuming a connection has already been established, which statement is true?

  1. Statements will be executed successfully.

  2. Statements will give a runtime exception.

  3. Statements will give a syntax error.

  4. Statements will execute successfully, but will not update rows in the database.

Answer: B

Question No: 55 – (Topic 2)

Which CLI/ODBC function would be used to update multiple rows in a table?

  1. SQLUpdate()

  2. SQLExecBatch()

  3. SQLExecute()

  4. SQLBulkUpdate()

Answer: C

Question No: 56 – (Topic 2)

Which statement should be used to obtain the result set shown below?

lt;Rootgt;

lt;Firstgt;Hellolt;/Firstgt;

lt;Secondgt;World !lt;/Secondgt;

lt;?Test Pass test?gt;

lt;/Rootgt;

  1. VALUES XMLDOCUMENT( XMLELEMENT (NAME quot;Rootquot;, XMLELEMENT(NAME quot;Firstquot;, #39;Hello#39;), XMLELEMENT(NAME quot;Secondquot;, #39;World !#39;), XMLTEXT (#39;Test Pass test#39;)

    )

    )

  2. VALUES XMLDOCUMENT( XMLELEMENT (NAME quot;Rootquot;, XMLFOREST(

    #39;Hello#39; as quot;Firstquot;, #39;World !#39; as quot;Secondquot;

    ),

    XMLCOMMENT (#39;Test Pass test#39;)

    )

    )

  3. VALUES XMLDOCUMENT( XMLELEMENT (NAME quot;Rootquot;, XMLELEMENT(NAME quot;Firstquot;, #39;Hello#39;), XMLELEMENT(NAME quot;Secondquot;, #39;World !#39;), XMLATTRIBUTES ( #39;Pass test#39; as quot;testquot;)

    )

    )

  4. VALUES XMLDOCUMENT( XMLELEMENT (NAME quot;Rootquot;, XMLFOREST(

#39;Hello#39; as quot;Firstquot;, #39;World !#39; as quot;Secondquot;

),

XMLPI (NAME quot;Testquot;, #39;Pass test#39;)

)

)

Answer: D

Question No: 57 – (Topic 2)

Which three SQL/XML functions support the default parameter#39;s passing behavior? (Choose three.)

  1. XMLTABLE()

  2. XMLTRANSFORM()

  3. XMLQUERY()

  4. XMLEXISTS()

  5. XMLSERIALIZE()

Answer: A,C,D

Question No: 58 – (Topic 2)

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, #39;ECE102#39;, #39;Databases#39;); 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, #39;ECE103#39;, #39;Algorithms#39;); SELECT max(ID) FROM session.tempcourses;

Which results do USER1 and USER2 obtain?

  1. User USER1 obtains the value 2; User USER2 obtains the value 3

  2. User USER1 obtains the value 3; User USER2 obtains the value 4

  3. User USER1 obtains the value 2; User USER2 obtains the value 4

  4. User USER1 obtains no value; User USER2 obtains no value

  5. User USER1 obtains the value 2; User USER2 obtains the value 2

Answer: C

Question No: 59 – (Topic 2)

Click the Exhibit button.

CREATE TABLE store(sid INTEGER, info XML); INSERT INTO store VALUES (1,

#39;lt;storeinfo sid=quot;1quot;gt;

lt;namegt;ABCDEFlt;/namegt;

lt;/storeinfogt;#39;);

INSERT INTO store VALUES (2,

#39;lt;storeinfo sid=quot;2quot;gt;

lt;namegt;FEDCBAlt;/namegt;

lt;/storeinfogt;#39;);

Given the statements shown in the exhibit, a user executes the query shown below:

XQUERY for $store in db2-fn:xmlcolumn(#39;STORE.INFO#39;)/storeinfo let $name := fn:substring($store/name, 1, 3),

$lcase := fn:lower-case($name) return $lcase

What is the output?

  1. abcd fedc

  2. aBC fED

  3. abc fed

  4. aBCDEF fEDCBA

  5. abfe

Answer: C

Question No: 60 – (Topic 2)

What are two different types of federated trusted connections? (Choose two.)

  1. catalog federated trusted connections

  2. end-to-end federated trusted connections

  3. proxy federated trusted connections

  4. outbound federated trusted connections

Answer: B,D

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

EnsurePass 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

Your email address will not be published. Required fields are marked *

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