Oracle Exam 1Z0-771 Topic 19 Question 4 Discussion

Actual exam question for Oracle's 1Z0-771 exam

Question #: 4
Topic #: 19

[All 1Z0-771 Questions]

Which two statements are true about the APEX_MAIL API?

AYou can add files as attachments to your emails using the APEX_MAIL package.

BYou can receive emails using the APEX_MAIL package in an Oracle APEX application.

CYou can send emails using the APEX_MAIL package from an Oracle APEX application.

DThe APEX_MAIL package supports sending emails only to Oracle database users.

Show Suggested Answer

Suggested Answer: A, C

The APEX_MAIL API facilitates email functionality:

A . You can add files as attachments: Using APEX_MAIL.ADD_ATTACHMENT (e.g., APEX_MAIL.ADD_ATTACHMENT(p_mail_id, p_attachment, p_filename)), you can attach BLOBs (e.g., PDFs) to emails.

C . You can send emails: APEX_MAIL.SEND (e.g., APEX_MAIL.SEND(p_to => 'user@example.com', p_body => 'Hello')) sends emails from APEX, leveraging the configured mail server.

B . You can receive emails: False; APEX_MAIL is send-only; receiving requires custom integration (e.g., IMAP).

D . Only to Oracle database users: False; emails can go to any valid address, not just database users.

Pitfall: Ensure the mail queue is processed (APEX_MAIL.PUSH_QUEUE) for timely delivery.

by Avery at Mar 21, 2025, 03:27 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-771 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Golda

13 days ago

I bet the person who wrote this question tries to make their own coffee at work and ends up spilling it all over their desk.

upvoted 0 times

...

Francis

15 days ago

This is a straightforward question. The correct answers are A and C. The APEX_MAIL package is all about sending emails, not receiving them.

upvoted 0 times

...

Elliott

17 days ago

D is just silly. Why would the APEX_MAIL package be limited to only Oracle database users? That makes no sense.

upvoted 0 times

Alex

2 days ago

A) You can add files as attachments to your emails using the APEX_MAIL package.

upvoted 0 times

...

Vincent

22 days ago

B is false, the APEX_MAIL package is for sending emails, not receiving them. That's not its purpose.

upvoted 0 times

...

Justine

1 months ago

I'm not sure about statement D. I think you can send emails to anyone, not just Oracle database users.

upvoted 0 times

...

Mariko

1 months ago

A and C are definitely true. I use the APEX_MAIL package all the time to send emails from my APEX apps.

upvoted 0 times

Ria

8 days ago

I agree, A and C are correct. I also use APEX_MAIL for sending emails.

upvoted 0 times

...

Bernardo

1 months ago

I believe statement A is also true because you can add attachments to emails with APEX_MAIL.

upvoted 0 times

...

Giovanna

1 months ago

I agree with Chaya. Sending emails is a common use case for the APEX_MAIL API.

upvoted 0 times

...

Chaya

1 months ago

I think statement C is true because you can send emails using the APEX_MAIL package.

upvoted 0 times

...