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 12577

what are the bind parameters?

IBM,

5 40186

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 9471

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

IBM,

10 15301

what is dynamic cursor?gives syntax for this?

TCS,

1 5456

wht is d/f between union and joins ?

2 6512

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

2 6663

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

Infosys,

3 9473

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

3202

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 8930

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

IBM,

2 7180

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

IBM,

1 4616

select 100 records from million records ?

Verizon,

2 8081

cursor with hold explain ?

Verizon,

1 6464

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

TCS,

1 6059

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1155

What is cascading rollback?

1274

How to find the number of rows in a db2 table?

1154

Why cursor is used in db2?

1087

Which component is responsible for db2 startup and shutdown?

1079

What is view db2?

1130

What is the connection string to connect to the DB2 Database ?

1171

How can we read records for specific member in CL? AND rpg?

757

What kind of database is db2?

1081

What's The Error Code For Unique Index Voilation?

1299

what is db2 restart?

2213

How many databases can be created inside an instance in db2 ?

1084

Which command is used to remove all rows from a table?

1175

What is a bind in db2?

1100

What is access path in db2?

1042

For More Un-Answered { DB2 } Questions Click Here