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.

2011

How to select the duplicate rows from a table?

4 8424

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

Satyam,

2072

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

Satyam,

1 7445

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,

2125

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

IBM,

2 6284

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

IBM,

2 6979

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 10630

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 6596

how 2 resolve the -311 sqlcode

1 18825

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

3 11235

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

Mphasis,

2197

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

1 4812

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

ANZ,

4 9734

how can you access index

IBM, Tech Mahindra,

4 9411

Post New DB2 Questions

Un-Answered Questions { DB2 }

How does a cursor work?

931

What is meant by explain?

1064

What is catalog database in db2?

1102

What are db2 objects?

1003

Mention the downsides of page level lock.

1112

How to check sequence on a table in db2?

997

What is a db2 package?

991

What is node in db2?

989

B37 abend during spufi?

1406

How do I delete a column in db2?

1050

What is performance tuning db2?

1010

What is the maximum length of sqlca?

1438

What is meant by dclgen?

1061

What is bind package and plan in db2?

1006

Comment whether the cursor is closed during commit or not.

1042

For More Un-Answered { DB2 } Questions Click Here