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 27580

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 11306

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

Wipro,

2 8109

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

IBM,

10 17744

can any one expalin check point with an example?

1 5155

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

Syntel,

3 9746

What is the difference between base table and view?

7 32803

What is UNION,UNION ALL?

2 13374

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 10754

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

8 21014

How to create a table using embedded sql?

1 5933

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

IBM, Infosys,

2 33618

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 19167

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

Accenture,

4 20409

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

CSC,

5 15016

Post New DB2 Questions

Un-Answered Questions { DB2 }

How does cobol compile db2 program?

1051

Mention the definition of cobol in varchar field.

1246

What is the difference between spufi and qmf?

1126

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1274

What is coalesce in db2?

1129

What is rct?

1229

Which component is responsible for db2 startup and shutdown?

1033

can all users have the privilage to use the sql statement select * (dml)?

1164

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

1112

Explain about open switch business continuity software?

1127

What are catalog tables in db2?

1046

What are the 2 sqlcodes that are returned?

1185

How to check sequence on a table in db2?

1056

what is the role of the cursor in db2?

1063

How to check table size in db2 sap?

1034

For More Un-Answered { DB2 } Questions Click Here