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 pl sql block structure?

0 Answers  

---

Can procedure in package be overloaded?

0 Answers   EXL,

---

Explain how can you save or place your msg in a table?

0 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

How many unique keys can a table have?

0 Answers  

---

What is sql partition function?

0 Answers  

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

Is crud a cuss word?

0 Answers  

---