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? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

1654

Which four data types cannot be used as a return type from a user-defined function?

577

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

555

How long can an error message be in raiseerror function?

546

Explain the role of indexing in databases?

640

What is the physical representation for a many-to-many relationship?

573

What are the 18 schemas?

606

In which database can extended stored procedures be added?

525

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

585

Explain about normal forms?

595

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1986

What is normalization? Explain different levels of normalization?

59796

How to use online Backups?

1723

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2412

I have a few records all are same structures data, I want to store data in multiple targets how

2140