Answer Posted / vishal sharma

hi, to all. In a interview i asked a question that

"How to apply practically candidate key in SQL SERVER ?
like for primary key we apply PRIMERY KEY keyword how to apply in SQL-SEVER ?"

Plz help me to solve this question Plzzzzzzzz

Explain the rollup operator?

990

---

Explain about the relational database?

992

---

How can you fix a poorly performing query?

1101

---

Explain the process of the user request and data generating?

1028

---

Who are end users in dbms?

914

---

Explain about network model?

942

---

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

2075

---

How can I detect whether a given connection is blocked?

979

---

How to combine two function together?

2057

---

What is normalization? Explain different levels of normalization?

62692

---

How to use online Backups?

2148

---

Explain the role of indexing in databases?

1064

---

Explain what a database is?

976

---

What is an application role and explain a scenario when you would use one?

948

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2098

---