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

DB2 Interview Questions

Questions Answers Views Company eMail

Explain correlated sub-queries.

1093

Mention the location where the output received from explain statement is stored.

1167

What are the uses of db2 optimizer?

1350

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

Before you give the explain statement, what are the prerogatives?

1079

What is the information associated with sysibm.syslinks table?

1166

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1127

What is the purpose of using commit?

1149

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1219

What is meant by explain?

1193

Define db2.

1167

Highlight all the advantages that are attached to a package.

1169

What is release/acquire in bind?

1158

Mention some fields that are a part of sqlca.

1091

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

1134

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 catalog database?

1088

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1232

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141

What does runstats do in db2?

1181

What is explain in db2?

1078

What does db2 blu stand for?

1214

How to create db2 table in mainframe?

1215

How do I delete a table in database?

1076

List out the data types available.

1200

What are catalog tables in db2?

1104

Which component is responsible for db2 startup and shutdown?

1079

What is role in db2?

1157

What are iseries servers?

1127

What is bind in db2?

1093

What is ibm db2 database?

1061

For More Un-Answered { DB2 } Questions Click Here