DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2066

How to select the duplicate rows from a table?

4 8630

How do we specify index to include or not during bind process.

Satyam,

2126

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

Satyam,

1 7567

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

IBM,

2180

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

IBM,

2 6401

can we view the access paths created by dbrm ? how ? thx

IBM,

2 7098

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

IBM,

5 10832

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

IBM,

1 6683

how 2 resolve the -311 sqlcode

1 18958

how can i pull up a query which was previously stored in qmf

3 11398

What r the comman abends in db2, jcl and cobol???????

Mphasis,

2254

what is diffrence b/w file-aid tool and file-aid utility???

1 4892

how to get duplicate records from tables?write qurey for this?

ANZ,

4 9946

how can you access index

IBM, Tech Mahindra,

4 9642

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by cursor?

988

Is the primary key a clustered index?

1149

Is ibm db2 open source?

1075

What is the maximum No of rows per page?

1069

What is declare cursor?

1122

If I have a view which is a join of two or more tables, can this view be updateable?

1139

How would the varchar column remarks defined?

1088

What are the various isolation levels possible?

1122

What is db2 connect?

1069

What is host variable in db2 cobol?

1077

What are the bind parameters ibm db2?

1053

What is lock escalation in db2?

1033

When do you specify the isolation level?

1032

What is db2 catalog database?

1043

List down the data types in the db2 database.

1124

For More Un-Answered { DB2 } Questions Click Here