Answer / neha sinha

1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)

Answer / neha sinha

1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)

Answer / ashok

Internally , There is same as primary key and unique not null.
You can say unique + not null is higher step of primary key .
So there is no basic difference between this two.

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

What are different methods to trace the pl/sql code?

0 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

How many functions are there in sql?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

What are literals in sql server?

0 Answers  

---

How do I remove duplicates in two columns?

0 Answers  

---

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---