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 27672

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 11502

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

Wipro,

2 8225

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

IBM,

10 18071

can any one expalin check point with an example?

1 5219

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

Syntel,

3 9868

What is the difference between base table and view?

7 33010

What is UNION,UNION ALL?

2 13441

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 10905

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

8 21263

How to create a table using embedded sql?

1 6013

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

IBM, Infosys,

2 33782

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 19457

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

Accenture,

4 20553

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

CSC,

5 15221

Post New DB2 Questions

Un-Answered Questions { DB2 }

what is a corelated subquerry?

1166

Define predicate?

1200

How will you return the number of records in table?

986

How do I start db2 in windows?

1138

How connect db2 database to datastage?

1289

What is page size in db2?

1022

What is db2 bind?

1127

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2766

What is reorg and runstats in db2?

1259

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9350

Are view updateable?

1086

What is the purpose of rollback and commit?

1276

How to get the ddl of a table in db2?

1168

What is a Foreign Key?

1138

How to take backup of table in db2?

1121

For More Un-Answered { DB2 } Questions Click Here