Online Access Free 1z1-148 Exam Questions

Which three statements are correct with reference to intra unit inlining?

• A.Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
• B.Inlining will always decrease the size of a unit.
• C.Pragmas apply only to calls in the next statement following the pragma.
• D.Programs that make use of smaller helper subroutines are good candidates for inlining.
• E.You cannot inline local subroutines.
• F.You cannot inline an external subroutine.

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

• A.1-e, 2-a, 3-c, 4-b, 5-d
• B.1-b, 2-d, 3-c, 4-e, 5-a
• C.1-c, 2-b, 3-e, 4-a, 5-d
• D.1-c, 2-d, 3-b, 4-e, 5-a
• E.1-c, 2-a, 3-b, 4-e, 5-d

Examine this PL/SQL block:

If PLSQL_CCFLAGS is set to:
'flag1:TRUE, flag2:2, flag3:NULL'
What is the result of submitting this PL/SQL block for execution with SERVEROUTPUT enabled?

• A.It fails compilation.
• B.It executes successfully and outputs "Line: 8".
• C.It executes successfully and outputs "Line: 5".
• D.It executes successfully and outputs "Line: ".
• E.It executes successfully and outputs "Line: 3".
• F.It executes successfully and outputs "Line: 10".

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

• A.When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
• B.When the maximum amount of server result cache memory that can be used for a single result is set to 0.
• C.When the database administrator disables the result cache during ongoing application patching
• D.When the function is executed in a session frequently with the same parameter value
• E.When the amount of memory allocated for the result cache is increased

Examine this code:

The anonymous block fails this error stack:

Which two changes, when separately applied, would prevent these errors from occurring?

• A.Define v1 as employees%ROWTYPE.
• B.Nothing because using the function TABLE (V1) is prohibited.
• C.Define v2 as pkg. rec.
• D.Define v2 as employees%ROWTYPE.
• E.Initialize v1 and v2 with appropriate constructor functions.