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 8674

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

1 5512

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

2 9615

How many buffer pools are available in db2?

2 7222

What is the size of a data page?

IBM,

2 5876

What is the difference between CS and RR isolation levels?

1 8562

Name the different types of Table spaces.

IBM,

5 15447

How do you retrieve the data from a nullable column?

2 8841

What is a clustering index ?

3 7541

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

1 7065

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 9114

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

1 5266

What is a host variable?

3 6900

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 10318

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

1 5074

Post New DB2 Questions

Un-Answered Questions { DB2 }

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1053

what is utility for parm lib

2384

What is db2?

1186

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

1397

Name the various locking levels available?

1101

What is release/acquire in bind?

1111

What is a db2 schema?

1241

What is the syntax for creating a table in the db2 database?

1109

List out the data types available.

1158

What is bind in db2?

1055

What is dpf in db2?

1115

Why cursor is used in db2?

1040

How to find the number of rows in db2 tables?

1073

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

What are the contents of a dclmgen?

1135

For More Un-Answered { DB2 } Questions Click Here