Free Oracle 1Z0-770 Exam Actual Questions

The questions for 1Z0-770 were last updated On May 2, 2024

Question No. 1
Question No. 3

Which two statements are true about creating and using an interactive report?

Show Answer Hide Answer
Correct Answer: A, C

Question No. 4

Which statement is true about creating and using a faceted search page?

Show Answer Hide Answer
Correct Answer: C

A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]


Question No. 5

Which is a valid method of logging messages to the execution log in APEX automation?

Show Answer Hide Answer
Correct Answer: A

APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center], [APEX_DEBUG - Oracle Help Center]