Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7220 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 "if" statements on multiple conditions?
What are the set operators union, union all, minus & intersect meant to do?
How to start a specific oracle instance?
How to pass a cursor variable to a procedure?
What the is the diff between local index and global index. give some example.
What is flashback in Oracle?
Which is faster join or subquery in oracle?
How to write a query with an inner join in oracle?
What do you mean by redo log file mirroring?
How to loop through data rows in the implicit cursor?
What happens if variable names collide with table/column names?
What is an oracle and why it is used?
How does oracle handle read consistency?
How can Oracle users be audited?
How to retrieve data from an cursor to a record?
