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?

1103

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?

1131

What is dbrm?

1105

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

1067

What is the use of commit in db2?

1081

What is db2 bind?

1082

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1139

Are view updateable?

1043

What is a system catalog table in db2?

1186

List out the three types of page locks that can be held.

1149

What is the difference between cursor and select statement?

1101

What is db2 look?

1023

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

What is the syntax for FETCH in DB2 ?

1212

Explain about dbrm.

1047

How to restart a DB2 program?

1902

What is with ur in db2?

1316

What is difference between alias and synonym in db2?

1141

How do you select a row using indexes in db2?

1135

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

1076

What is the syntax for seeing the columns and data types of a table in the db2 database?

1166

For More Un-Answered { DB2 } Questions Click Here