DB2 Interview Questions
Questions Answers Views Company eMail

Which isolation level provides maximum concurrency?

809

What are the contents of a dclmgen?

747

What is role in db2?

730

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

776

What is the physical storage length of timestamp data type?

778

What is dclgen (declaration generator)?

726

What is the maximum length of sqlca?

1014

How can you classify the locks in db2?

752

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

803

What do you mean by storage group (stogroup)?

701

What is buffer pool?

767

What is the default page size of buffer pools?

778

What is the usage of open cursor command?

714

What is db2? Explain.

716

What is the use of predicate?

709


Post New DB2 Questions

Un-Answered Questions { DB2 }

How is deadlock resolved?

770


Which command is used to connect to a database in DB2 ? Give the Syntax.

717


What is universal database?

759


What is plan in cobol db2?

717


can we view the access paths created by dbrm ? how ? thx

6504






Which are the db2 tools to protect integrity of the database?

813


What is the difference between db2 and oracle?

791


How to fetch the last row from the table in SQL (db2)?

1198


Which isolation level provides maximum concurrency?

809


Are views updateable?

775


What is commit in db2?

726


What is temporal table in db2?

727


What is dbrm? When it will be created?

713


i want to maintain uniqueness on pdf without make lf??????????

1777


What language is db2 written in?

703