Answer Posted / anuj barthwal

A self join applies on one table only

Example:

emp_id emp_name emp_manager_id

1 Anuj NULL

2 Sunny 1

3 Suraj 1

4 Narban 2


if we want to get the name of the managers

select e1.emp_name 'manager',e2.emp_name 'employee'
from employees e1 join employees e2
on e1.emp_id=e2.emp_manager_id

manager employee

Anuj Sunny

Anuj Suraj

Sunny Narban


Self join means joining the single table to itself

How long can an error message be in raiseerror function?

937

---

What are data modelling techniques?

898

---

Can an extended stored procedure be called from inside a user-defined function?

1002

---

What is the maximum length of an extended property?

924

---

How to generate OIDS

2168

---

Write short notes on manual refreshes.

2677

---

How you can make a parameterized view?

953

---

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

2078

---

Explain about the database management systems.

917

---

What is data modeling with example?

903

---

Explain about normal forms?

986

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

890

---

Explain about the hierarchical model of the database?

1056

---

Explain about xml databases?

1003

---

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

1010

---