Most Recent Oracle 1Z0-770 Exam Questions & Answers

A smart filters page is a type of component that features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar) at the bottom. A smart filters page behaves similarly to faceted search, but it features a more space efficient layout. Two of the features of a smart filters page are:

Consists of a single search field with filters at the top of the page and a report at the bottom. This feature provides a simple and compact user interface that allows users to enter text in the search field and see suggested filters based on their input. Users can also see and modify applied filters at any time.

Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. This feature provides useful information to users about how many records match each filter value. Users can also choose between different types of suggestions, such as dynamic, static, or SQL query.

Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]

Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:

Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.

Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]

A chart is a type of component that enables users to visualize data in different ways and perform data analysis. A chart can display data in various formats, such as bars, lines, areas, ranges, combinations, scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development principles. Three of the correct statements about charts in Oracle APEX are:

You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that can be used to display data in different ways and support different analysis scenarios. You can choose from over 20 chart types when creating a chart in Oracle APEX.

Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying technology for rendering charts in the browser. Oracle JET provides high-performance and interactive data visualizations that are compatible with various devices and browsers.

Each Oracle JET visualization supports animation, accessibility, responsive layout, internationalization, test automation, and a range of inter activity features. This statement is true because Oracle JET offers many features and capabilities that enhance the user experience and functionality of the charts. For example:

Animation: Charts can have smooth transitions and effects when loading or updating data.

Accessibility: Charts can support keyboard navigation, screen reader compatibility, and high contrast mode for users with disabilities.

Responsive layout: Charts can adapt to different screen sizes and orientations by resizing or repositioning elements.

Internationalization: Charts can support different languages, date formats, number formats, and text directions for users from different regions.

Test automation: Charts can support automated testing tools and frameworks by providing unique identifiers for elements.

Interactivity: Charts can support user actions such as zooming, panning, filtering, selecting, drilling down, or popping up tooltips.

The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified columns and data types. It does not insert any data into the tables, nor does it create any primary or foreign keys. The script only creates the tables and their columns. References:Creating a Desktop Database ApplicationandUsing SQL Workshop