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?

1235

What is check constraint in db2?

1090

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

1091

Which components manage deadlocks in db2?

1071

What is the physical storage length of time data type?

1129

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

1043

What is the picture clause of null indicator variable?

1138

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

1077

What is concurrency in db2?

1 2201

Which component is responsible for db2 startup and shutdown?

1035

What is data manager?

1049

What is the physical storage length of date data type?

1254

Which isolation level provides highest data integrity?

1118

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

1115

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

1135

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

Mention data types used in db2 ?

1159

what is utility for parm lib

2377

Define sqlca.

1113

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What do you mean by commit and rollback?

1043

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

1169

What is the max length of sqlca?

1216

What is the physical storage length of date data type?

1254

What is dbrm in db2 database?

1117

How can we retrieve the total number of records in RPG & CLLE?

656

Why do chiropractors use drop table?

1109

What is release/acquire in bind?

1106

What is host variable?

1057

What is rebind in db2?

1066

For More Un-Answered { DB2 } Questions Click Here