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.

1133

Comment whether the cursor is closed during commit or not.

1167

Define predicate?

1200

Explain about cursor stability?

1104

List out the buffer pools in db2

1125

What is a storage group (stogroup)?

1284

Explain dclgen.

1267

What is sqlca’s maximum length?

1244

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

1148

Define declaration generator (dclgen).

1170

Define data page.

1123

Mention the different locking levels that are available in db2.

1183

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

1156

Discuss about db2 bind?

1151

List out the data types available.

1199

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1151

What is database alias db2?

1176

Explain packages.

1163

Which isolation level provides maximum concurrency?

1203

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9350

What is a system catalog table in db2?

1240

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

1154

What is an instance in db2?

1083

How does db2 sample database connect?

1078

List out the three types of page locks that can be held.

1191

What is db2 stogroup?

1220

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

1230

Describe major components of db2?

1141

What is query_cache_limit?

1030

Which is faster delete or truncate?

1175

For More Un-Answered { DB2 } Questions Click Here