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 : 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

• What is DCLGEN ?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• How do you select a row using indexes in DB2?
• What is QUIESCE?
• What is the meaning of underscore ( ‘_’ ) in the LIKE statement? –
• When do you use the IMAGECOPY? – –
• What is FREEPAGE and PCTFREE in TABLESPACE creation?
• How do you eliminate duplicate values in DB2 SELECT ?
• What is sqlcode -922 ?
• What is filter factor?
• More...