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>
189
How would you begin to troubleshoot an ORA-3113 error?
5
What are triggers? How many triggers you can have on a
table?
I want to export the data date to date from oracle database
then what can i do?
189
There are n numbers of flatfile of exactly same format are
placed in a folder.Can we load these flatfile's data one by
one to a single relational table by a single session??
26
what happened to the global index when I truncate the data
in one of the partition?
91
if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?
4
hello.....
i am an comp science engineering graduate planning to do
ORACLE certification in PLSQL 9i. just wanted to know whats
the possibility getting job is their openings???? is it
worth doin that course n certification
45
i am writing a query select EmpNo from Emp how can i call in
after parameter form
186
if u want to delete all these detail block etc what will
happen in form
147
what is diff between pre insert,on insert,post insert
triggers?
253
1. Tell me your daily activities
2. If sql server installation fails at time
installation what will do
3. Where does the sql server installation log details
are stored
4. After the installation what will you do for memory
configuration
5. What is the difference between SQL max maximum
memory and AWE memory
6. How will you configure AWE memory
7. How will setup an email alert for the backup job
8. After the SQL installation what are the jobs will
you configure
9. What does –g mean in the sql startup parameter
10. What is the difference between Bulked log and Full
recovery model
11. What is the difference between mirroring and log
shipping
12. What are the steps to be followed before in-place
up gradation
13. After installing the patch the sql server does not
start and application team tells to rollback the
changes .In this scenario what will you do