| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How would one remove old reorg information from the DB2
catalog? | | 1 |
| What is a view? Why use it?
| | 2 |
| What is meant by isolation level? | | 1 |
| What is EXPLAIN? | | 1 |
| What is a host variable? | | 1 |
| Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do? | | 1 |
| Explain the use of the WHERE clause? | | 1 |
| What is a thread? | | 1 |
| What is the purpose of the WHENEVER statement? | | 1 |
| What is the cascade rule and how does it relate to
deletions made with a subselect? | | 1 |
| What is the difference between IN subselects and EXISTS
subselect? | HCL | 1 |
| What is ACQUIRE/RELEASE in BIND? | | 2 |
| Assuming that a site's standard is that pgm name = plan
name, what is the easiest way to find out which Will
precompile of an DB2-COBOL program bomb, if DB2 is down? | | 1 |
| What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run? | | 1 |
| How do u achieve record level locking in DB2 versions when
record level locking is not allowed? | | 2 |
| How can you split a table in to exactly half? | HSBC | 4 |
| what is the process of precompiler? | | 2 |
| How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it? | Wipro | 4 |
| what needs to be done if a table is in copy pending / check
pending status? | Xansa | 4 |
| What are the disadvantages of PAGE level lock? | | 3 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
