Oracle Updated 1z0-770 Exam Questions and Answers by liana

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]

Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:

• Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
• Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
• Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.

Deleting a database record based on an end user’s request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.

The “Create an Application From a File” wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are:

• A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc.
• CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc. VerifiedReferences: [Creating an Application From a File - Oracle Help Center], [Creating an Application Based on Sample Data Sets - Oracle Help Center]

The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.