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
- 7096 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 is an oracle database table?
How to display row numbers with the records?
is there a tool to trace queries, like profiler for sql server?
Is it possible to insert comments into sql statements return in the data model editor ?
How to join two tables in a single query using oracle?
How do I limit the number of oracle database connections generated by weblogic server?
Will you be able to store pictures in the database?explain.
How to define default values for formal parameters?
Explain the blob datatype?
Respected sir, Please send me technical questions related to oracle apps..
What is Reduced List of Values?
How to use regular expression in pattern match conditions in oracle?
How to enter a new row into a table interactively?
Write a trigger example in oracle?
What happens to the data files if a tablespace is dropped?
