Difference between primary key and unique key ?

Answer Posted / satendra dixit

Primary Key
1. Not Null
2. One primary key can be defined at on table

Unique Key
1. May be Null
2. one or more then 1, can be implemented

Is This Answer Correct ?    22 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the disadvantage of User defind function?

1834


How to change system global area (sga) in oracle?

572


What is dual table oracle?

527


How to start your 10g xe server?

596


Use of an integrity constraint is better to validate data. Explain

547






State the difference between a primary key and foreign key?

518


What is bulk load in oracle?

597


What is the difference between count (*), count (expression), count (distinct expression)?

561


What exactly do quotation marks around the table name do?

546


Explain index?

752


How to execute a stored program unit?

583


What is the oracle implicit cursor?

596


Difference between pre-select and pre-query

578


How do I find my oracle client driver version?

528


How do I know if oracle client is installed on windows?

498