DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What are foreign keys in db2?

1034

Describe major components of db2?

1040

Explain about rct in db2?

1044

What is db2?

1124

Explain various types of locks in db2?

1081

What is the use of db2 optimizer?

1037

What are the full forms of spufi and dclgen and why are they used?

1023

Give a brief description of db2 isolation levels?

1013

What is db2 and what is the use of db2 optimizer?

994

Mention data types used in db2 ?

1106

Explain the contention situations caused by locks?

1013

What is buffer pool and list some of them?

981

Mention and explain the contention situations caused by locks?

1 1420

What is meant by union and union all?

948

Explain package in db2 and its advantages?

1134

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the role of data manager in the db2 database?

1051

Name the various locking levels available?

1035

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1018

What is catalog database in db2?

1100

What is blu acceleration in db2?

1014

How to access db2 tables in mainframe?

991

How to take backup of table in db2?

1021

How to check sequence on a table in db2?

994

How do I start db2 in windows?

1021

What is dbrm? What it contains? When it will be created?

992

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

1071

Mention the different locking levels that are available in db2.

1070

What db2 400?

1103

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

1082

What are concurrency issues?

1029

For More Un-Answered { DB2 } Questions Click Here