Answer Posted / shreekumar nair

unique key will only allow unique values in that particular column ...but it allows multiple NULL values ...since null values are not equal to an another null value...

whereas in a primary key column we can't have that ...

How to grant create session privilege to a user in oracle?

995

---

What is bind variable in oracle 11g?

1037

---

What is the difference between a primary key & a unique key?

1086

---

What is format trigger?

2062

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1928

---

Can select statements be used on views in oracle?

1022

---

How to connect asp pages to oracle servers?

1069

---

what is normalisation?what are its uses?

2267

---

How to update a table row with a record?

1006

---

What are the different types of partitions in oracle?

970

---

Explain an index?

1125

---

Differentiate between function and procedure in oracle.

1070

---

What is a system tablespace and when it is created?

970

---

What is the purpose of save points in oracle database?

1103

---

What is an oracle recycle bin?

1005

---