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.

1089

Comment whether the cursor is closed during commit or not.

1097

Define predicate?

1129

Explain about cursor stability?

1046

List out the buffer pools in db2

1073

What is a storage group (stogroup)?

1241

Explain dclgen.

1197

What is sqlca’s maximum length?

1178

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).

1112

Define data page.

1060

Mention the different locking levels that are available in db2.

1127

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

1100

Discuss about db2 bind?

1093

List out the data types available.

1151

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is buffer pool and list some of them?

1026

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

Is db2 relational database?

973

How to fetch the last row from the table in SQL (db2)?

1651

How would the varchar column remarks defined?

1086

What is lock escalation in db2?

1029

Why do we bind in db2?

1207

List some fields from sqlca?

1056

Is schema the same as database?

1055

What is runstats utility in db2?

1018

What do you mean by between and in? Is between inclusive of specified range values?

1090

What kind of database is db2?

1032

What types of tables are there in the db2 database?

1055

How do we specify index to include or not during bind process.

2126

What is the physical storage length of timestamp data type?

1091

For More Un-Answered { DB2 } Questions Click Here