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 12372

what are the bind parameters?

IBM,

5 39635

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 9077

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

IBM,

10 14651

what is dynamic cursor?gives syntax for this?

TCS,

1 5268

wht is d/f between union and joins ?

2 6260

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

2 6442

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

Infosys,

3 9132

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

3094

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 8727

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

IBM,

2 6866

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

IBM,

1 4438

select 100 records from million records ?

Verizon,

2 7850

cursor with hold explain ?

Verizon,

1 6277

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

TCS,

1 5839

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is dbrm? When it will be created?

963

What is database manager in db2?

968

What are the rules for db2 programming?

1043

What is the maximum No of rows per page?

1014

What is meant by dclgen?

1066

What is the use of commit in db2?

1006

How to execute stored procedure in db2 command editor?

988

What is the max length of sqlca?

1161

Is db2 a mainframe database?

946

How to restart a DB2 program?

1830

What is null in db2?

950

Is ibm db2 open source?

1020

List down the data types in the db2 database.

1045

What is the syntax for seeing the columns and data types of a table in the db2 database?

1089

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2477

For More Un-Answered { DB2 } Questions Click Here