Which of these are stored in the shared SQL area?

Examine these components:1.Execution plan for a non-embedded SQL statement2.Local, global, and package variables for a session3.Execution plan for a SQL statement contained in a PL/SQL program unit4.Results of executed queries and query fragments5.PL/SQL function result setsWhich of these are stored in the shared SQL area?Reference: https://docs.oracle.com/cloud/latest/db112/CNCPT/memory.htm#CNCPT1237

Question:

Which of these are stored in the shared SQL area?

Options:

1, 2, 4, and 5

1, 2, and 3

1 and 4

1 and 3

Correct Answer

The Correct Answer for this Question is

1 and 3

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *