Answer Posted / ramesh

A composite Key can be either Primay or Unique Key
More then One Key columns are said to be composite keys

Candidate Key(Primary Key) is a Key which Maintains the Row
Uniue .Can be defined based on the Entity


Alternate Key or Unique Key is similar to PK ,except it
accepts null Values .So that the records can still be
entered submitting null values to this attribute.

Explain about relational operator join?

1045

---

In which database can extended stored procedures be added?

906

---

What are the three types of database design?

1025

---

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

2145

---

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

1007

---

Explain what a database is?

1052

---

Explain the process of the user request and data generating?

1095

---

Explain about the storage and physical database design?

915

---

Explain the cube operator?

1014

---

How long can an error message be in raiseerror function?

1006

---

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

1122

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2207

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2857

---

Explain about query and reporting.

2096

---

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

4012

---