1Z0-144 · Question #81
/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…
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
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?
Exhibit
Options
- AIt goes into an infinite loop.
- BIt executes successfully and displays only the list of faculty names.
- CIt does not execute and displays an error message because the end-of-file condition is not taken
- DIt executes successfully and displays the list of faculty names followed by a "no data found" error
Unlock 1Z0-144 to see the answer
You've previewed enough free 1Z0-144 questions. Unlock 1Z0-144 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.