What is EXPLAIN?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

(Continued on next question...)

Other Job Interview Questions

• What is auditing?
• What do you mean by NOT NULL WITH DEFAULT? When will you use it?
• How do you retrieve the data from a nullable column? –
• When is the access path determined for dynamic SQL? –
• What is ALTER ?
• What is IMAGECOPY ? –
• What is QUIESCE?
• What is dynamic SQL? ––
• What does it mean if the null indicator has -1, 0, -2? –
• What is UNION,UNION ALL? –
• More...