How would you go about generating an EXPLAIN pla

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

(Continued from previous question...)

22. How would you go about generating an EXPLAIN plan?

Create a plan table with utlxplan.sql.
Use the explain plan set statement_id = 'tst1' into plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql

(Continued on next question...)

Other Job Interview Questions

• How do you create a new session while open a new form?
• Explain the use of setting GLOBAL_NAMES equal to TRUE.
• What is a Query Record Group?
• Give the stages of instance startup to a usable state where normal users may access it.
• How would you force a log switch?
• What are the different objects that you cannot copy or reference in object groups?
• What is the significance of having storage clause?
• What command would you use to create a backup control file?
• What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
• If two groups are not linked in the data model editor, What is the hierarchy between them?
• More...