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?

1099

What are the contents of a dclmgen?

1075

What is role in db2?

1052

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

1102

What is the physical storage length of timestamp data type?

1033

What is dclgen (declaration generator)?

1016

What is the maximum length of sqlca?

1453

How can you classify the locks in db2?

1041

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

1080

What do you mean by storage group (stogroup)?

993

What is buffer pool?

1037

What is the default page size of buffer pools?

1080

What is the usage of open cursor command?

1045

What is db2? Explain.

993

What is the use of predicate?

994

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1018

Explain in brief how does db2 determine what lock-size to use?

974

What is the use of value function?

1085

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9027

What is page size in db2?

916

What is cascading rollback?

1141

What types of tables are there in the db2 database?

1012

On which levels locks can be applied?

1070

What is explain plan in db2?

947

List out the buffer pools in db2

1027

What is a db2 tablespace?

1009

Explain about rct.

1034

What are bind parameters in db2?

989

Describe major components of db2?

1050

What is role in db2?

1052

For More Un-Answered { DB2 } Questions Click Here