Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Explain what a plan is?

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

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


What is a recovery log?

1 Answers  


how to fetch first 100 rows in db2

2 Answers   IBM,


What is coalesce in db2?

0 Answers  


in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,






Describe major components of db2?

0 Answers  


What are types of indexes?

0 Answers  


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


What is schema in db2?

0 Answers  


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  






Categories