Answer Posted / ashish tyagi

The basic difference between primary key and unique key is that unique key allows null value but primary key did not allow null value.

What are the three types of database design?

1025

---

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

1077

---

Explain about the hierarchical model of the database?

1116

---

What is DB Development software?

2074

---

Explain about relational database management systems?

966

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4008

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2056

---

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

2144

---

What are the 18 schemas?

1121

---

Explain about the storage and physical database design?

912

---

How you can make a parameterized view?

1012

---

Explain about network model?

1005

---

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

1002

---

What are the key features of dbms?

996

---

How to customize error conditions.

2150

---