1) Primary key can not accept null values, but unique can accept null val

Difference between primary key and unique key ?

Question Posted / laxman k

Answer Posted / laxman k

1) Primary key can not accept null values, but unique can
accept null values.

2) only one primary key have in a table but max 249 unique
in a table

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the relation of a user account and a schema in oracle?

1006

Explain constraining triggers.

1042

What is tns service name?

1071

What is translate in oracle?

1048

Explain about achiever in sql?

979

How to use "out" parameter properly?

1022

What is the difference between a primary key & a unique key?

1037

How to use windows user to connect to the server?

934

How to change user password in oracle?

973

What is clustered table in Oracle?

1105

How to increment dates by 1 in oracle?

990

How to create a stored function in oracle?

1037

How can we view last record added to a table?

970

Does facebook use oracle?

979

what is the scenario where you take the database to NoArchivelog mode?

2257