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
- 6930 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
How to count groups returned with the group by clause in oracle?
How to initialize variables with default values?
Can we store images in oracle database?
Explain the use of owner option in exp command.
What do you understand by a database object? Can you list a few of them?
What is the difference between pre-select and pre-query?
Explain self joins in oracle?
How to export your connection information to a file?
What is snapshot is too old? Give and example for better understand.
What is a trace file and how is it created in oracle?
Difference between hot backup vs. Cold backup?
how can we store any pdf file in oracle
Explain the features of oracle?
What is a connect identifier?
Why do we need integrity constraints in a database?
