Monday, 21 September 2009

Performance Tuning - Question 074.

To begin using a stored outline for the instance, what should you do?

A . Execute the ALTER DATABASE USE_STORED_OUTLINES=category_name command.

B . Execute the procedure DBMS_OUTLN.USE_SYSTEM_STORED_OUTLINES('category_name').

C. Execute the ALTER SYSTEM USE_STORED_OUTLINES=category_name command.

D . Set init.ora parameter USE_STORED_OUTLINES=category_name.

Explanation:

Answer C: If category_name is DEFAULT or TRUE, then the DEFAULT outline is used. Otherwise, specify a named stored outline. USE_STORED_OUTLINES is not an initialization parameter.

No comments:

Post a Comment