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

DB2 Interview Questions

Questions Answers Views Company eMail

When Can you be sure that a query will return only one row?

IBM,

4 8455

What is the SQL Communications Area and what are some of its key fields?

1 5397

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 9451

How many buffer pools are available in db2?

2 7066

What is the size of a data page?

IBM,

2 5744

What is the difference between CS and RR isolation levels?

1 8449

Name the different types of Table spaces.

IBM,

5 15192

How do you retrieve the data from a nullable column?

2 8669

What is a clustering index ?

3 7335

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 6924

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 8957

What else is there in the PLAN apart from the access path?

1 5141

What is a host variable?

3 6733

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 10217

Once you create a view, where would information about the view be stored?

1 4986

Post New DB2 Questions

Un-Answered Questions { DB2 }

What os does db2 run on?

924

What is coalesce in db2?

1055

How would you find out the total number of rows in a db2 table?

988

How to resolve deadlock issue

19864

Where do you specify them?

1165

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

1085

How do you eliminate duplicate values in db2?

1107

Which isolation level provides highest data integrity?

1039

what is the responsibility of the construction superintendent

2079

What kind of database is db2?

975

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

1114

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1025

How can the duplicate values be eliminated from db2 select?

1039

What is the role of the data page in the db2 database?

972

What is db2 stogroup?

1095

For More Un-Answered { DB2 } Questions Click Here