Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between primary key & unique index ?
- 6 Answers
- 27059 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
How to create db2 table in mainframe?
What is the use of with ur in db2?
What is the reason behind not using select * in embedded sql programs?
What is table space in db2?
What is multi row fetch in db2?
What is a dbrm in db2?
Explain the benefits you can get from mainframe connect?
What is the syntax for creating a table in the db2 database?
What is the purpose of using commit?
Can you use max on a char column?
What is a db2 collection?
Which component is responsible for db2 startup and shutdown?
How does a cursor work?
How to access db2 tables in mainframe?
What is db2 look?
