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 is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
B37 abend during spufi?
What is runstats db2?
What is cursor with hold option in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is consistency token in db2?
How can the duplicate values be eliminated from db2 select?
Is db2 relational database?
If I have a view which is a join of two or more tables, can this view be updateable?
What does db2 blu stand for?
What is dbrm?
Explain correlated sub-queries.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How many types of page locks can be held in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.