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

DB2 Interview Questions

Questions Answers Views Company eMail

How to compare data between two tables in db2?

1047

What is lock escalation in db2?

979

What is the difference between cursor and select statement?

1070

What is difference between alias and synonym in db2?

1088

What is host variable in db2 cobol?

1043

How do I import a csv file into db2?

948

What is image copy in db2?

962

How do I copy a table in db2?

962

What is explain in db2?

976

What is the purpose of rollback and commit?

1115

How do I change the column size in db2?

1107

What is index in db2?

1 1637

How do I delete a column in db2?

1068

What is null in db2?

966

How do I delete a table in db2?

1026

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is release/acquire in bind?

1072

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2037

What is the syntax for creating a table in the db2 database?

1073

What is the physical storage length of date data type?

1199

What action db2 takes when a program aborts in the middle of a transaction?

1113

What is the use of db2 optimizer?

1067

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

1003

How is deadlock resolved?

1094

What is db2? Explain.

998

What is the use of dclgen in db2?

1026

What is bind plan?

999

Explain the benefits you can get from mainframe connect?

924

What is collection in db2 bind?

976

B37 abend during spufi?

1418

define clustering index.

988

For More Un-Answered { DB2 } Questions Click Here