What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 6564 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / allin
The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.
Thanks & Regards,
RatnaRao
9833847339
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / naren
When ever you create a primary key constraint on perticular
column in a table it creates clustered index by default,
it cannot allow null values and a table having only one
primary key constraint. But in the case of Unique Key
constraint, it allow only one null value, it creates non-
clustered index by default and a table having multiple
unique key constraints.
Regards
Naren Krishna
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / kiran
if unique then it can have null
but if column has primary then it cannot have null values
and duplicate values
| Is This Answer Correct ? | 2 Yes | 1 No |
What is Hash Cluster ?
how to handle exceptions in post production
What is ceil and floor in oracle?
What is an external table?
How to handle a single quote in oracle sql?
what is the use of composite key constraint?
What happens if variable names collide with table/column names?
How to call a stored function in oracle?
What are the different editions of oracle?
How can I create database in oracle?
What WHERE CURRENT OF clause does in a cursor?
What is a Garbage Collection? and what is full recursive Garbage collection?
Oracle General 
