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
- 7061 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 much memory your 10g xe server is using?
Explain oracle left join with an example?
How can you use check constraints for self referential integrity?
What do you mean by a deadlock?
Explain the difference between a procedure and a function?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is the difference between translate and replace?
Why do we use coalesce function in oracle?
How to speed up webrick?
What are the different types of modules in oracle forms?
How to view the tablespaces in the current database?
Can you tell me how to add new column in existing views?how?How is possible?
What is blob data type in oracle?
Explain integrity constraints?
In oracle there is column command, how will you explain that?
