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

DB2 Interview Questions

Questions Answers Views Company eMail

what is check point and restart Logic ? why do we go for that ??

2 26536

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

Perot Systems,

6 9773

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

Wipro,

2 7241

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

IBM,

10 15746

can any one expalin check point with an example?

1 4447

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

Syntel,

3 8673

What is the difference between base table and view?

7 30852

What is UNION,UNION ALL?

2 12560

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 9221

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 18516

How to create a table using embedded sql?

1 5297

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

IBM, Infosys,

2 32350

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

IBM,

7 17079

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

Accenture,

4 18840

what happend with out using Commit,when closing cursor and program?

CSC,

5 13369

Post New DB2 Questions

Un-Answered Questions { DB2 }

Why select is not preferred in embedded sql programs?

815

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

819

What is the difference between using bind () and rebind () methods of naming class?

906

How to find the maximum value in a column in the db2 database?

685

How can you quickly find out the # of rows updated after an update statement?

704

What is the reason behind not using select * in embedded sql programs?

706

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

4329

What happens in bind step in a db2 program?

648

If I have a view which is a join of two or more tables, can this view be updateable?

795

How to test SQL -911 error while developing COB-DB2 program

6905

what is the responsibility of the construction superintendent

1744

What do you mean by cursor?

681

What is a db2 package?

681

Explain what are the various isolation levels possible?

675

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1722

For More Un-Answered { DB2 } Questions Click Here