Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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