Answer Posted / lalithg

CREATE TABLE candytest
(kidId char(2),
candycolor varchar(10)
)
GO

INSERT INTO candytest SELECT 'K1', 'Yellow'
INSERT INTO candytest SELECT 'K1', 'Red'
INSERT INTO candytest SELECT 'K2', 'Red'
INSERT INTO candytest SELECT 'K2', 'Blue'
INSERT INTO candytest SELECT 'K3', 'White'
INSERT INTO candytest SELECT 'K3', 'Red'
INSERT INTO candytest SELECT 'K3', 'Yellow'
Go
--Now to find those kidid's which has both yellow and red
colored candies, we can write query as:

SELECT c1.kidid
FROM candytest AS c1 JOIN candytest AS c2
ON c1.candycolor = 'Red' AND c2.candycolor = 'Yellow'
AND c1.kidid = c2.kidid

Why does this query return 0?

1013

---

How to generate OIDS

2252

---

What is a database development?

962

---

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

2142

---

Write short notes on manual refreshes.

2732

---

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

1075

---

What are the types of database model?

1092

---

Write the fastest query to find out how many rows exist in a table?

1115

---

Explain about a primary key?

980

---

Explain the cube operator?

1005

---

How to read and create .LDC data files which are used by linguatic dictionary.

2529

---

Explain about relational operator join?

1037

---

What are the three basic rules which are to be followed for the relational model of the database?

1013

---

What is the maximum length of an extended property?

983

---

How would you design a database for an online site, which would average a million hits a day?

1009

---