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?

1097

What are the contents of dclgen?

1107

Why select is not preferred in embedded sql programs?

1299

How do you select a row using indexes in db2?

1133

When reorg is used?

1124

What are the various isolation levels possible?

1116

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

1069

Can you use max on a char column?

1093

List some fields from sqlca?

1056

Explain what are the various isolation levels possible?

1041

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

1084

What is the use of value function?

1147

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?

1081

How would the varchar column remarks defined?

1086

Post New DB2 Questions

Un-Answered Questions { DB2 }

What os does db2 run on?

978

How does coalesce work?

1012

What is performance tuning db2?

1058

What is syscat in db2?

1001

What is dbrm library?

1049

What is the default page size of buffer pools?

1122

Is it possible using max on a char column?

1137

What is copy pending and check pending in db2?

999

How to fetch the last row from the table in SQL (db2)?

1651

What is scrollable cursor in db2?

1055

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.

3202

Where can you declare a cursor in a cobol-db2 program?

1071

what is diffrence b/w file-aid tool and file-aid utility???

4888

What is db2 look?

1020

What is the use of db2?

1051

For More Un-Answered { DB2 } Questions Click Here