Answer / Nirpendra Rai

A relational database is a type of database that stores data in tables, which are related to each other through common columns (or keys). The data in a relational database can be easily accessed and manipulated using Structured Query Language (SQL). Examples include MySQL, Oracle, and SQL Server.

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>

1 Answers  

---

How to use online Backups?

1 Answers  

---

What are the key features of dbms?

1 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

Why does this query return 0?

1 Answers  

---

What are cursors? Explain different types of cursors?

6 Answers  

---

How to customize error conditions.

1 Answers  

---

How to replace not in with not exist?

1 Answers  

---

Explain about relational database management systems?

1 Answers  

---

What are the main phases of database development?

1 Answers  

---

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

1 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---