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?

1284

What is check constraint in db2?

1163

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

1134

Which components manage deadlocks in db2?

1117

What is the physical storage length of time data type?

1175

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

1084

What is the picture clause of null indicator variable?

1178

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

1137

What is concurrency in db2?

1 2278

Which component is responsible for db2 startup and shutdown?

1077

What is data manager?

1099

What is the physical storage length of date data type?

1304

Which isolation level provides highest data integrity?

1180

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

1160

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

1174

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which component is responsible for processing sql statements and selecting access paths?

1173

How is the value function used?

1202

What is drop table?

1060

B37 abend during spufi?

1503

What is nvl in db2?

1145

What is blu acceleration in db2?

1123

How does a cursor work?

1034

What is sqlca?

1128

what is the role of the cursor in db2?

1109

What is reorg and runstats in db2?

1259

Define predicate?

1199

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

1589

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

1184

What is db2? Explain.

1106

what is utility for parm lib

2417

For More Un-Answered { DB2 } Questions Click Here