DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is the maximum size of a char data type in db2?

1012

What is cursor stability in db2?

1358

What are the various data types available in db2?

1094

Which component is used to execute the sql statements?

1096

What are the rules for db2 programming?

1090

Define db2 and its databases?

1057

How can you quickly find out the # of rows updated after an update statement?

1049

Can there be more than one cursor open for any program?

1169

What are the 2 sqlcodes that are returned?

1189

Where do you specify them?

1282

When the like statement is used?

1222

How to retrieve rows from a db2 table in embedded sql?

1393

Are views updateable?

1163

What is reorg?

1162

How can you find out the # of rows updated after an update statement?

1116

Post New DB2 Questions

Un-Answered Questions { DB2 }

What does db2 blu stand for?

1167

What are the different types of base tables?

1096

What are the prerogatives?

1080

What is the physical storage length of date data type?

1254

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What is null indicator in db2?

1113

Is db2 a programming language?

1050

What is the physical storage length of the data types date, time, and timestamp?

1090

What is bufferpool in db2?

1054

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1073

How to check table size in db2 sap?

1040

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

1108

Can we delete records from view?

967

What is copy pending and check pending in db2?

1004

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2099

For More Un-Answered { DB2 } Questions Click Here