What is the difference between primary key & unique index ?
Answer Posted / s
Primary Key uniquely identifies the record and the UNIQUE
index on the primary key ensures that no duplicates values
will be stored in the table.
| Is This Answer Correct ? | 16 Yes | 14 No |
Post New Answer View All Answers
How connect db2 database to datastage?
What is runstats utility in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the purpose of rollback and commit?
What is the reason behind not using select * in embedded sql programs?
How to find schema of a table in db2?
Name the lockable units in DB2?
How to rename a table in DB2 ?
What are bind parameters in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Explain various types of locks in db2?
What types of tables are there in the db2 database?
Explain package in db2 and its advantages?
What is bufferpool in db2?
What is the use of runstats in db2?