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

DB2 Interview Questions

Questions Answers Views Company eMail

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

1154

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

1230

Explain db2.

1083

How to find the number of rows in db2 tables?

1125

What types of tables are there in the db2 database?

1101

What is the role of union all and union

1185

What is the role of schema in the db2 database?

1357

What are the different types of base tables?

1157

What is dbrm in db2 database?

1187

what is the role of the cursor in db2?

1109

What is a trigger in the db2 database?

1137

How to find the maximum value in a column in the db2 database?

1125

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1211

What is the clustering index in the db2 database?

1044

What is the syntax for creating a table in the db2 database?

1144

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are iseries servers?

1126

Explain various types of locks in db2?

1204

Is it possible using max on a char column?

1189

What is db2 plan table?

1106

What is table space in db2?

1069

What os does db2 run on?

1043

List down the types of triggers in the db2 database?

1078

What do you mean by commit and rollback?

1085

What is null value in db2?

1074

How to take backup of table in db2?

1121

What is db2 instance?

1163

What is cascading rollback?

1273

What is the maximum No of rows per page?

1108

what is a corelated subquerry?

1166

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2766

For More Un-Answered { DB2 } Questions Click Here