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?

963

What is cursor stability in db2?

1276

What are the various data types available in db2?

1011

Which component is used to execute the sql statements?

1052

What are the rules for db2 programming?

1040

Define db2 and its databases?

1002

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

984

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

1123

What are the 2 sqlcodes that are returned?

1128

Where do you specify them?

1165

When the like statement is used?

1156

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

1325

Are views updateable?

1070

What is reorg?

1071

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

1050

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is dpf in db2?

1047

On which levels locks can be applied?

1060

What is a db2 collection?

981

Can you use max on a char column?

1027

What is blu acceleration in db2?

1014

What is image copy in db2?

943

How many databases can be created inside an instance in db2 ?

977

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1003

Is it possible using max on a char column?

1083

Why do we use cursor?

1048

What does sqlcabc has?

993

What is the maximum length of sqlca?

1432

What is a Foreign Key?

1036

What types of tables are there in the db2 database?

1004

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1054

For More Un-Answered { DB2 } Questions Click Here