File Info
| Exam | DB2 9.7 Application Development |
| Number | C2090-543 |
| File Name | IBM.C2090-543.CertKiller.2019-03-01.99q.tqb |
| Size | 469 KB |
| Posted | Mar 01, 2019 |
| Download | IBM.C2090-543.CertKiller.2019-03-01.99q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
