Free 1Z0-144 Web TestEngine Demo

Q12 Single choice

/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 public:

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

1Z0-144 Web TestEngine demo