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.

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

Which command is used to delete a package?

0 Answers  

---

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

What do you mean by table in sql?

0 Answers  

---

Is primary key is clustered index?

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

How to call a javascript function from pl sql?

0 Answers  

---

Does sql backup shrink transaction log?

0 Answers  

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---

What is the life of an sql statement?

0 Answers  

---