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 8646

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

1 5501

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

2 9594

How many buffer pools are available in db2?

2 7213

What is the size of a data page?

IBM,

2 5854

What is the difference between CS and RR isolation levels?

1 8554

Name the different types of Table spaces.

IBM,

5 15410

How do you retrieve the data from a nullable column?

2 8818

What is a clustering index ?

3 7525

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

1 7049

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 9087

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

1 5248

What is a host variable?

3 6867

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 10303

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

1 5063

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a bind card?

1216

what is db2 restart?

2149

What is the connection string to connect to the DB2 Database ?

1123

What are foreign keys in db2?

1101

Highlight all the advantages that are attached to a package.

1111

What are the uses of db2 optimizer?

1293

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2060

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

What is a storage group (stogroup)?

1241

How do I add a column to a table in db2?

1101

How do I start db2 in windows?

1086

Explain the contents that are a part of dclgen.

1089

Which command is used to remove all rows from a table?

1106

can all users have the privilage to use the sql statement select * (dml)?

1164

What is the physical storage length of timestamp data type?

1089

For More Un-Answered { DB2 } Questions Click Here