/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?

Question

/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?

Accepted Answer

D. It executes successfully and displays the list of faculty names followed by a "no data found" error

Answer

A. It goes into an infinite loop.

Answer

B. It executes successfully and displays only the list of faculty names.

Answer

C. It does not execute and displays an error message because the end-of-file condition is not taken

/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…

Question

Exhibit

Options

How the community answered

Community Discussion