Multiple choice technology databases

What is the name of the variable that is used to set the directories in the database initialization file

  1. UTL_FILE_DIR

  2. UTL_FILE_DIRECTORY

  3. UTL_DIR

  4. UTL_DIRECTORY

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

UTL_FILE_DIR is the initialization parameter that specifies which directories can be accessed by the UTL_FILE package. This parameter must be set in the database initialization file (init.ora or spfile) to allow file operations. The other options are not valid Oracle initialization parameters.

Keep practicing — related questions