MCQs > IT & Programming > DB2 Administration > Which is correct about the EXPLAIN statement

DB2 Administration MCQs

Which of the following is correct about the EXPLAIN statement

Answer

Correct 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)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Administration Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More DB2 Administration MCQ Questions

search

DB2 Administration Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it