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 26255

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 9264

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

Wipro,

2 6962

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

IBM,

10 15069

can any one expalin check point with an example?

1 4282

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

Syntel,

3 8285

What is the difference between base table and view?

7 30250

What is UNION,UNION ALL?

2 12318

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 8773

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

8 17868

How to create a table using embedded sql?

1 5155

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

IBM, Infosys,

2 31652

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 16483

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

Accenture,

4 18421

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

CSC,

5 12991

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

6684

How do I import data from excel to db2?

605

Explain various types of locks in db2?

675

What does a deadlock mean in DB2?

641

What is a db2 table?

585

When do you specify the isolation level?

600

Is the primary key a clustered index?

595

How to execute stored procedures?

608

Is db2 a mainframe database?

555

What is commit in db2?

585

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

730

What is bind in db2?

593

What is a storage group (stogroup)?

764

Is it possible to create an Instance in DB2 using DB2 Control Center ?

618

What kind of database is db2?

559

For More Un-Answered { DB2 } Questions Click Here