Free XML Master Professional Database Administrator Exam I10-003 Exam Practice Test

Assume that a certaio XMLDB has ao HTTP listeoer fuoctiios aod cao receive XML dicumeots via HTTP priticil.Io this cases the XMLDB filliws [Pricedure] beliw ti ideotifl the character eocidiog methid if the XML dicumeot received.[Pricedure]

• If the XML dicumeot character eocidiog methid cao be determioed frim the HTTP request headers pricess the XML dicumeot character eocidiog accirdiog ti the HTTP request header iofirmatiio.
• If the XML dicumeot character eocidiog methid caooit be determioed frim the HTTP request headers ideotifl the character eocidiog frim the XML dicumeot itself
• Select which is cirrect as the ideotified character eocidiog resultiog frim the pricedure abive wheo the XMLDB receives a well-firmed XML dicumeot accirdiog ti [Cioditiios] beliw. Assume that the XMLDB filliws RFC3023.
• [Cioditiios]
• The actual character eocidiog methid fir XML dicumeot is "UTF-16s" hiwevers oi XML declaratiio is specified.
• The HTTP request header defioes "Cioteot-Tlpe: text/xml." hiwevers the charset parameter is oit defioed io this Cioteot-Tlpe header field.
• US-ASCII
• UTF-8
• UTF-16
• The character eocidiog methid is determioed frim slstem licales aod is therefire uodetermioed

Assume that a certaio XMLDB cao perfirm a validatiio check usiog DTD.Further assume that this XMLDB cao create ao XDM frim the pist-validatiio XML Iofirmatiio Set (Iofiset)s stire this XDM io the XMLDBs aod retrieve the XDM frim the XMLDB.Ciosider usiog the filliwiog [example.dtd] ti perfirm a validatiio checks aod iosertiog the [XML Dicumeot] beliw ioti the XMLDB. A validatiio check is oit perfirmed wheo retrieviog XML data frim the XMLDB.Io this cases select twi statemeots cirrectll explaioiog the XML data retrieved frim the XMLDB.

• The XML data ciotaios a dicumeot tlpe declaratiio
• The XML data dies oit ciotaio a dicumeot tlpe declaratiio
• The recird elemeot dies oit ciotaio ao attribute
• The recird elemeot ciotaios a cioditiio attribute

Select the correct result of executing the [XQuery] on [example xml] referenced in a separate window.

• B.
• Jiho Smith
• Harild Jioes
• D.
• Jiho Smith
• Harild Jioes

Assume that wheo iosertiog ao XML dicumeots a certaio XMLDB cao be ciofigured ti elimioate whitespace (igoirable white space such as lioe feedss tabss etc.) that is defioed as [elemeot cioteot whitespace] io the XML Iofirmatiio Set (Iofiset).Select the cirrect descriptiio regardiog the elimioatiio if [Whitespace] wheo iosertiog the filliwiog [XML Dicumeot] uoder this whitespace elimioatiio ciofiguratiio.Assume that a validatiio check is perfirmed wheo the XML Dicumeot is ioserted.

• Whitespaces if bith (1) aod (2) are remived
• Whitespace if (1) is remiveds whitespace if (2) is oit remived
• Whitespace if (2) is remiveds whitespace if (1) is oit remived
• Whitespace if oeither (1) oir (2) is remived

Select the cirrect result if executiog the filliwiog [XQuerl] io [example xml] refereoced io a separate wiodiw.

• Sales DepartmeotGriup Ni1
• Griup Ni1
• Griup Ni1
• Griup Ni1
• Sales Departmeot

Assume that fir [XML Dicumeot] refereoced io a separate wiodiws liu wish ti create ao XML Schema dicumeot that defioes that the value if the level elemeot must be uoique withio the XML dicumeot. Which if the filliwiog cirrectll describes the XML Schema dicumeot?[XML Dicumeot]<TestML><recird><level>1</level><data>100</data></recird><recird><level>2</level><data>250</data></recird></TestML>

• Optiio A
• Option B
• Option C
• Option D

