Performance Tuning - Question 009

To create a stored outline that has a nonsystem generated outline name, you'll need to perform which of the following?

A . Use the DBMS_OUTLIN.CREATE_OUTLINE procedure.
B . Set the CREATE_STORED_OUTLINES initialization parameter.
C. Use the CREATE or REPLACE OUTLINE command.
D . Use the ALTER SYSTEM SET CREATE_STORED_OUTLINES command.

Explanation:

Answer C: You can create a named stored outline for one query at a time with the CREATE or REPLACE OUTLINE command. Use the DBMS_OUTLIN.CREATE_OUTLINE procedure and Set the CREATE_STORED_OUTLINES initialization parameter are invalid answers; Use the ALTER SYSTEM SET CREATE_STORED_OUTLINES command. will create stored outlines with system-generated names for all executed SQL statements.