Free Oracle 1z1-148 Exam Dumps Questions & Answers

Examine this query executed as SYS and its output:

Which two observations are true based on the output?

• A.Repetitive SQL queries and PL/SQL function results are cached and automatically used from the cache across all SYS user sessions.
• B.Repetitive SQL queries executed on permanent non-dictionary objects may have faster response times.
• C.All distinct query results are cached for the duration of a SYS user session.
• D.The client-side result cache and the server-side result cache are enabled.
• E.The result cache exists but which SQL queries are cached depends on the value of the RESULT_CACHE_MODE parameter.

Which two PL/SQL blocks give the output "this is a test message"?

• A.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;
• B.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;
• C.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;
• D.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
  ', TRUE));END;
• E.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;

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

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

Which two statements are true about inlining PL/SQL subprograms? (Choose two.)

• A.Programs making use of large helper subroutines are good candidates for inlining.
• B.Only local subroutines can be inlined.
• C.PRAGMA INLINE must be specified.
• D.PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
• E.PLSQL_OPTIMIZE_LEVEL must be set to 3 to inline external subroutines.

Examine the EMPLOYEE_IDS table its data:

Examine this PL/SQL block:

What is the result of executing this PL/SQL block with SERVEROUTPUT enabled?

• A.It executes successfully and outputs:Fetched: 1011, JJONES,Fetched: 1012, SSMITH,
• B.It executes successfully and outputs:Fetched: 1011, JJONES, 3789Fetched: 1012, SSMITH, -1
• C.Compilation fails saying EMP_TAXID must be declared.
• D.It executes successfully and outputs:Fetched: 1011, JJONES, -1Fetched: 1012, SSMITH, -1
• E.An exception is thrown at runtime saying EMP_TAXID is not visible.