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?

1228

What is check constraint in db2?

1078

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

1086

Which components manage deadlocks in db2?

1064

What is the physical storage length of time data type?

1123

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

1038

What is the picture clause of null indicator variable?

1136

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

1070

What is concurrency in db2?

1 2194

Which component is responsible for db2 startup and shutdown?

1033

What is data manager?

1046

What is the physical storage length of date data type?

1252

Which isolation level provides highest data integrity?

1114

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

1108

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

1131

Post New DB2 Questions

Un-Answered Questions { DB2 }

Describe major components of db2?

1089

What is the usage of open cursor command?

1100

What does sqlcabc has?

1046

Define db2 and its databases?

1054

Explain various types of locks in db2?

1140

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1183

What is the physical storage length of the data types date, time, and timestamp?

1084

What is db2 command?

1031

What is temporal table in db2?

1035

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2241

What is null indicator in db2?

1107

What is sqlca’s maximum length?

1178

Explain correlated sub-queries.

1025

What is cascading rollback?

1209

What is with ur in db2?

1302

For More Un-Answered { DB2 } Questions Click Here