Download IBM.C2090-543.CertKiller.2019-03-01.99q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-543 |
| Exam Name: | DB2 9.7 Application Development |
| Date: | Mar 01, 2019 |
| File Size: | 469 KB |
Demo Questions
Question 1
Which condition will prevent a developer from using the DB2 Call Level Interface in an application?
- The developer must control the cursor names to comply with company naming standards.
- An SQL precompiler is not available to the developer.
- The application must create an external scalar function with the CREATE FUNCTION statement.
- The DECLARE CURSOR statement needs to be used.
Correct answer: D
Question 2
The statement below was used to create a cursor named CSR1:
DECLARE csr1 DYNAMIC SCROLL CURSOR FOR
SELECT * FROM employee;
After fetching all of the rows in the result set associated with cursor CSR1, which two statements can be used to fetch the data starting at the end of the result set? (Choose two.)
- FETCH LAST
- FETCH PRIOR
- FETCH RELATIVE
- FETCH OFFSET
Correct answer: BC
Question 3
Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfo
let $items := $store/items/fruit, $count := fn:count($items)
return <itemcount>$count</itemcount>
What is the output?
- 2
- <itemcount>2</itemcount>
- <itemcount>1</itemcount>
- <itemcount>$count</itemcount>
Correct answer: D
