Difference between primary key and unique key ?

Answer Posted / ark chowdary

7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.

Is This Answer Correct ?    77 Yes 47 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe varray?

589


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

590


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

557


How do you find current date and time in oracle?

590


What do you know about normalization? Explain in detail?

499






How do you tell what your machine name is and what is its IP address?

1516


How to define a data field as not null?

631


What is the difference between online and offline backups?

560


How do I use unicode codesets with the weblogic jdriver for oracle driver?

551


How to set a transaction to be read only in oracle?

582


Explain an index segment?

643


is there a tool to trace queries, like profiler for sql server?

606


What is set operator oracle?

528


Why we use bulk collect in oracle?

536


How to select some columns from a table in oracle?

553