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

DB2 Interview Questions

Questions Answers Views Company eMail

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

1976

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 5448

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

8 13799

wht happens if we close cursor with cursor with hold option?

Valtech,

3 12266

what is main use of table space and index object? please its urgent

CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

5 15946

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

IBM,

3 18392

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

IBM, TCS,

2084

How can we define a table? How can we apply SEARCH ALL on it ?

1 4531

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

Deloitte,

2 7132

what is the use of commit ? and what is the syntax?

Deloitte,

2 10182

what is the difference between declaring the cursor in WS section and Procedure division?

HCL,

1 8318

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

Cap Gemini,

9 14199

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 10070

Can any one tell me about Restart logic in DB2.

2 7167

Do we need cursor for Count(*)?

iGate,

4 8856

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to retrieve rows from a db2 table in embedded sql?

1328

How to check last update on table in db2?

1004

Which component is responsible for db2 startup and shutdown?

985

How do I delete a column in db2?

1051

Name the various locking levels available?

1036

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2670

What is db2 stogroup?

1096

What is difference between isnull and coalesce?

1010

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2280

How do I change the column size in db2?

1084

What is ibm db2 client?

882

Mention data types used in db2 ?

1109

What is clone table?

999

What is the purpose of rollback and commit?

1089

What is schema in db2?

963

For More Un-Answered { DB2 } Questions Click Here