IBM DB2 Interview Question:

What is the difference between primary key & unique index ?

Submitted by: Administrator

Primary : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table
Submitted by: Administrator