Difference between primary key and unique key ?
Answer Posted / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Delete, Truncate and Drop in Oracle?
What are the advantages of oracle?
When do we use group by clause in a sql query?
How to retrieve values from data fields in record variables?
How to drop an index in oracle?
What is oracle latest version?
Explain a synonym?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the use of record option in exp command.
How to create an oracle database?
Explain how are indexes update?
material view and view disadvantages?
How to drop a tablespace?
What is a table index?
Explain the use of inctype option in exp command.