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

DB2 Interview Questions

Questions Answers Views Company eMail

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

IBM, scintel,

1 12471

what are the bind parameters?

IBM,

5 39930

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

EDS,

5 9287

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

IBM,

10 15017

what is dynamic cursor?gives syntax for this?

TCS,

1 5385

wht is d/f between union and joins ?

2 6389

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 6562

What is the specific need of Plan and..where are the tables in DB2 are physically saved

Infosys,

3 9295

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

Infosys,

1 8842

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

IBM,

2 7019

Plan has the optimized access path in it. But is that optimized access path is attained or known

IBM,

1 4526

select 100 records from million records ?

Verizon,

2 7982

cursor with hold explain ?

Verizon,

1 6359

i have a db2 variable how do u declare tht into working storage section ?

TCS,

1 5940

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the contents of dclgen?

1107

What are bind parameters in db2?

1044

What db2 400?

1180

What is host variable?

1054

How do I optimize a query in db2?

1095

What is commit in db2?

1053

What is the physical storage length of the data types date, time, and timestamp?

1084

How is deadlock resolved?

1146

Is it possible using max on a char column?

1137

List some fields from sqlca?

1056

What is a db2 tablespace?

1061

What is db2 connect?

1064

What is the default page size of buffer pools?

1122

What is the purpose of rollback and commit?

1190

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2242

For More Un-Answered { DB2 } Questions Click Here