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

DB2 Interview Questions

Questions Answers Views Company eMail

What are the benefits of using the db2 database?

1224

What is buffer pool in the db2 database?

1091

What is the meaning concurrency in the db2 database?

1108

What are the two types of logging in the db2 database? Explain them.

1071

List down the data types in the db2 database.

1115

List down the types of triggers in the db2 database?

1022

How can the duplicate values be eliminated from db2 select?

1101

What is the function of logging in the db2 database?

1120

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

1024

Give the name of some fields form sqlca.

1073

On which levels locks can be applied?

1123

What is dbrm?

1104

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

1057

What is the use of commit in db2?

1073

What is db2 bind?

1077

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the location where the output received from explain statement is stored.

1125

What is null value in db2?

1019

What is copy pending and check pending in db2?

997

What is schema in db2?

1018

What is the use of reorg in db2?

1080

How do we specify index to include or not during bind process.

2126

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

1085

Which command is used to remove all rows from a table?

1106

What is explain plan in db2?

983

What are concurrency issues?

1094

What is rct?

1228

Where do you specify them?

1271

Is db2 a mainframe database?

996

Define buffer pool.

1049

How do you concatenate the firstname and lastname from emp table to give a complete name?

1073

For More Un-Answered { DB2 } Questions Click Here