subject: 000-142 exam questions [print this page] 000-142 study guide 000-142 study guide
1. A developer wishes to make an XSLT template more robust by checking a parameter passed to it for errors and boundary conditions. The template accepts a parameter of type number. What condition will NOT have to be checked?
A. number greater than allowed range
B. value of 0
C. type of the parameter value
D. Integer numbers
Answer: C
2. Calculating sub-totals from an XML document using XSL transformation requires special considerations. Which of the following options is the best solution to solve this problem?
A. Create a fragment variable containing the values to total, and then use the node-set() XSLT extension and the XPath "sum()" function to calculate the value.
B. Create a special XSLT variable that contains the results of an XPath query that performs a "sum()" of the values to be totaled.
C. Use XSLT recursion to define a variable value that calculates the "value-of" the elements to be sub-totaled.
D. Use XSLTC to precompile a custom Java translet that will extract the values to be totaled and returns the sum of those values. This return value is then used in an XSL variable for output.
Answer: A
3. XML data is stored and retrieved within a relational database for a data-centric application by means of mapping XML schema elements to database tables. There are concerns that the queries and updates to this database are slow due to the number of joins required in the SQL. What is the best option for improving the storage and retrieval of this XML data?
A. Transform XML documents into canonical form before persisting.
B. Modify the current XML schema by converting elements to attributes where possible and re-map to tables in order to reduce the number of tables and therefore the number of joins required.
C. Store the XML data as CLOBs without decomposing them into relational tables and provide an id' based lookup.
D. Modify the current XML schema by merging all of the XML documents into a main XML document and query using XPath.
