Which three are true about PL/SQL subprograms? (Choose three.)
A.
Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
B.
Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
C.
Subprograms are cached by default and shared among users, thereby reducing memory requirements.
D.
Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
E.
A subprogram's session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.
F.
Host variables can be referenced inside any PL/SQL subprogram.
G.
A PL/SQL procedure can invoke an external code block written in a different programming language.
Reference for A:
https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-subprograms.html#GUID-250BDBBB-0CD6-4D56-9DDF-6FCEDC110D00
Reference for C:
https://docs.oracle.com/en/database/oracle/oracle-database/21/lnpls/plsql-subprograms.html#GUID-E03F512B-1A30-43B4-8DCA-64DA68AE7CE4
Reference for A is talking about PL/SQL Function Result Cache and question is talking about subprograms (functions and procedures). So I stay for C,D,G.
upvoted 2 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
studyingSQL
2 months, 1 week agoTheOracleWasTaken
1 year, 4 months agoTheOracleWasTaken
1 year, 4 months agoegznrd
1 year, 4 months ago