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

DB2 Interview Questions

Questions Answers Views Company eMail

What are the benefits of using the db2 database?

1156

What is buffer pool in the db2 database?

1047

What is the meaning concurrency in the db2 database?

1061

What are the two types of logging in the db2 database? Explain them.

1019

List down the data types in the db2 database.

1043

List down the types of triggers in the db2 database?

965

How can the duplicate values be eliminated from db2 select?

1044

What is the function of logging in the db2 database?

1071

What is the role of the data page in the db2 database?

975

Give the name of some fields form sqlca.

1024

On which levels locks can be applied?

1062

What is dbrm?

1048

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

1012

What is the use of commit in db2?

1006

What is db2 bind?

1019

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is ibm db2 used for?

1004

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

1006

What is the difference between drop table and delete table?

1121

What is runstats and reorg in db2?

1241

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1230

Where do you specify them?

1167

How to restart a DB2 program?

1829

What is iseries database?

991

What is role in db2?

1042

What is the physical storage length of the data types date, time, and timestamp?

1042

What is sqlca’s maximum length?

1104

Define data page.

1015

What is plan in cobol db2?

1061

Is ibm db2 open source?

1016

What is multi row fetch in db2?

988

For More Un-Answered { DB2 } Questions Click Here