What is the difference between primary key & unique index ?
- 6 Answers
- 24785 Views
- Patni, Temenos, I also Faced
- E-Mail Answers
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 the difference between drop table and delete table?
What is image copy in db2?
What is multi row fetch in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does db2 plan contain?
How can you classify the locks in db2?
What is a buffer in memory?
What is innodb buffer pool?
what is a corelated subquerry?
What is the use of db2 optimizer?
How can deadlocks be resolved?
How to rename a table in DB2 ?
Why do we need reorg in db2?
What os does db2 run on?
What is clone table?
