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 7910

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 6351

how do you resolve -805?

HCL,

3 10192

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 14388

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

3 10093

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

Tech Mahindra, Wipro,

2 16125

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 11434

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

CTS,

4 15686

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

CTS, IBM,

3 21691

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

CTS,

2 9136

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 8860

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 11348

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 6696

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

CGI, Value Labs,

2 9711

What is db2 isolation?

2 7353

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 cursor?

1055

Can you use max on a char column?

1097

Is db2 a programming language?

1048

How do I import a csv file into db2?

989

can we view the access paths created by dbrm ? how ? thx

7096

What do you mean by between and in? Is between inclusive of specified range values?

1092

What is the physical storage length of date data type?

1253

How do I delete a table in database?

1021

What does reorg do in db2?

1029

Which isolation level provides maximum concurrency?

1152

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

What is netezza database?

1026

What is query_cache_limit?

970

What types of tables are there in the db2 database?

1056

What is the physical storage length of time data type?

1128

For More Un-Answered { DB2 } Questions Click Here