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.

1033

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

1127

What are the uses of db2 optimizer?

1296

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

1061

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

1040

What is the information associated with sysibm.syslinks table?

1125

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

1077

What is the purpose of using commit?

1099

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

1148

What is meant by explain?

1133

Define db2.

1116

Highlight all the advantages that are attached to a package.

1119

What is release/acquire in bind?

1106

Mention some fields that are a part of sqlca.

1033

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

1071

Post New DB2 Questions

Un-Answered Questions { DB2 }

What does db2 stand for?

1025

What is a db2 table?

1017

How to execute stored procedure in db2 command editor?

1049

What is the physical storage length of date data type?

1254

What is the role of schema in the db2 database?

1275

Is ibm db2 open source?

1075

How to check last update on table in db2?

1059

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is a plan and package in db2?

1104

How does coalesce work?

1023

Define declaration generator (dclgen).

1114

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2941

Is db2 free?

1094

What is the difference between nvl and coalesce?

1065

What does db2 blu stand for?

1165

For More Un-Answered { DB2 } Questions Click Here