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 a data lock in oracle?

1111

How to divide query output into groups in oracle?

989

What is meant by joins?

1058

How to turn on or off recycle bin for the instance?

1079

material view and view disadvantages?

1065

How would you change old and new values in an insert, delete and update triggers?

1019

What is the difference between truncate & delete command?

1179

can u plz provide me oca sql dumps please i need them

1945

How to delete a column in an existing table in oracle?

1069

What is oracle database client?

1030

How to create a stored procedure in oracle?

1102

Why is oracle used?

936

What do you mean by group by clause?

1042

How to do a full database export?

1104

Explain oracle data types with examples?

1025