Newly Released Oracle 1z0-770 Exam PDF

The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:

• Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
• Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.

The other options are incorrect because:

• Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
• Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.

Verified References: [Customizing Interactive Reports] [Column Heading Menu]

An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:

• End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
• End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.

The other options are incorrect because:

• End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
• End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.

Verified References: [About Interactive Reports] [About Interactive Grids]

Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are:

• Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs.
• Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin,SQL Commands, and SQL Scripts. Verified References: [Managing Database Objects with Object Browser - Oracle Help Center], [Creating Lookup Tables - Oracle Help Center]

A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:

• During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
• A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
• A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
• You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.

Verified References: Managing WorkspacesAbout Workspaces