Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Primary key and
unique index?
- 6 Answers
- 10002 Views
- I also Faced
- E-Mail Answers
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 the syntax for FETCH in DB2 ?
Is db2 a programming language?
What is dbrm in db2 database?
What are the rules for db2 programming?
What are the various isolation levels possible?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Which isolation level provides highest data integrity?
Can one database have multiple instances?
What is a collection in db2?
Which component is responsible for db2 startup and shutdown?
What is the purpose of rollback and commit?
How do you select a row using indexes in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is deadlock in db2?
