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 does db2 stand for?
what is a corelated subquerry?
If I have a view which is a join of two or more tables, can this view be updateable?
What does db2 plan contain?
What is the difference between db2 and oracle?
Is db2 a programming language?
What are the two types of logging in the db2 database? Explain them.
Which isolation level provides maximum concurrency?
What is ibm db2 connect?
What is db2 plan table?
What is coalesce in db2?
What is an instance database?
What is with ur in db2?
Define check constraint.
What is the difference between using bind () and rebind () methods of naming class?