Oracle
1Z0-144 · Question #81
1Z0-144 Question #81: Real Exam Question with Answer & Explanation
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.