Try Oracle : 1Z0-144 valid & accurate questions and answers

View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

• A. MY_PROC2 is not recompiled.
• B. MY_PROC1 is recompiled without the debugging code.
• C. MY_PROC2 is recompiled but remains unchanged.
• D. MY_PROC1 is recompiled but remains unchanged.

Examine the following block of code:

Which line in the above code would result in errors upon execution?

• A. line 7
• B. line 8
• C. line 5
• D. line 2

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

• A. The code generates an error because the cursor is not opened before the FOR loop.
• B. The code generates an error because the loop does not have the exit when clause.
• C. The code executes successfully and gives the desired output.
• D. The code generates an error because the EMP_RECORD variable is not declared.

Examine the following code:

Which two statements are true about the above function? (Choose two.)

• A. It can be used only in a parallelized data manipulation language (DML) statement.
• B. It can be used only in a parallelized query.
• C. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel.
• D. It can be used in both a parallelized query and a parallelized DML statement.
• E. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization.

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS ' /temp/my_files': SQL>GRANT READ ON DIRECTORY my_dir To pubiic:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

SCOTT executes the procedure as follows:
SQL>SET SERVEROUTPUT ON
SQL>EXEC read_file ('MY_DIR', FACULTYLIST.TXT')
What is the outcome?

• A. It does not execute and displays an error message because the end-of-file condition is not taken care of.
• B. It goes into an infinite loop.
• C. It executes successfully and displays only the list of faculty names.
• D. It executes successfully and displays the list of faculty names followed by a "no data found" error message.