I10-003 MCQs
I10-003 TestPrep I10-003 Study Guide
I10-003 Practice Test I10-003 Exam Questions
killexams.com
XML Master Professional Database Administrator
https://killexams.com/pass4sure/exam-detail/I10-003
See separate window.
Assume you wish to execute a query on [example xml] (separate window) to obtain a record element that includes a data element for which the condition attribute value is "good," and for which the element value is 100 or less. Select the correct result of executing the [XQuery] (separate window). The expected result would be "C;" however, the query may not be processed as expected.
<result/>
<result>
<record date="2007-05-15">
<data condition="bad">50</data>
<data condition="bad">80</data>
<data condition="good">250</data>
</record>
</result>
<result>
<recorddate="2007-05-16">
<data condition="bad">60</data>
<data condition="good">90</data>
<datacondition="good">150</data>
</record>
</result>
<result>
<recorddate="2007-05-15">
<data condition="bad">50</data>
<data condition="bad">80</data>
<datacondition="good">250</data>
</record>
<recorddate="2007-05-16">
<data condition="bad">60</data>
<data condition="good">90</data>
<data condition="good"> 150</data>
</record>
</result>
See separate window.
[PRODUCTS xml] (separate window) and [STOCKLIST.xml] (separate window) are output in XML format from RDB (relational database) data. Assume that you wish to use
an XOuery processor to get [Output Result] (separate window) from this XML data. Which of the following is an XOuery that cannot retrieve [Output Result]?
Option A
Option B
Option C
Option D
Select the correct result of executing the [XOuery] on [example xml] referenced in a separate window.
<result/>
<result>
<record/>
<record/>
</result>
<result>
<record>
<name/>
</record>
<record>
<name/>
</record>
</result>
<result>
<record>
<name>John Smith</name>
</record>
<record>
<name>Harold Jones</name>
</record>
</result>
Select the correct result of executing the following [XQuery] on [example xml] referenced in a separate window.
[XQuery]
<result>{
for $record in fn:doc("example.xml")/example/record return
<record>{ fn:data($record/data) }</record>
}</result>
<result>
<record>50</record>
<record>60</record>
</result>
<result>
<record>5080250</record>
<record>6090150</record>
</result>
<result>
<record>50 80 250</record>
<record>60 90 150</record>
</result>
An error occurs
See separate window.
A certain Web application displays user information according to user input via Web browser. The XML data managing user information is as shown in [example.xml] (separate window). The following [XQuery] is executed when the Web application retrieves user information from [example xml].
[XQuery]
<result>{
fn:doc("example.xml")//data[userid = "(1)"][password = "(2)"]
}</result>
At this time, the Web application completes the [XQuery] by replacing (1) and (2) with the user input character string, and executes the query. No character escapes (e.g. convert "<" to "<") are performed for character string input by the user. Select two of the following that produces the query execution result in [Execution Result] (separate window) when the character string is as shown in each answer choice.
A. (1) "or""="
(2) OK
B. (1) "or""="
(2) "or""="
(1) idorfn:true()
(2) OK
(1) idorfn.true()
(2) idorfn:true()
(1) "orfn:true()orany="
(2) OK
(1)"orfn:true()orany="
(2)"orfn:true()orany="
A certain store engages in Internet commerce, managing customer information via XMLDB. Customers register as a user through a webpage, and are allowed to view their own information so they can edit their information themselves through a webpage interface. The store's Web application saves the customer information in an XMLDB, and retrieves data from the XMLDB as necessary.
The XML data including customer information is as shown in [CUSTOMER.xml] referenced in a separate window.
The XMLDB account when the Web application connects to the XMLDB is WEBAPP.
A person at the store is in charge of processing payments (access to all registered customer information), and this person's XMLDB account is COUNTER. A person at the store is in charge of product shipments (access to all registered customer information except for payment information ("payment element")), and this person's XMLDB account is SHIPPER. Do not consider XMLDB accounts other than those noted above. Each account authorization in the XMLDB is presently configured as follows: The WEBAPP account has permission to update and view [CUSTOMER xml] Other accounts have permission to view [CUSTOMER.xml] Which is the most appropriate method in this situation regarding XMLDB account authorizations'? Assume that this XMLDB has a view creation function (function to show only certain XML data in response to a certain query)
When saving data into the XMLDB,all user element content should be encrypted, and all XMLDB accounts should be given permission for decryption
When saving data into the XMLDB, all payment element content should be encrypted, and only the COUNTER account should be given permission for decryption
You should create a view (PAYMENT_VIEW) to show only payment element information, providing the COUNTER account with permission to view PAYMENT_VIEW
You should create a view (SHIP_V1EW) to show information other than payment element information, providing the SHIPPER account with permission to view SHIP_V1EW, and prohibiting the SHIPPER account from viewing [CUSTOMER.xml]
KILLEXAMS.COM
Killexams.com is a leading online platform specializing in high-quality certification exam preparation. Offering a robust suite of tools, including MCQs, practice tests, and advanced test engines, Killexams.com empowers candidates to excel in their certification exams. Discover the key features that make Killexams.com the go-to choice for exam success.
Killexams.com provides exam questions that are experienced in test centers. These questions are updated regularly to ensure they are up-to-date and relevant to the latest exam syllabus. By studying these questions, candidates can familiarize themselves with the content and format of the real exam.
Killexams.com offers exam MCQs in PDF format. These questions contain a comprehensive
collection of questions and answers that cover the exam topics. By using these MCQs, candidate can enhance their knowledge and improve their chances of success in the certification exam.
Killexams.com provides practice test through their desktop test engine and online test engine. These practice tests simulate the real exam environment and help candidates assess their readiness for the actual exam. The practice test cover a wide range of questions and enable candidates to identify their strengths and weaknesses.
Killexams.com offers a success guarantee with the exam MCQs. Killexams claim that by using this materials, candidates will pass their exams on the first attempt or they will get refund for the purchase price. This guarantee provides assurance and confidence to individuals preparing for certification exam.
Killexams.com regularly updates its question bank of MCQs to ensure that they are current and reflect the latest changes in the exam syllabus. This helps candidates stay up-to-date with the exam content and increases their chances of success.