free download IBM 000-M34 exam

es
T tpassportQ&A

---

The safer , easier way to help you pass any IT exams.
Exam : 000-M34
Title
: I
B
M Information
Management pureXML
Technical Mastery Test v2
Version : Demo
1 / 2

---

The safer , easier way to help you pass any IT exams.
1.Which query retrieves an output identical to xquery db2-fn:xmlcolumn("XMLCUSTOMER.INFO");?
A. xquery db2-fn:sqlquery("select info from xmlcustomer");
B. xquery count(db2-fn:xmlcolumn('XMLPRODUCT.DESCRIPTION')
/product[description/price < 40]);
C. xquery db2-fn:sqlquery("select info from xmlcustomer where cid = 1002");
D. xquery db2-fn:xmlcolumn('XMLCUSTOMER.INFO')
/customerinfo[addr/city='Toronto']/name;
Answer: A
2.Which statement is FALSE about XQuery?
A. XQuery provides the means to extract and manipulate data from XML documents.
B. XQuery is for relational databases what SQL is for XML.
C. XQuery provides the means to extract and manipulate any data source that can be viewed as XML.
D. XQuery uses XPath expression syntax to address specific parts of an XML document.
Answer: B
3.Which feature of DB2 9.5 makes it simple to compress XML data because a reorg is no longer
necessary?
A. RUNSTATS
B. cost-based optimizer
C. Automatic Dictionary Creation (ADC)
D. Net Search Extender (NSE)
Answer: C
4.Three of the Xquery statements below are equivalent expressions. Select the one that is not.
A. xquery
for $i in db2-fn:xmlcolumn(XMLCUSTOMER.INFO)
where $i/customerinfo/name = John Doe return $i/addr;
B. xquery
db2-fn:xmlcolumn(XMLCUSTOMER.INFO)/customerinfo/name = John Doe/addr;
C. xquery
for $i in db2-fn:xmlcolumn(XMLCUSTOMER.INFO)/customerinfo[name = John Doe]
return $i/addr;
D. xquery
db2-fn:xmlcolumn(XMLCUSTOMER.INFO)/customerinfo[name = John Doe]/addr;
Answer: B
5.In what should a nested expression be enclosed if the content of an element or attribute must be
computed?
A. < >
B. { }
C. ( )
D. / /
Answer: B
2 / 2

---