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?

1124

What is role in db2?

1105

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

1154

What is the physical storage length of timestamp data type?

1095

What is dclgen (declaration generator)?

1057

What is the maximum length of sqlca?

1527

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)?

1040

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?

1041

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1073

What is syscat in db2?

1009

Can we update view in db2?

1000

What is bufferpool in db2?

1052

What is database alias db2?

1125

How can we retrieve the total number of records in RPG & CLLE?

653

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

What is precompiler in db2?

1015

Mention the various locks that are available in db2.

1039

What is the difference between bind and rebind in db2?

1449

What is collection in db2 bind?

1014

What is the result of open cursor statement?

1083

If I have a view which is a join of two or more tables, can this view be updateable?

1139

Define predicate?

1131

How would you find out the total number of rows in a db2 table?

1050

For More Un-Answered { DB2 } Questions Click Here