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.

1025

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

1127

What are the uses of db2 optimizer?

1294

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

1055

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

1028

What is the information associated with sysibm.syslinks table?

1120

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

1075

What is the purpose of using commit?

1096

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

1146

What is meant by explain?

1126

Define db2.

1108

Highlight all the advantages that are attached to a package.

1113

What is release/acquire in bind?

1102

Mention some fields that are a part of sqlca.

1017

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

1062

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of dclgen in db2?

1083

Why do we bind in db2?

1208

Explain various types of locks in db2?

1140

What is the use of value function?

1147

What is the physical storage length of time data type?

1123

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

1104

When the like statement is used?

1222

What are types of indexes?

1068

What is the cobol picture clause of the db2 data types date, time, timestamp?

1061

What is role in db2?

1101

What does db2 stand for?

1023

What is the use of with ur in db2?

1052

Explain the benefits you can get from mainframe connect?

970

How to find the number of rows in db2 tables?

1065

When reorg is used?

1124

For More Un-Answered { DB2 } Questions Click Here