Download Exact Free 1Z0-148 Exam Dumps Questions

Question No : 6

Examine the section of code taken from a PL/SQL program:

PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.Which two statements are true?

A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
C. Calls to TESTPROC are not inlined in the line commented as Call 1.
D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
E. Calls to TESTPROC might be inlined in the line commented as Call 2.

Answer: A,E

Free 1Z0-148 Oracle Exam Dumps Questions Answers

Question No : 5

Refer to the Exhibit.

PL/SQL tracing in enabled in a user session using this command: EXEC DBMS_TRACE.SET_PLSQL_TRACE (DBMS_TRACE.TRACE_ENABLED_LINES)
The procedure is executed using this command: EXEC PRC_1 Examine the exhibit for the content of the PLSQL_TRACE_EVENTS table. Why is tracing excluded from the PLSQL_TRACE_EVENTS
table?

A. DBMS_TRACE.TRACE_ENABLED_LINES traces only exceptions in subprograms.
B. PRC_1 is not compiled with debugging information.
C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
D. PRC_1 is compiled with the default AUTHID DEFINER clause.
E. Tracing will be enabled only for the second execution of PRC_1.

Answer: B,E

Oracle Free 1Z0-148 Exam Dumps PDF File

Question No : 4

A products TABLE exists with a PROD_ID column. Examine this PL/SQL block:

Which statement is true?
A. It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.
B. It executes successfully.
C. It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
D. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
E. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);

Answer: C,D

Latest Free Oracle 1Z0-148 Exam Dumps Questions

Question No : 3

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” ’, TRUE));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 ’, FALSE));END;

Answer: A,C