What is the difference between Primary key and
unique index?
Answer Posted / guest
The primary key is used to establish referential integrity
relationship with another table and a Unique index is used
to to enforce uniqueness.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What does runstats do in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is null in db2?
How to get the ddl of a table in db2?
When the like statement is used?
Differentiate between cs and rr isolation levels? Where do you specify them?
Why db2 is called db2?
What are union and union all?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is sqlca’s maximum length?
How can deadlocks be resolved?
Explain what are the various isolation levels possible?
What is clone table?
what is a corelated subquerry?
What is a plan and package in db2?