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?

1013

What is cursor stability in db2?

1363

What are the various data types available in db2?

1100

Which component is used to execute the sql statements?

1104

What are the rules for db2 programming?

1100

Define db2 and its databases?

1059

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

1052

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

1173

What are the 2 sqlcodes that are returned?

1196

Where do you specify them?

1289

When the like statement is used?

1228

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

1398

Are views updateable?

1167

What is reorg?

1165

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

1116

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between cursor stability and repeatable read isolation levels?

1183

Before you give the explain statement, what are the prerogatives?

1045

What is db2 instance?

1110

Explain the contents that are a part of dclgen.

1094

What is runstats utility in db2?

1028

What is a cursor in programming?

1077

What is the function of logging in the db2 database?

1124

What is null in db2?

1031

What is a db2 package?

1069

What is the maximum size of varchar data type in db2?

1137

Is ibm db2 open source?

1080

What is copy pending status in db2?

1128

What is cursor stability in db2?

1363

What is the picture clause of null indicator variable?

1139

How do we specify index to include or not during bind process.

2132

For More Un-Answered { DB2 } Questions Click Here