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?

1230

What is catalog database in db2?

1102

What is database reorganization?

1056

What is copy pending and check pending in db2?

954

Why cursor is used in db2?

986

What is an instance in db2?

987

What is the use of with ur in db2?

1004

Can we delete records from view?

917

How do I delete a table in database?

977

What is difference between rollback and commit?

1095

What is the use of dclgen in db2?

1015

What is iseries database?

992

What is reorg in database?

1 1954

What is the difference between oracle and db2?

1033

What is the difference between db2 and oracle?

1070

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is dbrm? When it will be created?

958

How to restart a DB2 program?

1829

What are the full forms of spufi and dclgen and why are they used?

1025

What do you mean by storage group (stogroup)?

984

How does db2 sample database connect?

975

What is the maximum size of varchar data type in db2?

1069

Give the name of some fields form sqlca.

1024

How to find schema of a table in db2?

953

Can you tell me how can you find out the # of rows updated after an update statement?

1047

Is db2 a database?

914

How to find primary key of a table in db2?

1004

Define predicate?

1069

What does reorg do in db2?

985

What do you mean by between and in? Is between inclusive of specified range values?

1041

What is the advantage in De-normalizing tables in DB2?

1117

For More Un-Answered { DB2 } Questions Click Here