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

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

1230

What is check constraint in db2?

1085

How can you count the number of rows from a table tab?

1089

Which components manage deadlocks in db2?

1070

What is the physical storage length of time data type?

1124

How many types of page locks can be held in db2?

1040

What is the picture clause of null indicator variable?

1138

Where can you declare a cursor in a cobol-db2 program?

1076

What is concurrency in db2?

1 2201

Which component is responsible for db2 startup and shutdown?

1033

What is data manager?

1049

What is the physical storage length of date data type?

1252

Which isolation level provides highest data integrity?

1116

What is the reason behind not using select * in embedded sql programs?

1113

What is the maximum size of varchar data type in db2?

1133

Post New DB2 Questions

Un-Answered Questions { DB2 }

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065

Can there be more than one cursor open for any program?

1169

What is package in cobol db2?

1118

What is bufferpool in db2?

1052

What is a db2 cursor?

1055

Why do we use cursor?

1099

What is a Foreign Key?

1095

Can we update view in db2?

1000

What is the maximum No of rows per page?

1067

What is ibm db2 connect?

995

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

How connect db2 database to datastage?

1237

What is db2? Explain.

1043

Can one database have multiple instances?

1054

How can we read records for specific member in CL? AND rpg?

699

For More Un-Answered { DB2 } Questions Click Here