Primary key does not allow null values whereas in UNIQUE constraint we can

Difference between primary key and unique key ?

Question Posted / himanshu porwal

Answer Posted / himanshu porwal

Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to empty your oracle recycle bin?

1029

What is procedure overloading in oracle?

1066

How to create a temporary table in oracle?

1279

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2144

What are the restrictions on external table columns?

1060

What do you mean by a deadlock?

1070

What is rich query?

989

How to execute a stored procedure in oracle?

1098

How to start a specific oracle instance?

1042

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2056

How to define and use table alias names in oracle?

950

How data locks are respected in oracle?

1073

What to do if the binary spfile is wrong for the default instance?

1077

What is key preserved table?

1027

Explain what are synonyms used for?

1045