Difference between primary key and unique key ?

Answer Posted / sikander

Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does sharding mean?

768


Difference between open_form and call_form in oracle.

885


What is a proxy class?

752


How to export data to a csv file?

852


How to connect ms access to oracle servers?

737


What is an oracle tablespace?

788


How to use null as conditions in oracle?

774


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1757


How to run create database statement?

773


material view and view disadvantages?

817


What is the meaning of recursive hints in oracle?

769


What is a data lock in oracle?

805


How do I manually create a database in oracle?

748


What is the difference between translate and replace?

815


What is an oracle recycle bin?

732