Answer Posted / 1

There is a clear difference between the 2. A unique
constraint defines what combination of columns has to be
unique. A unique index is just a way of making sure the
above is always valid. But it's possible to have a non-
unique index supporting a unique constraint. (if the
constraint is deferable = Only has to be valid at commit
time but is allowed to be broken in the middle of a
transaction)

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1122

---

What is row_number () in sql?

929

---

Does sql view stored data?

894

---

Is a foreign key always unique?

882

---

Which is better join or inner query?

956

---

what is the stuff function and how does it differ from the replace function? : Sql dba

988

---

What is the starting oracle error number? What is meant by forward declaration in functions?

936

---

What makes a good primary key?

976

---

What is where clause in sql?

980

---

Can we use insert statement in function?

937

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

918

---

Why truncate is faster than delete?

1052

---

What can I use instead of union in sql?

902

---

What is join view in sql?

893

---

what is collation? : Sql dba

1077

---