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?

1 7098

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 5185

how do you resolve -805?

HCL,

3 8725

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 11915

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

3 8824

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

Tech Mahindra, Wipro,

2 14568

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 9147

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

CTS,

4 13710

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

CTS, IBM,

3 19650

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

CTS,

2 8089

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 7514

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 9527

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 5900

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

CGI, Value Labs,

2 8594

What is db2 isolation?

2 6443

Post New DB2 Questions

Un-Answered Questions { DB2 }

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1646

How do I delete a column in db2?

676

How to create db2 table in mainframe?

629

Explain about open switch business continuity software?

563

How to find schema of a table in db2?

570

What is a system catalog table in db2?

582

Define db2 and its databases?

618

What is difference between rollback and commit?

616

Mention data types used in db2 ?

671

What is the meaning concurrency in the db2 database?

630

What is host variable?

590

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

581

What is phantom read in db2?

636

What is the use of reorg in db2?

602

What are concurrency issues?

626

For More Un-Answered { DB2 } Questions Click Here