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

DB2 Interview Questions

Questions Answers Views Company eMail

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is catalog database in db2?

1162

What is database reorganization?

1125

What is copy pending and check pending in db2?

1004

Why cursor is used in db2?

1036

What is an instance in db2?

1033

What is the use of with ur in db2?

1056

Can we delete records from view?

967

How do I delete a table in database?

1020

What is difference between rollback and commit?

1157

What is the use of dclgen in db2?

1085

What is iseries database?

1046

What is reorg in database?

1 2049

What is the difference between oracle and db2?

1108

What is the difference between db2 and oracle?

1131

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to restart a DB2 program?

1902

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?

2097

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

1149

How to rename a table in DB2 ?

1088

How does cobol compile db2 program?

1055

What is temporal table in db2?

1039

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

1185

What is netezza database?

1026

What is dbrm?

1105

Which command is used to remove all rows from a table?

1110

What do you mean by cursor?

988

What is scrollable cursor in db2?

1055

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is a collection in db2?

1034

What r the comman abends in db2, jcl and cobol???????

2253

For More Un-Answered { DB2 } Questions Click Here