Oracle
1Z0-144 · Question #45
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…
The correct answer is A. It executes successfully and creates the report. See the full explanation below for the reasoning.
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
How the community answered
(43 responses)- A74% (32)
- B7% (3)
- C2% (1)
- D2% (1)
- E14% (6)
Community Discussion
No community discussion yet for this question.