Free Oracle 1Z1-144 Exam Dumps Questions & Answers

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 loop does not have the exit when clause.
• B.  The code generates an error because the cursor is not opened before the FOR loop.
• C.  The code generates an error because the EMP_RECORD variable is not declared.
• D.  The code executes successfully and gives the desired output.

/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 executes successfully and displays the list of faculty names followed by a "no data found" error message.
• C.  It executes successfully and displays only the list of faculty names.
• D.  It goes into an infinite loop.

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

• A.  It gives an error on compilation because the exception section Is used in the trigger.
• B.  It gives an error on compilation because it is not a row-level trigger.
• C.  It compiles and executes successfully.
• D.  It compiles successfully but gives an error on execution because it is not a row-level trigger.

Which two tasks should be created as functions instead of as procedures? (Choose two.)

• A.  Tasks that compute a value that must be returned to the calling environment
• B.  Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
• C.  Tasks that compute and return multiple values to the calling environment
• D.  Reference host or bind variables in a PL7SQL block of code

View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?

• A.  It gives an error because the return type is not valid.
• B.  It gives an error because the record type is not defined within the function
• C.  It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
• D.  It executes successfully and displays the names and salaries of all employees who earn the highest salary.
• E.  It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid