What is the difference between primary key & unique index ?
Answer Posted / mani
Primary key can be defined only one for a table whereas
number of unique indexes can be defined for a table.
primary key can not have null values but unique can have
null values and to remind one null value can never be equal
to another null value.
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What is concurrency?
What is access path in db2?
How do I connect my db2 database to ibm?
Explain about mirror activator disk mirroring?
How will you return the number of records in table?
Which are the db2 tools to protect integrity of the database?
What is the difference between cursor stability and repeatable read isolation levels?
Is the primary key a clustered index?
Is db2 a mainframe?
Can you use max on a char column?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Which component is used to execute the sql statements?
What is cloudant database?
Explain about cursor stability?
How do I import data from excel to db2?