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?

1229

What is buffer pool in the db2 database?

1102

What is the meaning concurrency in the db2 database?

1110

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

1073

List down the data types in the db2 database.

1123

List down the types of triggers in the db2 database?

1027

How can the duplicate values be eliminated from db2 select?

1106

What is the function of logging in the db2 database?

1121

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

1028

Give the name of some fields form sqlca.

1077

On which levels locks can be applied?

1130

What is dbrm?

1105

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

1066

What is the use of commit in db2?

1081

What is db2 bind?

1082

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which isolation level provides highest data integrity?

1117

What is dbrm? What it contains?

1163

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

How to execute stored procedures?

1130

What is a db2 package?

1056

Explain about rct.

1087

What is dpf in db2?

1109

what is utility for parm lib

2375

How do I delete a column in db2?

1109

How do I add a column in db2?

1048

What is load utility in db2?

1181

What is the difference between dbm cfg and db cfg file in db2 ?

1534

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1065

Which is faster delete or truncate?

1127

How to run db2 command in windows?

1193

For More Un-Answered { DB2 } Questions Click Here