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?

1109

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

1169

Explain db2.

1036

How to find the number of rows in db2 tables?

1073

What types of tables are there in the db2 database?

1061

What is the role of union all and union

1129

What is the role of schema in the db2 database?

1275

What are the different types of base tables?

1094

What is dbrm in db2 database?

1117

what is the role of the cursor in db2?

1069

What is a trigger in the db2 database?

1080

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

1084

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

1158

What is the clustering index in the db2 database?

1001

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

1107

Post New DB2 Questions

Un-Answered Questions { DB2 }

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2388

What is an instance in db2?

1033

Can one database have multiple instances?

1054

How to restart a DB2 program?

1902

What is difference between isnull and coalesce?

1056

What is db2 instance?

1096

What is lock escalation in db2?

1033

What is the max length of sqlca?

1216

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

1073

How can you do the explain of a dynamic sql statement?

1069

What is bind package and plan in db2?

1053

What is clone table?

1042

What is syscat in db2?

1010

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

1149

Which is faster delete or truncate?

1127

For More Un-Answered { DB2 } Questions Click Here