View the Exhibit and examine the package code created by SCOTT. The execute privilege on this packageis granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?

/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?

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cut_name VERCHAR2 (20) NOT NULL := 'tom jones':
Same_name cut_name\TYPE:
Which statement is correct about the above snippets of code?

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)