IBM DB2 Question:
Download Job Interview Questions and Answers PDF
What is the difference between primary key & unique index ?
Answer:
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
Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table
Download IBM DB2 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is a clustering index ? | What is sqlcode -922 ? |