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 7900

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 6346

how do you resolve -805?

HCL,

3 10172

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 14371

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

3 10083

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

Tech Mahindra, Wipro,

2 16118

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 11425

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

CTS,

4 15668

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

CTS, IBM,

3 21678

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

CTS,

2 9128

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 8853

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 11337

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 6690

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

CGI, Value Labs,

2 9702

What is db2 isolation?

2 7345

Post New DB2 Questions

Un-Answered Questions { DB2 }

Give the name of some fields form sqlca.

1074

What is the use of predicate?

1039

How to execute stored procedure in db2 command editor?

1047

How to view db2 table structure?

1016

What is load replace in db2?

992

What os does db2 run on?

978

What does a deadlock mean in DB2?

1160

Is the primary key a clustered index?

1141

What is the role of data manager in the db2 database?

1103

i want to maintain uniqueness on pdf without make lf??????????

2153

what is the role of the cursor in db2?

1063

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

What is bufferpool in db2?

1049

What is precompiler in db2?

1012

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1055

For More Un-Answered { DB2 } Questions Click Here