Difference between primary key and unique key ?

Answer Posted / shakeel shikari

the difference is only primary key does not accept null values
while unique key accept null value
remember that unique key holds null only once

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is insert all statement in sql

5533


What are set operators?

660


What are temporal data types in oracle?

605


Explain what does a control file contain?

619


Write a trigger example in oracle?

580






What is a cognitive schema?

531


How to do paging with oracle?

583


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1535


What is the difference between 10g OEM and 11g OEM?

567


How to compare dates in oracle sql?

667


What do you mean by group by clause?

567


Why oracle is used?

589


Can we insert data in view oracle?

547


What is an oracle transaction?

594


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1575