Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 7304 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 |
How to invoke the data pump export utility?
what is difference between cartesian join & cross join even they give same result?
Why should I use oracle database?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
How to check database size in Oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is recovery manager(rman) backup in Oracle?
What is the function of Redo Log ?
Explain the function of optimizer in oracle?
Why do we need integrity constraints in a database?
What is the use of aggregate functions in oracle?
What is a sub query and what are the different types of subqueries?
Oracle General 
