Oracle Related Exams
1z0-144 Exam

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?
Examine the following DECLARE section of PL/SQL block:
Which line in the above declaration would generate an error?
Examine the following PL/SQL code:
Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?