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
Can we insert update delete in view?
What does sqlcabc has?
What are the benefits of using the db2 database?
Explain the contention situations caused by locks?
What is a Foreign Key?
Why cursor is used in db2?
What is the maximum size of varchar data type in db2?
Explain db2.
Explain how can you do the explain of a dynamic sql statement?
Can we delete records from view?
Can you tell me how can you find out the # of rows updated after an update statement?
What is temporal table in db2?
What is a collection in db2?
Why do we bind in db2?
Define sqlca.