DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

how do u update the faltfile into db2 table ?

RBS, TCS,

4 11104

what is static sql? what is dynamic sql? Give me details

3 8194

what is sql abend code -801,-802?

2 27257

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 4793

wht steps we need will coding cobol and db2 pgm ?

CGI,

6 10393

db2 restart logic ?

DELL, HTC, UHG,

1 12262

what are stage one indexable predicates?

1 6278

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 6737

How to handle null values in db2

4 20233

wht r the requirements for writing a cobol-db2 pgm ?

IBM,

4 8959

pls explain the precompilation process of cobol-db2 pgm

HCL, IBM,

3 23445

What is the use of DELGEN in DB2? Can we Write the program with out using it?

Cap Gemini,

6 17526

What are the abend codes occour in ur latest PROJECT in DB2

Cap Gemini,

2 8788

Return code 100 means?

Cap Gemini,

6 10858

What is the use of COMMAREA ?Minimum how much data we can pass from it?

Cap Gemini,

7 29961

Post New DB2 Questions

Un-Answered Questions { DB2 }

How many types of page locks can be held in db2?

1042

How can you do the explain of a dynamic sql statement?

1069

What are foreign keys in db2?

1105

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

What is buffer pool?

1106

What are db2 objects?

1046

Define buffer pool.

1056

What is iseries database?

1048

What is the difference between using bind () and rebind () methods of naming class?

1401

What is db2 and what is the use of db2 optimizer?

1067

Define predicate?

1132

Is db2 a mainframe database?

1000

Is it possible using max on a char column?

1139

What are types of indexes?

1073

What is the maximum size of varchar data type in db2?

1135

For More Un-Answered { DB2 } Questions Click Here