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

DB2 Interview Questions

Questions Answers Views Company eMail

What is the maximum size of a char data type in db2?

1010

What is cursor stability in db2?

1356

What are the various data types available in db2?

1093

Which component is used to execute the sql statements?

1096

What are the rules for db2 programming?

1087

Define db2 and its databases?

1055

How can you quickly find out the # of rows updated after an update statement?

1041

Can there be more than one cursor open for any program?

1169

What are the 2 sqlcodes that are returned?

1187

Where do you specify them?

1278

When the like statement is used?

1222

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

1388

Are views updateable?

1153

What is reorg?

1157

How can you find out the # of rows updated after an update statement?

1114

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the maximum size of a char data type in db2?

1010

What is runstats db2?

1035

What is coalesce in db2?

1134

What is the cobol picture clause of the db2 data types date, time, timestamp?

1066

What is database manager in db2?

1020

What is a collection in db2?

1034

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

What are the various isolation levels possible?

1121

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

1069

What is syscat in db2?

1008

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

1388

What is db2?

1182

What are concurrency issues?

1097

How to view db2 table structure?

1016

What is a dbrm in db2?

1020

For More Un-Answered { DB2 } Questions Click Here