What is the difference between primary key & unique index ?

Answer Posted / mehdee

- Each primary key must associate with a unique index, but
unique index dose not have to associate to the primary key.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null indicator in db2?

606


Which is faster delete or truncate?

681


What do you mean by commit and rollback?

598


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

655


How can deadlocks be resolved?

544






What is performance tuning db2?

620


How to run db2 command in windows?

654


What is the advantage in De-normalizing tables in DB2?

749


What is host variable?

598


What parameters are used to control the free space in DB2?

645


How do I connect my db2 database to ibm?

604


What is view db2?

626


Differentiate between cs and rr isolation levels? Where do you specify them?

587


Which component is responsible for processing sql statements and selecting access paths?

671


How do I delete a table in db2?

651