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 8652

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

1 5503

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

2 9602

How many buffer pools are available in db2?

2 7214

What is the size of a data page?

IBM,

2 5861

What is the difference between CS and RR isolation levels?

1 8555

Name the different types of Table spaces.

IBM,

5 15415

How do you retrieve the data from a nullable column?

2 8823

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 7055

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 9092

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

1 5256

What is a host variable?

3 6880

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 10308

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

1 5069

Post New DB2 Questions

Un-Answered Questions { DB2 }

Why do we need reorg in db2?

985

Explain in detail about buffer manager and its functionalities?

1064

What is a db2 schema?

1227

How many databases are there?

1052

can we view the access paths created by dbrm ? how ? thx

7093

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1277

What is the use of value function?

1149

What is sqlca?

1072

List out the three types of page locks that can be held.

1149

How does db2 sample database connect?

1027

what is the sqlcode -501

13149

What is the difference between cursor and select statement?

1100

What is package in db2 mainframe?

987

How can you do the explain of a dynamic sql statement?

1069

How do you pull up a query which was previously saved in qmf?

1149

For More Un-Answered { DB2 } Questions Click Here