WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.
- 3 Answers
- 6191 Views
- I also Faced
- E-Mail Answers
Answer Posted / manikanta
By default primary key maintain clusterd index,All the
records are stored in stored order.By takeing this
advantage query will be execute fast.
Unique maintain nonclusted index,All the records are not in
stored order.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to use regular expression in pattern match conditions in oracle?
What is a relational database management system?
Explain constraining triggers.
What are the different types of partitions in oracle?
Can you create a synonym without having a table?
When system tablespace is created?
What is bulk load in oracle?
Is oracle a relational database?
Explain the use of inctype option in exp command.
What are the differences between primary key and unique key?
What is the difference between a primary key & a unique key?
What is PL/SQL ?
How do I uninstall oracle client from windows?
How does the on-delete-cascade statement work?
How will you identify oracle database software release?
