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 11082

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

3 8175

what is sql abend code -801,-802?

2 27246

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 4788

wht steps we need will coding cobol and db2 pgm ?

CGI,

6 10367

db2 restart logic ?

DELL, HTC, UHG,

1 12243

what are stage one indexable predicates?

1 6272

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

3 6727

How to handle null values in db2

4 20221

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

IBM,

4 8945

pls explain the precompilation process of cobol-db2 pgm

HCL, IBM,

3 23420

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

Cap Gemini,

6 17506

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

Cap Gemini,

2 8772

Return code 100 means?

Cap Gemini,

6 10828

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

Cap Gemini,

7 29939

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is iseries database?

1046

When do you specify the isolation level?

1027

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1100

Explain about rct in db2?

1104

What is check constraint. Explain with example.

1100

What is dbrm library?

1048

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1187

Define data page.

1059

Highlight all the advantages that are attached to a package.

1111

What is a storage group (stogroup)?

1241

What is query_cache_limit?

968

What is phantom read in db2?

1153

What is a db2 schema?

1223

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

1038

Is db2 free?

1093

For More Un-Answered { DB2 } Questions Click Here