What is EXPLAIN? ? - EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).

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: What is EXPLAIN? ?

Answer: EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9576 users
Added on	9/9/2014
Views	68019
Rate it!

Question: What is EXPLAIN? ?

Answer:

EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ). 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
	Give name some fields from SQLCA.	View Answer
	How is a typical DB2 batch pgm executed ?	View Answer
	Will precompile of an DB2-COBOL program bomb, if DB2 is down?	View Answer
	Is DECLARE TABLE in DCLGEN necessary? Why it used?	View Answer
	Is it mandatory to use DCLGEN? If not, why would you use it at all?	View Answer
	What are the contents of a DCLGEN? -	View Answer
	What is DCLGEN ?	View Answer
	What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?	View Answer
	What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?	View Answer
	Give the COBOL definition of a VARCHAR field.	View Answer
	How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )	View Answer
	When you COMMIT, is the cursor closed?	View Answer
	Can you have more than one cursor open at any one time in a program ? ?	View Answer
	Is DECLARE CURSOR executable?	View Answer
	What happens when you say OPEN CURSOR?	View Answer
	How do you specify and use a cursor in a COBOL program? ?	View Answer
	Where would you specify the DECLARE CURSOR statement? ?	View Answer
	How would you retrieve rows from a DB2 table in embedded SQL? ?	View Answer
	What is a cursor? why should it be used?	View Answer
	What are correlated subqueries?	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