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?

1152

What are the contents of a dclmgen?

1128

What is role in db2?

1109

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

1156

What is the physical storage length of timestamp data type?

1095

What is dclgen (declaration generator)?

1059

What is the maximum length of sqlca?

1529

How can you classify the locks in db2?

1089

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

1127

What do you mean by storage group (stogroup)?

1041

What is buffer pool?

1106

What is the default page size of buffer pools?

1122

What is the usage of open cursor command?

1100

What is db2? Explain.

1043

What is the use of predicate?

1043

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is package in db2 mainframe?

987

What is page size in db2?

975

Explain correlated sub-queries.

1033

What are the prerogatives?

1080

What is the difference between dbm cfg and db cfg file in db2 ?

1536

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

1061

How to retrieve rows from a db2 table in embedded sql?

1391

Explain packages.

1113

Define db2 and its databases?

1055

What is db2 catalog database?

1043

Where can you declare a cursor in a cobol-db2 program?

1077

Mention the downsides of page level lock.

1161

How is deadlock resolved?

1146

What is the difference between bind and rebind in db2?

1453

What are bind parameters in db2?

1046

For More Un-Answered { DB2 } Questions Click Here