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

DB2 Interview Questions

Questions Answers Views Company eMail

What is query for your birthday date should be in hours,minute and seconds format?

Fidelity,

1 7828

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

HCL,

1 6248

how do you resolve -805?

HCL,

3 10008

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

Fidelity,

10 13990

how to unload different table data into different gdg files/ vsam files.

3 9938

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

Tech Mahindra, Wipro,

2 15951

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 11133

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

CTS,

4 15442

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

CTS, IBM,

3 21450

select distinct(empid),distinct(dept),name from EMP will the above query work?

CTS,

2 9019

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

CTS,

3 8673

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

CTS, IBM,

4 11171

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 6581

my project is insurance management system,how to explain my work environment in interview?

CGI, Value Labs,

2 9561

What is db2 isolation?

2 7235

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which command is used to remove all rows from a table?

1041

Define data page.

1015

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

1018

How to resolve deadlock issue

19874

What are union and union all?

921

What is runstats and reorg in db2?

1242

What is db2 connect?

1010

what is diffrence b/w file-aid tool and file-aid utility???

4812

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1057

Where do you specify them?

1168

Name the lockable units in DB2?

1075

What are db2 tables?

1053

How does db2 sample database connect?

975

What are the rules for db2 programming?

1043

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

1137

For More Un-Answered { DB2 } Questions Click Here