What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 7585 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 will you identify oracle database software release?
Differentiate between post-database commit and post-form commit?
What is the usage of control file in oracle?
what is the difference between data migration and production migration.
How to connect the oracle server as sysdba?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
When do you get a .pll extension in oracle?
What is a Schema ?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How to drop a stored function?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Oracle General 
