Oracle 1Z0-770 Exam Dumps

The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:

You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails. The files can be in various formats, such as PDF, DOCX, XLSX, etc.

You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]

A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header.However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.

When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References:Managing Interactive Grids - Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]

The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application.The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.

In a Classic Report, an end user can perform the following actions:

Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.

Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.

The other options are incorrect because:

Create Control Breaks in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Report by using the Control Break option in the Actions menu.

Rearrange the columns in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.

Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]