What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

Can we edit a view in sql?

0 Answers  

---

What will happen after commit statement ?

2 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

what is overloading procedure or overloading function ?

3 Answers   Genpact,

---

What is rowtype?

0 Answers  

---

What is materialized view in sql?

0 Answers  

---

What is varchar example?

0 Answers  

---

What is anonymous block in sql?

0 Answers  

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---

Why we use pl sql?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---