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.
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
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
In which language oracle has been developed?
What is rich query?
What is the difference between a primary key & a unique key?
What are privileges and grants?
How to use like conditions in oracle?
What is blob data type in oracle?
Explain about achiever in sql?
Can group functions be used in the order by clause in oracle?
How to find the duplicate rows count from employees table in oracle?
What is a cursor and what are the steps need to be taken?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
WHAT IS ecc 6.0