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 |
Explain the truncate in oracle?
What is a Segment ?
How you open and close a cursor variable.Why it is required?
What are the types of partitions in oracle?
How to rename an index?
What is a connect identifier?
How to select all columns of all rows from a table in oracle?
What is a Sequence ?
Can group functions be used in the order by clause in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Difference between join and a subquery?
8 Answers Base Automation, NMDC,