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

Explain the blob datatype?

827


What is a proxy class?

768


What is oracle used for?

772


Explain joins in oracle?

793


How to write text literals in oracle?

870


How to calculate date and time differences in oracle?

790


What is an oracle user account?

785


What are the differences between date and timestamp in oracle?

811


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1697


What is meant by joins? List out the types of joins.

746


How to create a new tablespace in oracle?

766


What is the difference between truncate & delete command?

893


How to use existing values in update statements using oracle?

827


What is a trigger and what are its types in oracle?

785


How would you best determine why your MVIEW couldnt FAST REFRESH?

1655