Oracle

1Z0-146 · Question #103

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)

The correct answer is A. a PL/SQL program which needs to be recompiled frequently B. a PL/SQL program that spends most of the time executing SQL. See the full explanation below for the reasoning.

Question

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)

Options

Aa PL/SQL program which needs to be recompiled frequently
Ba PL/SQL program that spends most of the time executing SQL
Ca PL/SQL program, which performs computation-intensive procedural operations and is recom iled rarely
Da PL/SQL program, which is called frequently with the same parameter values by multiple sessions and

How the community answered

(31 responses)

A
71% (22)
C
16% (5)
D
13% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-146 Practice