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


Please Help Members By Posting Answers For Below Questions

What is multi row fetch in db2?

604


How does coalesce work?

586


What is db2 connect?

608


Is the primary key a clustered index?

610


What are foreign keys in db2?

616






Outputs of explain are with matchcols = 0. What does this signify?

619


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

749


When do you specify the isolation level?

608


Why do we need reorg in db2?

564


What is consistency token in db2?

640


What is the advantage in De-normalizing tables in DB2?

745


What does db2 stand for?

597


Explain packages.

664


What is reorg and runstats in db2?

694


What is the max length of sqlca?

764