What is the difference between Primary key and
unique index?
Answer Posted / sunny kalra
Primary key: a relational database constraint. Primary key consists of one or more
columns that uniquely identify a row in the table. For a normalized relation, there
is one designated primary key.
Unique index: a physical object that stores only unique values. There can be one
or more unique indexes on a table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is db2 restart?
What is nvl in db2?
List out the buffer pools in db2
What is bind plan?
What is the difference between dbm cfg and db cfg file in db2 ?
How is the value function used?
What does runstats do in db2?
What is the use of runstats in db2?
What are the bind parameters ibm db2?
What is the role of the data page in the db2 database?
What is a db2 cursor?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the use of db2 optimizer?
Why do we use cursor?
What do you mean by commit and rollback?