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

Explain the use of file option in exp command.

601


What is the parameter mode that can be passed to a procedure?

575


Explain integrity constraint?

646


Explain constraining triggers.

598


What is snapshot is too old? Give and example for better understand.

1100






How do I connect to oracle database?

537


What is catalog in Oracle?

654


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1652


How to create a table interactively?

562


How to drop a tablespace?

574


What do you mean by merge in oracle?

593


How to run create database statement again?

623


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?

1525


Explain cascading triggers.

574


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1759