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

What are the tools for Oracle ?

1058

How to check your oracle database 10g xe installation?

984

How do I limit the number of oracle database connections generated by weblogic server?

1068

How to update values in a table in oracle?

1018

How can I create database in oracle?

1014

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

Define oracle database

1041

Explain compound trigger in oracle?

1033

What are oracle functions?

1028

Is rowid unique in oracle?

998

Briefly explain what is literal? Give an example where it can be used?

1026

Explain table?

1109

What is an oracle user account?

986

What is an oracle database table?

1012

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1345