Oracle Database 11g: Program with PL/SQL — Question 73

Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)

Answer options

• A. setting the UTL_FILE_DIR initialization parameter
• B. running the UTLMAIL.SQL and prvtmail.plb scripts
• C. setting the SMTP_OUT_SERVER initialization parameter
• D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
• E. granting read and WRITE privileges to control the type of access to files in the operating system

Correct answer: B, C

Explanation

The correct actions during the installation of the UTL_MAIL package include executing the UTLMAIL.SQL and prvtmail.plb scripts (B) and configuring the SMTP_OUT_SERVER initialization parameter (C). The other options, such as setting UTL_FILE_DIR (A), using CREATE DIRECTORY (D), and granting privileges (E), are not essential for the installation process of UTL_MAIL.