WHAT CONDITIONS MUST HOLD BEFORE A DATABASE SESSION CAN CREATE A FILE STORED BY THE OPERATING SYSTEM OF THE SERVER

13. What conditions must hold before a database session can create a file stored

by the operating system of the server? (Choose three correct answers.)

A. The session must be connected to a database account with execute

permission on the package UTL_FILE.

B. The session must be connected to a database account with execute

permission on the package DBMS_OUTPUT.

C. The parameter UTL_FILE_DIR must have been set.

D. The parameter DB_WRITER_PROCESSES must be set to greater than zero.

E. The parameter DB_CREATE_FILE_DEST must be set.

F. The operating system account under which the Oracle instance is running

must have write permission on the directory that will store the file.