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?

1101

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?

1127

What are the various isolation levels possible?

1122

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?

1058

Explain what are the various isolation levels possible?

1044

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

1087

What is the use of value function?

1150

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?

1088

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of runstats in db2?

1109

what is a corelated subquerry?

1122

What does a deadlock mean in DB2?

1167

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

1185

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3208

Is it possible using max on a char column?

1139

How many types of page locks can be held in db2?

1040

What is bind and rebind in db2?

1137

What is the clustering index in the db2 database?

1001

What is the syntax for seeing the columns and data types of a table in the db2 database?

1166

What is the role of union all and union

1127

Which component is responsible for db2 startup and shutdown?

1035

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

1069

What is cursor in dbms?

1066

Can one database have multiple instances?

1054

For More Un-Answered { DB2 } Questions Click Here