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

DB2 Interview Questions

Questions Answers Views Company eMail

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

1100

What are the contents of dclgen?

1112

Why select is not preferred in embedded sql programs?

1299

How do you select a row using indexes in db2?

1135

When reorg is used?

1126

What are the various isolation levels possible?

1121

How can you do the explain of a dynamic sql statement?

1069

Can you use max on a char column?

1097

List some fields from sqlca?

1057

Explain what are the various isolation levels possible?

1044

What is the physical storage length of the data types date, time, and timestamp?

1086

What is the use of value function?

1149

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is the result of open cursor statement?

1083

How would the varchar column remarks defined?

1086

Post New DB2 Questions

Un-Answered Questions { DB2 }

is it compulsory commitment control in journal?

2478

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is consistency token in db2?

1141

Can we insert update delete in view?

972

How can you do the explain of a dynamic sql statement?

1069

What is a page in db2?

1026

What is a db2 table?

1013

Is db2 a database?

967

What is cobol db2?

999

Highlight all the advantages that are attached to a package.

1116

What is null indicator in cobol db2?

1065

What is a db2 package?

1053

What is cloudant database?

1096

List some fields from sqlca?

1057

What is the maximum No of rows per page?

1067

For More Un-Answered { DB2 } Questions Click Here