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,

1213

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

MCN Solutions,

1035

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

MCN Solutions,

1128

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

MCN Solutions,

1272

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

MCN Solutions,

1104

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

1240

Mention the downsides of page level lock.

1161

What is concurrency?

1233

Explain the function of data manager.

1044

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

1196

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

1044

Define check constraint.

1078

define clustering index.

1028

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

1149

Explain about rct.

1087

Post New DB2 Questions

Un-Answered Questions { DB2 }

What language is db2 written in?

1049

How is the value function used?

1154

How does a cursor work?

988

Define db2 and its databases?

1055

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

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

3581

What does sqlcabc has?

1054

What is explain in db2?

1022

What is db2 and what is the use of db2 optimizer?

1067

What are types of indexes?

1073

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

1127

Explain how can you do the explain of a dynamic sql statement?

1125

What is sqlca’s maximum length?

1189

What is cursor stability in db2?

1356

What is a bind in db2?

1042

For More Un-Answered { DB2 } Questions Click Here