What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
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 an oracle tablespace?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What is SAVE POINT ?
Why do we use coalesce function in oracle?
How to run create database statement?
Explain the use of grant option in imp command.
How to invoke the data pump import utility?
Can a Tablespace hold objects from different Schemes ?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
how to get last monday of a month?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How to execute the package in oracle?