What is the difference between Primary key and
unique index?

Answer Posted / rams

Primary Key is Unique and Not Null. Unique index can be defined on Primary Key or any other Unique column in the table. Unique index can have a Null Value unlike Primary Key.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between spufi and qmf?

641


How do you simulate the explain of an embedded sql statement in spufi/qmf?

637


Where can you declare a cursor in a cobol-db2 program?

606


What is load utility in db2?

671


Explain about rct in db2?

643






Explain correlated sub-queries.

589


What is check constraint. Explain with example.

650


How do I delete a table in database?

601


How do I import data from excel to db2?

617


What is a db2 table?

597


What is precompiler in db2?

589


What is runstats and reorg in db2?

800


What is cloudant database?

647


what is db2 restart?

1695


List out the three types of page locks that can be held.

689