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?

1144

What are the contents of dclgen?

1159

Why select is not preferred in embedded sql programs?

1345

How do you select a row using indexes in db2?

1172

When reorg is used?

1178

What are the various isolation levels possible?

1177

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

1106

Can you use max on a char column?

1139

List some fields from sqlca?

1103

Explain what are the various isolation levels possible?

1093

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

1136

What is the use of value function?

1203

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

1184

What is the result of open cursor statement?

1125

How would the varchar column remarks defined?

1127

Post New DB2 Questions

Un-Answered Questions { DB2 }

Can we delete records from view?

1018

How to retrieve rows from a db2 table in embedded sql?

1438

Define sqlca.

1164

What is release/acquire in bind?

1157

What is db2 bind?

1127

What is bind package and plan in db2?

1101

What is declare cursor?

1166

Define db2 and its databases?

1109

What is the meaning concurrency in the db2 database?

1160

What is node in db2?

1097

What is the max length of sqlca?

1266

Why do chiropractors use drop table?

1160

What are union and union all?

1030

Which are the db2 tools to protect integrity of the database?

1164

How to check last update on table in db2?

1097

For More Un-Answered { DB2 } Questions Click Here