Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

Which three are true about PL/SQL subprograms?

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.

Oracle 1z0-149 Summary

  • Vendor: Oracle
  • Product: 1z0-149
  • Update on: Aug 11, 2025
  • Questions: 65
Price: $52.5  $149.99
Buy Now 1z0-149 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method