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 8780

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

1 5571

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

2 9703

How many buffer pools are available in db2?

2 7316

What is the size of a data page?

IBM,

2 5970

What is the difference between CS and RR isolation levels?

1 8630

Name the different types of Table spaces.

IBM,

5 15590

How do you retrieve the data from a nullable column?

2 8915

What is a clustering index ?

3 7627

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

1 7116

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 9181

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

1 5338

What is a host variable?

3 7006

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 10386

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

1 5131

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to compare data between two tables in db2?

1136

How to connect to db2 database from windows command line?

1127

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1144

What is table space in db2?

1069

How does db2 sample database connect?

1077

What is the result of open cursor statement?

1125

Where do you specify them?

1362

What language is db2 written in?

1098

How do I delete a column in db2?

1152

Explain what are the various isolation levels possible?

1093

What is bind in db2?

1089

What is iseries database?

1113

Give a brief description of db2 isolation levels?

1133

What is a bind in db2?

1100

What is the use of runstats in db2?

1175

For More Un-Answered { DB2 } Questions Click Here