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 7986

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 6416

how do you resolve -805?

HCL,

3 10318

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 14683

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

3 10197

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

Tech Mahindra, Wipro,

2 16232

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 11645

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

CTS,

4 15876

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

CTS, IBM,

3 21873

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

CTS,

2 9255

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 9024

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 11477

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 6768

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

CGI, Value Labs,

2 9822

What is db2 isolation?

2 7461

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cloudant database?

1153

Are views updateable?

1234

How is the value function used?

1204

List out the buffer pools in db2

1128

What is rct?

1287

What action db2 takes when a program aborts in the middle of a transaction?

1192

What is meant by explain?

1192

Explain in brief how does db2 determine what lock-size to use?

1085

What is iseries database?

1113

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9353

When the like statement is used?

1280

What is the role of union all and union

1185

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1129

What is an instance database?

1096

What are union and union all?

1030

For More Un-Answered { DB2 } Questions Click Here