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