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?

1126

What is role in db2?

1107

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

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?

1042

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is copy pending and check pending in db2?

1004

What is db2 purescale?

997

What is ibm db2 client?

939

What is cobol db2?

1000

Is db2 a mainframe database?

1000

Outputs of explain are with matchcols = 0. What does this signify?

1057

What is null indicator in db2?

1110

When reorg is used?

1127

Is db2 a programming language?

1048

What is bufferpool in db2?

1052

What is bind package and plan in db2?

1053

what is the role of the cursor in db2?

1067

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

1154

Explain the function of data manager.

1044

What is dbrm? What it contains?

1163

For More Un-Answered { DB2 } Questions Click Here