What is the difference between primary key and u

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the difference between primary key and unique index?

Primary key: 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.

(Continued on next question...)

Other Job Interview Questions

• Explain the use of the WHERE clause?
• What is COPY PENDING status ?
• What is a view ? Why use it
• Can I use LOCK TABLE on a view?
• What is dynamic SQL?
• What is a root page?
• What does the RUNSTATS Utility do?
• How many buffer pools are available in DB2
• How are write I/Os from the buffer pool executed
• What is a LIKE table and how is it created?
• More...