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

DB2 Interview Questions

Questions Answers Views Company eMail

Which isolation level provides maximum concurrency?

1150

What are the contents of a dclmgen?

1122

What is role in db2?

1101

What action db2 takes when a program aborts in the middle of a transaction?

1148

What is the physical storage length of timestamp data type?

1089

What is dclgen (declaration generator)?

1052

What is the maximum length of sqlca?

1521

How can you classify the locks in db2?

1088

Which component is responsible for processing sql statements and selecting access paths?

1126

What do you mean by storage group (stogroup)?

1039

What is buffer pool?

1093

What is the default page size of buffer pools?

1121

What is the usage of open cursor command?

1100

What is db2? Explain.

1039

What is the use of predicate?

1039

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is difference between isnull and coalesce?

1052

Which isolation level provides maximum concurrency?

1150

Can you use max on a char column?

1092

What are the bind parameters ibm db2?

1046

What is a collection in db2?

1029

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

1058

What is db2 purescale?

993

What do you mean by commit and rollback?

1033

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

1055

What is check constraint in db2?

1078

Are view updateable?

1040

What are the uses of db2 optimizer?

1293

What is db2 plan table?

1044

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2060

How to access db2 tables in mainframe?

1051

For More Un-Answered { DB2 } Questions Click Here