| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is lock escalation? | | 2 |
| 5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued? | | 2 |
| what is contained in the DB2 node lock file?
A) data base names
B) data base users names
C) license keys
D) server names
| Accenture | 4 |
| Explain transactions, commits and rollbacks in DB2. | | 2 |
| Can SQL statements/queries be included in a copybook? | | 1 |
| What is a clustering index? | | 2 |
| What technique is used to retrieve data from more than one
table in a single SQL statement? | CTS | 6 |
| what is differnece between DROP TABLE & DELETE TABLE . | Cap-Gemini | 3 |
| What is the difference between Where and Having Clause | iFlex | 3 |
| What is deadlock? | | 1 |
| When do you specify the isolation level? How? | | 1 |
| When would you prefer to use VARCHAR? | | 3 |
| I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this? | | 3 |
| I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP! | Tech-Mahindra | 15 |
| Suppose I have a program which uses a dynamic SQL and it
has been performing well till now. Off late, I find that
the performance has deteriorated. What happened? | | 1 |
| Once you create a view, where would information about the
view be stored? | | 1 |
| What is the difference between a package and a plan? | Infosys | 5 |
| How do you define a correlated name? | | 1 |
| 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 is FREEPAGE and PCTFREE in TABLESPACE creation? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
