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 12482

what are the bind parameters?

IBM,

5 39943

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 9304

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

IBM,

10 15033

what is dynamic cursor?gives syntax for this?

TCS,

1 5395

wht is d/f between union and joins ?

2 6402

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

2 6570

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

Infosys,

3 9309

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

3154

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 8850

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

IBM,

2 7031

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

IBM,

1 4532

select 100 records from million records ?

Verizon,

2 7986

cursor with hold explain ?

Verizon,

1 6362

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

TCS,

1 5947

Post New DB2 Questions

Un-Answered Questions { DB2 }

How will you return the number of records in table?

937

What is access path in db2?

986

How do you stop a db2 database in linux?

1012

How do you find the maximum value in a column in db2?

1104

What is a db2 cursor?

1055

What is blu acceleration in db2?

1069

Why do we need reorg in db2?

986

What is db2 plan table?

1049

What are the two types of logging in the db2 database? Explain them.

1073

What is cursor in dbms?

1066

What is dbrm? When it will be created?

1029

What are foreign keys in db2?

1104

Which component is responsible for processing sql statements and selecting access paths?

1127

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9200

What is package in db2 mainframe?

987

For More Un-Answered { DB2 } Questions Click Here