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 8662

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

1 5507

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

2 9608

How many buffer pools are available in db2?

2 7214

What is the size of a data page?

IBM,

2 5868

What is the difference between CS and RR isolation levels?

1 8557

Name the different types of Table spaces.

IBM,

5 15429

How do you retrieve the data from a nullable column?

2 8828

What is a clustering index ?

3 7531

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

1 7060

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 9100

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

1 5261

What is a host variable?

3 6887

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 10312

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

1 5071

Post New DB2 Questions

Un-Answered Questions { DB2 }

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8292

What os does db2 run on?

986

what is the role of the cursor in db2?

1069

How to find the maximum value in a column in the db2 database?

1084

What is buffer pool in the db2 database?

1107

How do you find the maximum value in a column in db2?

1106

What is load utility in db2?

1181

What is access path in db2?

986

What is database alias db2?

1127

What is declare cursor?

1123

What are the various isolation levels possible?

1122

What are the full forms of spufi and dclgen and why are they used?

1089

Define check constraint.

1078

Why do we need reorg in db2?

988

What is the clustering index in the db2 database?

1001

For More Un-Answered { DB2 } Questions Click Here