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 27434

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 11084

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

Wipro,

2 7974

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

IBM,

10 17400

can any one expalin check point with an example?

1 5056

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

Syntel,

3 9612

What is the difference between base table and view?

7 32491

What is UNION,UNION ALL?

2 13274

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 10536

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

8 20640

How to create a table using embedded sql?

1 5821

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

IBM, Infosys,

2 33436

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 18938

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

Accenture,

4 20239

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

CSC,

5 14769

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by rollback?

932

What is the syntax for FETCH in DB2 ?

1140

What is dbrm? What it contains? When it will be created?

994

Mention the location where the output received from explain statement is stored.

1056

What is temporal table in db2?

990

Define buffer pool.

999

How do I add a column to a table in db2?

1051

Can we insert update delete in view?

912

What is meant by union and union all?

948

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2170

What is page size in db2?

906

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1182

What is meant by explain?

1063

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1034

How do I optimize a query in db2?

1042

For More Un-Answered { DB2 } Questions Click Here