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

DB2 Interview Questions

Questions Answers Views Company eMail

Explain the contents that are a part of dclgen.

1091

Comment whether the cursor is closed during commit or not.

1106

Define predicate?

1131

Explain about cursor stability?

1050

List out the buffer pools in db2

1075

What is a storage group (stogroup)?

1246

Explain dclgen.

1205

What is sqlca’s maximum length?

1189

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

Define declaration generator (dclgen).

1114

Define data page.

1069

Mention the different locking levels that are available in db2.

1136

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107

Discuss about db2 bind?

1097

List out the data types available.

1153

Post New DB2 Questions

Un-Answered Questions { DB2 }

How and when does the db2 enforces the unique key?

1083

Which component is used to execute the sql statements?

1096

Who uses db2?

1048

Define check constraint.

1078

What is the use of reorg in db2?

1086

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?

2097

How do you select a row using indexes in db2?

1135

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

1068

What is null in db2?

1026

Give the name of some fields form sqlca.

1079

What is a db2 schema?

1233

What is database reorganization?

1128

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

Mention the definition of cobol in varchar field.

1250

How connect db2 database to datastage?

1243

For More Un-Answered { DB2 } Questions Click Here