64) What happens to the PLAN if index used by it is dropped? - Plan is marked as invalid. The next time the plan is accessed, it is rebound.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MAINFRAME

DB2

DETAILS

Question: 64) What happens to the PLAN if index used by it is dropped?

Answer: Plan is marked as invalid. The next time the plan is accessed, it is rebound.

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7104 users
Added on	9/1/2014
Views	69803
Rate it!

Question: 64) What happens to the PLAN if index used by it is dropped?

Answer:

Plan is marked as invalid. The next time the plan is accessed, it is rebound. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	63) What else is there in the PLAN apart from the access path? �	View Answer
	62) What is ACQUIRE/RELEASE in BIND?	View Answer
	61) What is a DBRM, PLAN ?	View Answer
	60) What is ALTER ? �	View Answer
	59) Can I use LOCK TABLE on a view?	View Answer
	59) Can I use LOCK TABLE on a view?	View Answer
	58) What are the various locks available?	View Answer
	57) What is lock escalation?	View Answer
	56) What are the disadvantages of PAGE level lock? - RAMESH www.geocities.com/srcsinc	View Answer
	55) How does DB2 determine what lock-size to use?	View Answer
	54) What are the various locking levels available?	View Answer
	53) When do you specify the isolation level? How?	View Answer
	52) Where do you specify them ?	View Answer
	51) What is the difference between CS and RR isolation levels?	View Answer
	50) What are the isolation levels possible ? �	View Answer
	49) How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)	View Answer
	48) How do you do the EXPLAIN of a dynamic SQL statement?	View Answer
	47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? �	View Answer
	47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? �	View Answer
	45) What do you need to do before you do EXPLAIN?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DB2 Interview Questions & Answers - Exam Mode / Learning Mode