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
- 5883 Views
- I also Faced
- E-Mail Answers
Answer Posted / shwetalguglanicse
Primary key can be assigned to only 1 column in the table but
this is not with unique key
And UK allow duplicate value but PK does not .
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is control file used for?
How to rebuild an index in oracle?
How to retrieve data from an explicit cursor?
How to get a list of all background sessions in the database?
How to join two tables in a single query using oracle?
How do we display rows from the table without duplicates?
What are the uses of a database trigger?
What are the four Oracle system processes that must always be up and running for the database to be useable?
please explain.. DB architecture ...
Explain enable novalidate constraint.
What is the recommended interval at which to run statspack snapshots, and why?
What is set operator oracle?
How to invoke the original export import utilities?
How to define a record variable to store a table row?
