“IBM Information Management pureXML Technical Mastery Test v2″, also known as 000-M34 exam prep software, is a IBM certification. With the complete collection of questions and answers, NowExam has assembled to take you through Questions and Answers to your IBM 000-M34 Exam preparation. In the 000-M34 exam resources, you will cover every field and category in IBM certifications I helping to ready you for your successful IBM Certification.
The 000-M34 practice exam is written and formatted by Certified Senior IT Professionals working in today’s prospering companies and data centers all over the world! The 000-M34 Practice Test covers all the exam topics and objectives and will prepare you for success quickly and efficiently.
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
The 000-M34 exam is very challenging, but with our 000-M34 questions and answers practice exam, you can feel confident in obtaining your success on the 000-M34 exam on your try!
No Responses Comments and Pings closed