Oracle Exam 1Z0-148 Topic 9 Question 4 Discussion

Actual exam question for Oracle's 1Z0-148 exam

Question #: 4
Topic #: 9

[All 1Z0-148 Questions]

Examine the following SQL statement:

ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;

What is the result of executing this statements?

AThe PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.

BThe PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.

CThe PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.

DThis statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,

Show Suggested Answer

Suggested Answer: C

by Maile at May 07, 2022, 02:32 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!