Difference between primary key and unique key ?

Answer Posted / chandra bhan kumhar

1. Primary key accepts a value only single time not more then one time means it doesn't allow repetition same as for unique key.
2. Primary key don't allow null values ,but unique key allow null values.

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 a Garbage Collection? and what is full recursive Garbage collection?

2401


What is oracle instant client?

583


What is the use of aggregate functions in oracle?

593


How to resolve name conflicts between variables and columns?

591


Explain the dml?

608






What is index-organized table in Oracle?

583


How to write an inner join with the where clause in oracle?

601


How to create a stored procedure in oracle?

589


What is a partition in oracle?

557


WHAT IS ecc 6.0

1675


How do I spool in oracle?

555


How does oracle handle read consistency?

687


In which language oracle has been developed?

663


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1691


How to define a record variable to store a table row?

587