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
- 6438 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
What are oracle functions?
How to pass parameters to procedures in oracle?
How to select all columns of all rows from a table in oracle?
How to grant create session privilege to a user in oracle?
How to resolve the ORA-39133 error in Oracle?
What are triggers in oracle?
please explain.. DB architecture ...
How remove data files before opening a database?
How to download oracle database 10g xe?
How do I spool in oracle?
What is an oracle table?
What is a proxy class?
What is an external table?
Explain the use of ignore option in imp command.
Explain a data segment?
