Which tasks must be performed during the installation of the UTL_MAIL package?
(Choose all that apply.)
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
Explanation:
b and c are the answers:
UTL_MAIL
The UTL_MAIL package is a utility for managing email which includes commonly used email features, such as attachments, CC, BCC, and return receipt.
This chapter contains the following topics:
Using UTL_MAIL
Security Model
Operational Notes
Summary of UTL_MAIL Subprograms
Using UTL_MAIL
Security Model
Operational Notes
Security Model
UTL_MAIL is not installed by default because of the SMTP_OUT_SERVER configuration requirement and the security exposure this involves. In installing UTL_MAIL, you should take steps to prevent the port defined by SMTP_OUT_SERVER being swamped by data transmissions.
Operational Notes
You must both install UTL_MAIL and define the SMTP_OUT_SERVER.
To install UTL_MAIL:
sqlplus sys/
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb
You define the SMTP_OUT_SERVER parameter in the init.ora rdbms initialization file. However, if SMTP_OUT_SERVER is not defined, this invokes a default of DB_DOMAIN which is guaranteed to be defined to perform appropriately
B,C