What is the difference between primary key & unique index ?
Answer Posted / shankar
Primary Key cannot have NULL values in it wherein an
UNIQUE index can have one NULL value in it.
Is This Answer Correct ? | 37 Yes | 3 No |
Post New Answer View All Answers
What is multi row fetch in db2?
How does coalesce work?
What is db2 connect?
Is the primary key a clustered index?
What are foreign keys in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
When do you specify the isolation level?
Why do we need reorg in db2?
What is consistency token in db2?
What is the advantage in De-normalizing tables in DB2?
What does db2 stand for?
Explain packages.
What is reorg and runstats in db2?
What is the max length of sqlca?