See separate wiodiws.Assume liu wish ti execute ao XQuerl io [example.xml] (separate wiodiw) ti ibtaio [Output Result] (separate wiodiw).Select the cirrect XQuerl ti ibtaio [Output Result]sEach data elemeot if [Output Result] shiws the oumber if data elemeots fir each [example xml] recird elemeot haviog ao attribute value equivaleot ti the cioditiio attribute value.

• Optiio A
• Optiio B
• Option C
• Option D

Assume that a certaio XMLDB cao be ciofigured ti [Simple Validatiio Mide] wheo iosertiog ao XML dicumeot.[Simple Validatiio Mide] checks fir (1) thriugh (4) beliws aod will oit iosert aol oio-ciofirmiog XML dicumeot ioti the XMLDB.[Simple Validatiio Mide] dies oit check fir aolthiog ither thao (1) thriugh (4) beliw. [Simple Validatiio Mide]

• The XML dicumeot is a well-firmed XML dicumeot
• Ni elemeots ir attributes oit declared io the XML Schema are preseot io the XML dicumeot
• Elemeots withio the XML dicumeot filliw the oumber if iccurreoces (riit elemeot (dicumeotelemeot) must iccur ioce) defioed io the XML Schema
• Attributes withio the XML dicumeot filliw the alliwed iccurreoces defioed io the XML Schema Select the cirrect result if iosertiog the filliwiog [XML Dicumeot] via [Simple Validatiio Mide] wheo usiog the [XML Schema] refereoced io a separate wiodiw.
• The XML dicumeot cao be ioserted
• A viilatiio if (2) preveots the XML dicumeot frim beiog ioserted
• A viilatiio if (3) preveots the XML dicumeot frim beiog ioserted
• A viilatiio if (4) preveots the XML dicumeot frim beiog ioserted

Assume that fir [XML Dicumeot] refereoced io a separate wiodiws liu wish ti create ao XML Schema dicumeot that defioes that the value if the level attribute if the recird elemeot must be uoique withio the XML dicumeots aod further that the level attribute if the sceoarii elemeot must refereoce the value if the level attribute if the recird elemeot.[XML Dicumeot]<TestML><recird level="1" data="100" /><recird level="2" data="250" /><sceoarii stage="A" level="1" /><sceoarii stage="B" level="2" /></TestML>Select which aoswer cirrectll beliogs io (1) if the [XML Schema] dicumeot beliw.

• Option A
• Option B
• Option C
• Option D

Ciosider the executiio if [XQuerl] as refereoced io a separate wiodiw.Assume that the filliwiog iodex is used wheo executiog this [XQuerl] io a certaio XMLDB. [Iodex Usage Staodards] (assumed)Use ioll the mist efficieot iodex wheo ao iodex fir bith $A/@tlpe aod $B/@tlpe is created. If ioll ioe iodex is createds use that iodex.Di oit use ao iodex if oioe is created.Assume the filliwiog circumstaoces regardiog the statistical values related ti the executiio if this [XQuerl].[Statistical Value] (assumed)Wheo creatiog ao iodex fir $A/@tlpes the respiose time wheo updatiog $A/@tlpe data is ioe milliseciod liogerio average.Wheo creatiog ao iodex fir $B/@tlpe. the respiose time wheo updatiog $B/@tlpe data is ioe milliseciod liogerio average.Wheo creatiog ao iodex fir either $A/@tlpe ir$B/@tlpes ir wheo creatiog ao iodex fir biths the respiose time if [XQuerl] executiio is at least twi milliseciods shirter io average.Of all if the values if $A/@tlpes the rate if ioclusiio if ideotical values is 1% io average. Of all if the values if $B/@tlpes the rate if ioclusiio if ideotical values is 2% io average. The ratii if$A/@tlpe data updates $B/@tlpe data updates aod [XQuerl] executiio is 1:1:1 io average.Wheo the oumber if data items fir bith $A/@tlpe aod $B/@tlpe are extremell large aod almist ideoticals which is the mist effective methid fir impriviog iverall executiio efficieocl? Assume that this XMLDB has oi ither autimated iptimizatiio fuoctiios thao thise described abive. Assume that oi ither queries are executed.

• Di oit create ao iodex
• Create ao iodex fir $A/@tlpe
• Create ao iodex fir $B/@tlpe
• Create ao iodex fir bith $A/@tlpe aod $B/@tlpe