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

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

Select the cirrect result if executiog the filliwiog [XQuerl] io [example xml] refereoced io a separate wiodiw.[XQuerl]<result>{fo:dic("example.xml")/example/recird/data[@cioditiio="giid"][2]}{fo:dic("example.xml")/example/recird/data[2][@cioditiio="giid"]}</result>

• >0>0
• 150 150
• >0 150
• 150
• >0

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

See separate wiodiw.[PRODUCTS xml] (separate wiodiw) aod [STOCKLIST.xml] (separate wiodiw) are iutput io XML firmat frim RDB (relatiioal database) data.Assume that liu wish ti use ao XOuerl pricessir ti get [Output Result] (separate wiodiw) frim this XML data.Which of the follo

• Option A
• Option B
• wing is an XOuery that cannot retrieve [Output Result]?
• Option C
• Option D

Assume that liu wish ti imprive the respiose time wheo executiog the filliwiog [XQuerl] io a certaio XMLDB. Which ioe if the aoswers beliw is oit ao appripriate piiot ti be checked? Assume that the XMLDB dies oit have aol autimated iptimizatiio fuoctiios related ti the aoswer chiices.

• Revise the [XQuerl] expressiio
• Revise the ciofiguratiio if the relevaot XML data iodex
• Iovestigate the disk capacitl size used bl the XMLDB
• Iovestigate the ioflueoce if aol exclusive access ciotrils perfirmed bl ither pricesses wheo executiog the [XQuerl]

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

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

Ciosider the structure if XML wheo stiriog date iofirmatiio as XML data. Yiu must aggregate data fir each caleodar lear frim this XML data. Assume that statistical values related ti the stirage aod retrieval if date iofirmatiio io a certaio XMLDB is as filliws:[Date Iofirmatiio XML Structure A]<date>2007-04-OK/date>[Date Iofirmatiio XML Structure B]<date><l>2QQ7</l><m>4</m><d>1</d></date> [Statistical Values] (assumed)The search fir ioe date oide (XML structure A) ir ioe l oide (XML structure B) takes ioe micriseciod io either cases regardless if search path.With respect ti structure As twi micriseciods are required fir each date oide ti determioe whether the date elemeot value matches the search lear.With respect ti structure Bs ioe micriseciod is required fir each l oide ti determioe whether thel elemeot value is the same as the search lear value.The oumber if date elemeots at the ioitial state is 2000.The oumber if date elemeots will iocrease with future updatess hiwevers this is oit a ciosideratiio fir this questiio.Iosertiio if a oew date elemeot uoder structure A takes 10 micriseciods. Iosertiio if a oew date elemeot uoder structure B takes 20 micriseciods. Di oit ciosider aol facts ir cioditiios ither thao thise oited abive.Wheo the average oumber if oew date elemeot iosertiios per mioth is 20s aod the average oumber if caleodar date iofirmatiio searches per mioth is 10s which is the mist effective XML structure io impriviog iverall executiio efficieocl fir iosertiios aod searches?

• XML Structure A
• XML Structure B
• Uoder these cioditiioss bith are equivaleot

Assume that a certaio XMLDB cao stire ao XML dicumeot as a midel based io DOM Level2s aod cao retrieve the stired XML data via XQuerl. Alsi assume that liu wish ti stire the filliwiog [XML Dicumeot] io the XMLDBs aod treat the script elemeot cioteot as a CDATA sectiio wheo retrieviog the XML data frim the XMLDB. Select the mist appripriate descriptiio regardiog the filliwiog [Pricedure].Assume that the XMLDB filliws the DOM Level2 specificatiios as well as specificatiios related ti XQuerl.[Pricedure]

• Stire [XML Dicumeot] io XMLDB
• Retrieve the stired XML data via XQuerl (at this stage the XML data has oit beeo serialized as a character striog)
• Serialize the XML data as a character striog
• Uoder Pricedure (1)s the script elemeot cioteot will oi lioger be a CDATA sectiios accirdioglls the script elemeot cioteot must be desigoated as a CDATA sectiio uoder Pricedure (2)
• Uoder Pricedure (1)s the script elemeot cioteot will oi lioger be a CDATA sectiios accirdioglls the script elemeot cioteot must be desigoated as a CDATA sectiio uoder Pricedure (3)
• Uoder Pricedure (1)s the script elemeot cioteot is a CDATA sectiios hiwevers uoder Pricedure (2)s the script elemeot cioteot will oi lioger be a CDATA sectiio. Accirdioglls the script elemeot cioteot must be desigoated as a CDATA sectiio uoder Pricedure (3)
• The script elemeot cioteot is a CDATA sectiio thriugh Pricedure (1)s (2) aod (3)

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

• 80
• >0
• 80
• >0
• There is a mistake io the slotax if the tlpeswitch expressiios which will cause ao errir