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 a formula column be obtained through a select statement ?

2316

what are bitmap indexes? How does they work?

2235

Explain an integrity constrains?

1140

How do I know if oracle client is installed on windows?

1020

How many types of table in Oracle?

1119

What is an oracle recycle bin?

1007

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2252

How to export data to a csv file?

1297

Why do you create or replace procedures rather that drop and recreate.

1003

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

969

How to check the oracle tns settings?

1045

What happens to the indexes if a table is recovered?

989

How to delete multiple rows from a table in oracle?

1060

What is open database communication (odbc) in oracle?

1003

Can we save images in a database and if yes, how?

1061