Correct Answer: By using SPUFI or QMF to EXPLAIN the dynamic SQL statement
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Administration MCQ Questions
Can you use LOCK TABLE on a view?
What are segmented table spaces?
Which function does QUIESCE perform?
Which index type will cause the rows of the table to be arranged on the disk according to the ordering of their index keys?
Which COPY utility statements will backup table space DBTAB1.TS1 preparing 2 copies for local use and 2 copies for disater recovery use?
Which of the following are fields from SQLCA
When would phantom read phenomenon occur?
On the client side, what is linked with the DB2 Universal Database client library?
Which is required to use the IMPORT utility to import data into a table?
Why would you want to specify an optimization class when compiling an SQL query?