I10-003 Dumps
          I10-003 Braindumps
          I10-003 Real Questions
          I10-003 Practice Test
          I10-003 Actual Questions












































            XML-Master



            I10-003







            XML Master Professional Database Administrator










            https://killexams.com/pass4sure/exam-detail/I10-003








                QUESTION: 34
                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.


                A. <result/>
                B. <result>
                <record date="2007-05-15">
                <data condition="bad">50</data>
                <data condition="bad">80</data>
                <data condition="good">250</data>
                </record>
                </result>
                C. <result>
                <recorddate="2007-05-16">
                <data condition="bad">60</data>
                <data condition="good">90</data>
                <datacondition="good">150</data>
                </record>



                                                            43








                </result>
                D. <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>


                Answer: D


                QUESTION: 35
                See separate window.
























































                                                            44


































































































                                                            45




















                [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]?






































































                                                            46













































                A. Option A
                B. Option B
                C. Option C
                D. Option D


                Answer: D


                QUESTION: 36
                Select the correct result of executing the [XOuery] on [example xml] referenced in a
                separate window.
































                                                            47



















































































                A. <result/>
                B. <result>
                <record/>
                <record/>
                </result>
                C. <result>
                <record>


                                                            48








                <name/>
                </record>
                <record>
                <name/>
                </record>
                </result>
                D. <result>
                <record>
                <name>John Smith</name>
                </record>
                <record>
                <name>Harold Jones</name>
                </record>
                </result>


                Answer: A


                QUESTION: 37
                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>



                                                            49










                A. <result>
                <record>50</record>
                <record>60</record>
                </result>
                B. <result>
                <record>5080250</record>
                <record>6090150</record>
                </result>
                C. <result>
                <record>50 80 250</record>
                <record>60 90 150</record>
                </result>
                D. An error occurs


                Answer: D


                QUESTION: 38
                See separate window.






















































                                                            50

















































































                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>



                                                            51








                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 "&lt;") 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""="
                C. (1) idorfn:true()
                (2) OK
                D. (1) idorfn.true()
                (2) idorfn:true()
                E. (1) "orfn:true()orany="
                (2) OK
                F. (1)"orfn:true()orany="
                (2)"orfn:true()orany="


                Answer: B, F


                QUESTION: 39
                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.
































                                                            52























































                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)


                A. When saving data into the XMLDB,all user element content should be encrypted, and
                all XMLDB accounts should be given permission for decryption
                B. When saving data into the XMLDB, all payment element content should be encrypted,
                and only the COUNTER account should be given permission for decryption
                C. You should create a view (PAYMENT_VIEW) to show only payment element
                information, providing the COUNTER  account with permission to view
                PAYMENT_VIEW
                D. 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]



                                                            53










                Answer: D























































































                                                            54








                         6$03/( 48(67,216








            7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\  )XOO YHUVLRQ LV

            XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV


            .LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ
            H[DP SUHSDUDWLRQ  7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV  H[DP GXPSV  DQG SUDFWLFH WHVWV WR
            KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH  +HUH DUH VRPH NH\
            IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP


            $FWXDO ([DP 4XHVWLRQV  .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG
            LQ WHVW FHQWHUV  7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG
            UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV  %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV  FDQGLGDWHV FDQ
            IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP

            ([DP 'XPSV  .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW  7KHVH GXPSV FRQWDLQ D
            FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV  %\ XVLQJ WKHVH
            GXPSV  FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH
            FHUWLILFDWLRQ H[DP


            3UDFWLFH 7HVWV  .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP
            VLPXODWRU DQG RQOLQH WHVW HQJLQH  7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG
            KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP  7KH SUDFWLFH WHVWV FRYHU D ZLGH
            UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV

            *XDUDQWHHG 6XFFHVV  .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV  7KH\
            FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV  FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\
            ZLOO UHIXQG WKH SXUFKDVH SULFH  7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV
            SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


            8SGDWHG &RQWHQW  .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR
            HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV  7KLV KHOSV
            FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


            7HFKQLFDO 6XSSRUW  .LOOH[DPV FRP SURYLGHV IUHH   [  WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV
            ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV  7KHLU FHUWLILHG H[SHUWV
            DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ
            MRXUQH\



                             'PS .PSF FYBNT WJTJU IUUQT   LJMMFYBNT DPN WFOEPST FYBN MJTU
                                .LOO \RXU H[DP DW )LUVW $WWHPSW    *XDUDQWHHG