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

What will the FREE command do to a plan?

Question Posted / guest

Answers were Sorted based on User's Feedback



What will the FREE command do to a plan?..

Answer / s

Drops the plan.

Is This Answer Correct ?    4 Yes 0 No

What will the FREE command do to a plan?..

Answer / sv kumar

it will delete that existing plan

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How can you split a table in to exactly half?

7 Answers   HSBC,

What are the three lock types?

2 Answers  

What happens to a cursor after a commit?

3 Answers  

What is deadlock?

2 Answers  

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

What are the functions in DB2?

3 Answers   Satyam,

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

How to find schema of a table in db2?

0 Answers  

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

For more DB2 Interview Questions Click Here
Categories