Oracle
1Z0-144 · Question #45
1Z0-144 Question #45: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #45. The question stem and answer options stay visible for context.
Question
View Exhibit1 and examine the structure of the employees table. User SCOTT needs to generate a text report that contains the names of all employees and their salaries. Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT; View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command: SQL_EXEC sal_5tatus ('MY_DIR', `EMPREPORT.TXT') What is the outcome?
Exhibits
Options
- AIt executes successfully and creates the report.
- BIt gives an error because the text file should be opened in append mode.
- CIt gives an error because the "no data found" condition is not handled to come out of the loop.
- DIt gives an error because user SCOTT should be granted both read and write privileges to the
- EIt executes but no data is written to the text file because the FFLUSH subprogram is not used to
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.