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 ??

CGI, UST, Xansa,

2 27584

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 11318

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

Wipro,

2 8114

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

IBM,

10 17767

can any one expalin check point with an example?

1 5163

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

Syntel,

3 9750

What is the difference between base table and view?

7 32823

What is UNION,UNION ALL?

2 13380

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 10772

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

8 21040

How to create a table using embedded sql?

1 5937

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

IBM, Infosys,

2 33637

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 19186

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

Accenture,

4 20419

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

CSC,

5 15029

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is null indicator in db2?

1113

What is dclgen in db2?

1148

Is db2 free?

1094

What is table space in db2?

1019

What is access path in db2?

986

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

What is the syntax for creating a table in the db2 database?

1107

How to retrieve rows from a db2 table in embedded sql?

1391

what is the sqlcode -501

13152

What is a buffer in memory?

1058

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1061

What is rebind in db2?

1066

Explain the contention situations caused by locks?

1070

What is the connection string to connect to the DB2 Database ?

1128

What is runstats and reorg in db2?

1304

For More Un-Answered { DB2 } Questions Click Here