Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between primary key & unique index ?
- 6 Answers
- 27261 Views
- Patni, Temenos, I also Faced
- E-Mail Answers
Answer Posted / uddipto banerji
1. Primary Key is a column or a set of columns that uniquely identifies a row.Its purpose RECORD UNIQUENESS
2. Primary Key will not allow duplicate values.
3. Primary Key will not allow null.
4. Primary Key is not compulsory but recommended.
5. Primary Key helps to identify one record from another.
6. Only One Primary Key is allowed per table.
7. Unique Indexes is created automatically if there is Primary Key.
8. One table can combine upto 16 columns in a Composite Primary Key.
9. A table can have more than one Unique Key which is not possible in a Primary Key.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is db2 purescale?
What is host variable in db2 cobol?
What is plan in cobol db2?
What is rct?
What is package in cobol db2?
What is the syntax for creating a table in the db2 database?
What are the contents of a dclmgen?
Can we insert update delete in view?
Describe major components of db2?
What is innodb buffer pool?
How to restart a DB2 program?
what is utility for parm lib
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Mention data types used in db2 ?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
