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

DB2 Interview Questions

Questions Answers Views Company eMail

What is the syntax for FETCH in DB2 ?

MCN Solutions,

1264

How many databases can be created inside an instance in db2 ?

MCN Solutions,

1084

What is the connection string to connect to the DB2 Database ?

MCN Solutions,

1171

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

MCN Solutions,

1311

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

MCN Solutions,

1148

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1288

Mention the downsides of page level lock.

1212

What is concurrency?

1299

Explain the function of data manager.

1095

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1241

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1090

Define check constraint.

1127

define clustering index.

1067

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

1192

Explain about rct.

1130

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the clustering index in the db2 database?

1044

What does reorg do in db2?

1074

What is ibm db2 database?

1061

What is a db2 table?

1064

Can you use max on a char column?

1139

What is null indicator in cobol db2?

1106

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

1134

What are bind parameters in db2?

1094

What is the use of runstats in db2?

1178

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

1122

What is rct?

1287

How to create db2 table in mainframe?

1215

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3632

What is db2 plan table?

1108

What is page size in db2?

1023

For More Un-Answered { DB2 } Questions Click Here