1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.



b.) Select breakfasts that have price lower than $7.00?



<?xml version="1.0"?>
<breakfast_menu>
<food>
<name>Belgian Waffles</name>
<price>$5.95</price>
<description>
two of our famous Belgian Waffles with plenty of real
maple syrup
</description>
<calories>650</calories>
</food>
<food>
<name>Strawberry Belgian Waffles</name>
<price>$7.95</price>
<description>
light Belgian waffles covered with strawberries and
whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>Berry-Berry Belgian Waffles</name>
<price>$8.95</price>
<description>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
</description>
<calories>900</calories>
</food>
<food>
<name>French Toast</name>
<price>$4.50</price>
<description>
thick slices made from our homemade sourdough bread
</description>
<calories>600</calories>
</food>
<food>
<name>Homestyle Breakfast</name>
<price>$6.95</price>
<description>
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
</description>
<calories>950</calories>
</food>
</breakfast_menu>


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Development Interview Questions

What is the database development process?

0 Answers  


Explain about the storage and physical database design?

0 Answers  


What is denormalization and when would you go for it?

9 Answers   NBP,


Can you instantiate a COM object by using T-SQL?

1 Answers  


What is a database development?

0 Answers  






What is an extended stored procedure?

1 Answers  


How can I detect whether a given connection is blocked?

0 Answers  


How can you log an error to the server event log from a stored procedure?

0 Answers  


What is the system function to get the current user's user id?

4 Answers  


What are defaults? Is there a column to which a default can't be bound?

2 Answers  


Write the difference between case version and decode version.

2 Answers  


On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  


Categories