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 12487

what are the bind parameters?

IBM,

5 39955

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 9305

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

IBM,

10 15038

what is dynamic cursor?gives syntax for this?

TCS,

1 5395

wht is d/f between union and joins ?

2 6405

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

2 6573

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

Infosys,

3 9317

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

3157

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 8855

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

IBM,

2 7036

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

IBM,

1 4534

select 100 records from million records ?

Verizon,

2 7987

cursor with hold explain ?

Verizon,

1 6367

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

TCS,

1 5952

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I delete a table in db2?

1073

Explain in detail about buffer manager and its functionalities?

1066

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1439

What is schema in db2?

1022

What is dbrm? When it will be created?

1029

What is the difference between cursor and select statement?

1103

What is db2 connect?

1070

What db2 400?

1191

How does cobol compile db2 program?

1060

What are concurrency issues?

1097

How do you pull up a query which was previously saved in qmf?

1151

What is cloudant database?

1096

What is bind and rebind in db2?

1139

What is declare cursor?

1123

What is db2 purescale?

1004

For More Un-Answered { DB2 } Questions Click Here