DB2 Interview Questions
Questions Answers Views Company eMail

When Can you be sure that a query will return only one row?

IBM,

4 6939

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

1 4554

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

2 8417

How many buffer pools are available in db2?

2 6149

What is the size of a data page?

IBM,

2 4776

What is the difference between CS and RR isolation levels?

1 7678

Name the different types of Table spaces.

IBM,

5 13462

How do you retrieve the data from a nullable column?

2 7527

What is a clustering index ?

3 5996

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

1 5995

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 8024

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

1 4475

What is a host variable?

3 5593

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 9467

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

1 4324


Post New DB2 Questions

Un-Answered Questions { DB2 }

Is it possible using max on a char column?

581


My sql statement select avg(salary) from emp yields inaccurate results. Why?

616


How and when does the db2 enforces the unique key?

583


Who uses db2?

551


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1867






What is with ur in db2?

724


How is a typical db2 batch pgm executed?

622


What parameters are used to control the free space in DB2?

621


What are the benefits of using the db2 database?

642


What does db2 blu stand for?

633


What is deadlock in db2?

558


How would the varchar column remarks defined?

603


How do we specify index to include or not during bind process.

1657


What is the use of predicate?

564


How does coalesce work?

561