Oracle 1z1-148 Actual Free Exam Questions & Community Discussion
Which statement describes the plshprof command-line utility?
Correct Answer: E
Vote an answer
Examine this function that is using the RESULT_CACHE clause:
After executing the function twice, passing 100 and 150 as input parameters, the LOCATIONS table is updated for LOCATION_ID = 100.
Which statement is correct if the function is called again, passing 150 as the input parameter?
After executing the function twice, passing 100 and 150 as input parameters, the LOCATIONS table is updated for LOCATION_ID = 100.
Which statement is correct if the function is called again, passing 150 as the input parameter?
Correct Answer: B
Vote an answer
Refer to the Exhibit.
Examine this procedure created in a session where PLSQL_OPTIMIZE_LEVEL =2:
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?
Examine this procedure created in a session where PLSQL_OPTIMIZE_LEVEL =2:
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?
Correct Answer: D
Vote an answer
Examine this external function declaration:
Which C function does it publish?
Which C function does it publish?
Correct Answer: G
Vote an answer
The STUDENTS table with column LAST_NAME of data type VARCHAR2 exists in your database schema.
Examine this PL/SQL block:
Which two actions must you perform for this PL/SQL block to execute successfully?
Examine this PL/SQL block:
Which two actions must you perform for this PL/SQL block to execute successfully?
Correct Answer: A,C
Vote an answer
Your company decided to update its employees' contact information as a one-time event.
With thousands of employees' records to be updated, the project manager hoped to achieve substantial performance gains using the DBMS_PARALLEL_EXECUTE package and identified these four actions to be executed.
1) dbms_parallel_execute.create_task
2) GRANT system privilege CREATE JOB to the user executing this task
3) dbms_parallel_execute.run_task
4) dbms_parallel_execute.create_chunks_by_rowid
Select the correct order of actions to implement the parallel execution of PL/SQL blocks.
With thousands of employees' records to be updated, the project manager hoped to achieve substantial performance gains using the DBMS_PARALLEL_EXECUTE package and identified these four actions to be executed.
1) dbms_parallel_execute.create_task
2) GRANT system privilege CREATE JOB to the user executing this task
3) dbms_parallel_execute.run_task
4) dbms_parallel_execute.create_chunks_by_rowid
Select the correct order of actions to implement the parallel execution of PL/SQL blocks.
Correct Answer: E
Vote an answer
Examine this code:
What will be the outcome with SERVEROUTPUT enabled?
What will be the outcome with SERVEROUTPUT enabled?
Correct Answer: A
Vote an answer
You create this package and procedure:
Which two blocks will execute without errors? (Choose two.)
Which two blocks will execute without errors? (Choose two.)
Correct Answer: A,D
Vote an answer
Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?
Correct Answer: D
Vote an answer
0
0
0
10