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?

1089

What are the contents of a dclmgen?

1066

What is role in db2?

1040

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

1088

What is the physical storage length of timestamp data type?

1024

What is dclgen (declaration generator)?

1009

What is the maximum length of sqlca?

1432

How can you classify the locks in db2?

1032

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

1070

What do you mean by storage group (stogroup)?

984

What is buffer pool?

1028

What is the default page size of buffer pools?

1069

What is the usage of open cursor command?

1034

What is db2? Explain.

987

What is the use of predicate?

983

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of db2?

1005

Who uses db2?

981

How does coalesce work?

958

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

994

Comment whether the cursor is closed during commit or not.

1040

How do I copy a table in db2?

950

How can record locking be achieved in those DB2 versions which do not support it?

1019

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

1005

What is null indicator in db2?

1051

List out the data types available.

1080

What language is db2 written in?

980

Explain the function done by data manager?

1216

What is the maximum No of rows per page?

1011

What is the meaning concurrency in the db2 database?

1056

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

For More Un-Answered { DB2 } Questions Click Here