What view would you use to look at the size of a data file?
49
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>
9
Can you convert a bit-mapped report to ASCII
(character-mode) Report ? How ?
Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM
trigger ?
58
How to start SQL Server in minimal configuration mode?
64
Give two examples of referential integrity constraints.
47
what happened to the global index when I truncate the data
in one of the partition?
9
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
45
what is the bond code in materialized view?
37
we have 10 concurrent programs under one request group
out of 10 ccps all users submitting only 9 programs from
srs window remaining one ccp for specific user how can it
possible send me answer asap.
along with your userid / name. ThanQ
Site Map