| Other DB2 Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins? |
| 1 |
| what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain? |
Cap-Gemini | 3 |
| what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN) |
IBM | 4 |
| What is an alias and how does it differ from a synonym? |
| 3 |
| What is the maximum number of tables that can be stored on
a Partitioned Table Space ? |
| 1 |
| Write a query to retrive partial string. |
| 2 |
| If we have 100 records in the PF, we deleted all the records
then what is the Size of the PF? |
| 2 |
| What is the difference between Where and Having Clause |
iFlex | 7 |
| What is correlation names? |
| 1 |
| What happens to the PLAN if index used by it is dropped? |
| 1 |
| wht is d/f between union and joins ? |
| 2 |
|
Select empno, sal from emptbl where empno < 101.By this
query can we fetch first 100 recs? where empno is primary
key.It won't throw -811 error? if it wont,then what is use
of cursor technique while fetching first 100 recs.
Please need more clarification. |
| 2 |
| |
| For more DB2 Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
