What is the difference between Primary key and
unique index?
Answer Posted / guest1
Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is db2 instance?
When do you specify the isolation level?
What is the maximum No of rows per page?
What is meant by dclgen?
Which components manage deadlocks in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a bind card?
What is the role of data manager in the db2 database?
What db2 400?
What is lock escalation in db2?
How to view db2 table structure?
What is declare cursor?
What is the role of schema in the db2 database?
What does db2 blu stand for?
How do I delete a table in database?