What is the difference between Primary key and
unique index?
Answer Posted / raghunathan
We can have only one Primary Key for a table(including multiple column) but can have any number of unique indexes in a table( limited to number of columns in that table)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does db2 stand for?
Explain db2.
What is db2?
What is the difference between cursor stability and repeatable read isolation levels?
How do you pull up a query which was previously saved in qmf?
Explain the function of data manager.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are db2 objects?
Explain about rct.
Which component is responsible for processing sql statements and selecting access paths?
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 is the maximum No of rows per page?
How to restart a DB2 program?
What is copy pending status in db2?
What is query_cache_limit?