32. Which of these parameters must be consistent across execution environments for stored outlines to function as expected?
A.OPTIMIZER_MODE
B.CURSOR_SHARING
C.OPTIMIZER_FEATURES_ENABLE
D.OPTIMIZER_DYNAMIC_SAMPLING
ANSWER: C
33. Which statement is true when an outline used by a statement references an index that no longer exists?
A.The statement is executed but with an error.
B.It ignores the hints related to the index and executes by using the remaining hints in the outline.
C.The statement is executed with a new plan generated by a hard parse and the stored hint is not used.
D.It generates a new plan and stores it as a new outline specified by the USE_STORED_OUTLINE parameter.
ANSWER: C
100% Guarantee to Pass Your 1z0-033 exam and get your 9i DBA Certification
Powered By