Answer Posted / doraswamy

One table allows only one primary key but there is no
restriction for unique keys.
These two are same but one difference is unique key will
allow nulls.
Primary key create on a combination of mulitiple colums.

Foreign key is reference of another table primiary key. It
will not allow null values.

~Doraswamy

What are the concurrency problems a database faces?

1039

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2550

---

What is the difference between specialization and generalization?

1025

---

Explain the various types of normalization.

1079

---

Explain inner and outer joins with examples.

1176

---

What is difference between clustered, non-clustered and unique index?

1088

---

There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

2162

---

Explain file manager?

1008

---

What is the importance of database partitioning?

1061

---

what are wrappers and build ups and what it's use?

2161

---

What is the role of driver manager?

1011

---

What is a sequence? Explain it with one example?

1190

---

Is database a hardware or software?

997

---

How many types of normalization? What is the use of it?

1136

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1740

---