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?

1048

What is cursor stability in db2?

1412

What are the various data types available in db2?

1142

Which component is used to execute the sql statements?

1141

What are the rules for db2 programming?

1152

Define db2 and its databases?

1109

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

1081

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

1223

What are the 2 sqlcodes that are returned?

1230

Where do you specify them?

1362

When the like statement is used?

1278

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

1438

Are views updateable?

1231

What is reorg?

1238

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

1154

Post New DB2 Questions

Un-Answered Questions { DB2 }

Highlight all the advantages that are attached to a package.

1169

What is the use of reorg in db2?

1137

What is the role of the data page in the db2 database?

1082

What is db2 optimizer?

1302

What is a db2 tablespace?

1116

What is bind package and plan in db2?

1101

What is the use of db2?

1111

What is table space in db2?

1069

What is db2 connect?

1122

What is the result of open cursor statement?

1125

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

1129

What is netezza database?

1078

Which component is responsible for db2 startup and shutdown?

1078

What is the physical storage length of time data type?

1175

Is ibm db2 free?

1062

For More Un-Answered { DB2 } Questions Click Here