the difference is only primary key does not accept null values while uniqu

Difference between primary key and unique key ?

Question Posted / shakeel shikari

Answer Posted / shakeel shikari

the difference is only primary key does not accept null values
while unique key accept null value
remember that unique key holds null only once

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you create a synonym without having a table?

1090

What happens to the indexes if a table is recovered?

1045

What are the differences between char and varchar2 in oracle?

1246

What is data block in Oracle?

1148

What is an oracle user account?

1039

What is execute immediate in oracle?

1077

What is the exact use of Collections?

2190

Please explain oracle left join with an example?

1092

What is oracle sid?

1003

How to check the oracle tns settings?

1087

Calculate difference between 2 date / times in oracle sql?

1097

What is the fastest query method to fetch data from the table?

1413

What are dml statements in oracle?

1130

Explain what are the different type of segments?

1003

What is the Tune Query

2345