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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Explain what a plan is?

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain what a plan is?..

Answer / bhavna

A plan is an executable module containing the access path
produced by DB2 optimizer.

Is This Answer Correct ?    4 Yes 0 No

Explain what a plan is?..

Answer / shashidhar.k.

Plan is load module for SQL statements

Is This Answer Correct ?    3 Yes 3 No

Explain what a plan is?..

Answer / s

An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is a host variable?

3 Answers  

What is the maximum length of sqlca?

0 Answers  

How do I import a csv file into db2?

0 Answers  

what is load and unload in db2

1 Answers   IBM,

Name some fields from SQLCA.

2 Answers  

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

What is the size of a data page?

2 Answers   IBM,

How to design maps

1 Answers   Virtusa,

Compare a subselect to a join?

1 Answers  

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

For more DB2 Interview Questions Click Here
Categories