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.

1038

Comment whether the cursor is closed during commit or not.

1043

Define predicate?

1071

Explain about cursor stability?

986

List out the buffer pools in db2

1024

What is a storage group (stogroup)?

1195

Explain dclgen.

1146

What is sqlca’s maximum length?

1104

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

1052

Define declaration generator (dclgen).

1068

Define data page.

1016

Mention the different locking levels that are available in db2.

1075

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

1058

Discuss about db2 bind?

1054

List out the data types available.

1085

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the physical storage length of time data type?

1070

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

1048

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

1046

What is the use of db2 optimizer?

1050

What happens in bind step in a db2 program?

918

How to test SQL -911 error while developing COB-DB2 program

7451

How do you concatenate the firstname and lastname from emp table to give a complete name?

1017

How can you classify the locks in db2?

1035

What language is db2 written in?

984

What is the difference between oracle and db2?

1035

What is a trigger in the db2 database?

1021

Is it possible using max on a char column?

1088

When reorg is used?

1076

Explain packages.

1058

What does db2 plan contain?

968

For More Un-Answered { DB2 } Questions Click Here