What is the difference between primary key & unique index ?
Answer Posted / mani
Primary key can be defined only one for a table whereas
number of unique indexes can be defined for a table.
primary key can not have null values but unique can have
null values and to remind one null value can never be equal
to another null value.
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What is host variable?
What is null indicator in cobol db2?
What is the information associated with sysibm.syslinks table?
Explain the contention situations caused by locks?
What is dclgen in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
On which levels locks can be applied?
Can we delete records from view?
What is a Foreign Key?
How will you return the number of records in table?
What is the latest version of ibm db2?
Why db2 is called db2?
what is db2 restart?
What is host variable in db2 cobol?
Mention some fields that are a part of sqlca.