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?

1274

What is catalog database in db2?

1160

What is database reorganization?

1125

What is copy pending and check pending in db2?

999

Why cursor is used in db2?

1036

What is an instance in db2?

1033

What is the use of with ur in db2?

1052

Can we delete records from view?

966

How do I delete a table in database?

1016

What is difference between rollback and commit?

1157

What is the use of dclgen in db2?

1083

What is iseries database?

1046

What is reorg in database?

1 2040

What is the difference between oracle and db2?

1100

What is the difference between db2 and oracle?

1127

Post New DB2 Questions

Un-Answered Questions { DB2 }

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1434

What are the 2 sqlcodes that are returned?

1185

What is a dbrm in db2?

1020

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

1102

What are foreign keys in db2?

1101

Explain the contents that are a part of dclgen.

1089

How do you stop a db2 database in linux?

1010

What is database reorganization?

1125

What is the difference between using bind () and rebind () methods of naming class?

1394

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

1086

Which is faster delete or truncate?

1123

How do I import data from excel to db2?

1066

How to restart a DB2 program?

1895

Discuss about db2 bind?

1093

How does db2 sample database connect?

1024

For More Un-Answered { DB2 } Questions Click Here