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.

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

0 Answers  

---

Which tcp/ip port does sql server run?

0 Answers  

---

Can you inner join the same table?

0 Answers  

---

What is bind variable in pl sql?

0 Answers  

---

What is sqlcontext?

0 Answers  

---

What are some emotional triggers?

0 Answers  

---

Differentiate between syntax and runtime errors.

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---