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,

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

Why is the cursor important?

0 Answers  

---

What are sql procedures?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

what is an index? : Sql dba

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---