what are the advantages of primary key over unique+notnull
- 7 Answers
- 20894 Views
- Consultancy, LGS, Oracle, I also Faced
- E-Mail Answers
Answer Posted / soubhagya
When we create a primary key automatically a cluster index
is created on those columns involved in primary key.But
this index not created in unique+not null key, it only
restrict the duplicate values.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
what are the differences between require and include, include_once and require_once? : Sql dba
What is parameter substitution in sql?
Which sorts rows in sql?
How to process query result in pl/sql?
Explain 3 basic parts of a trigger.
Can a trigger call a stored procedure?
How can you view the errors encountered in a trigger?
What are user defined functions?
What is view? Can we update view
What does select * from mean in sql?
How do you clear the screen in sql?
Is sql developer case sensitive?
What are reports usually used for?
What is difference between sql and oracle?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
