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 11598

what are the bind parameters?

IBM,

5 37689

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 7476

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

IBM,

10 11997

what is dynamic cursor?gives syntax for this?

TCS,

1 4426

wht is d/f between union and joins ?

2 5173

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

2 5553

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

Infosys,

3 7244

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

2678

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 7865

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

IBM,

2 5892

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

IBM,

1 3683

select 100 records from million records ?

Verizon,

2 7002

cursor with hold explain ?

Verizon,

1 5457

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

TCS,

1 5075

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which is faster delete or truncate?

667

How can we retrieve the total number of records in RPG & CLLE?

186

What is lock escalation in db2?

564

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

698

What is a page in db2?

602

What is the difference between plan and package in db2?

564

What is temporal table in db2?

595

What is a collection in db2?

573

Explain about rct.

639

Is db2 a mainframe?

579

How to find the number of rows in db2 tables?

605

Can we delete records from view?

551

Can we update view in db2?

551

What kind of database is db2?

563

What is query_cache_limit?

541

For More Un-Answered { DB2 } Questions Click Here