Free 1Z0-770 Sample Questions and 100% Cover Real Exam Questions (Updated 144 Questions)
Download Real Oracle 1Z0-770 Exam Dumps Test Engine Exam Questions
Successfully passing the Oracle 1Z0-770 exam can lead to a variety of career opportunities for APEX developers. Oracle APEX Developer Professional certification demonstrates that an individual has the necessary skills and knowledge to design, develop, and maintain complex APEX applications. It can also help individuals stand out in a competitive job market and increase their earning potential. Overall, the Oracle 1Z0-770 exam is a valuable certification for anyone who works with APEX and wants to take their career to the next level.
NEW QUESTION # 12
Select the two advantages of using One-click Remote Deployment.
- A. Deploy the app, and explicitly install the supporting objects in one-click.
- B. Directly deploy your app definition along with the objects from the source system to the target system
- C. You need to access your production environment to import the app directly.
- D. Simplify the process of deploying an application
Answer: A,B
Explanation:
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.
NEW QUESTION # 13
Which statement is true about creating and using a report with form?
- A. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
- B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
- C. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- D. The Create Page Wizard doesn't support the creation of a classic report and formcombination
Answer: A
Explanation:
Explanation
You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on. Verified References: [Creating a Report Using the Create Page Wizard - Oracle], [Creating a Report with Form on Table - Oracle]
NEW QUESTION # 14
Which statement is true about creating and using an interactive grid?
- A. End users cannot rearrange columns by dragging and dropping.
- B. An interactive grid supports Pivot View and Group By View features.
- C. For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
Answer: C
Explanation:
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
End users can change the report layout by using the Actions menu or by dragging and dropping columns. They can also create private reports that save their personal preferences for the report. These features are available for both editable and noneditable interactive grids. Verified References: Using an Interactive Grid - Oracle Help Center, Example Interactive Grid - Oracle Help Center
NEW QUESTION # 15
Which two statements are true about REST Data Sources?
- A. REST Data Sources doesn't support any authentication
- B. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- C. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- D. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
Answer: C,D
Explanation:
Explanation
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can contain one or many Operations, which are the references to a concrete external web service endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data Sources in interactive reports and grids, as well as other components. REST Data Sources can support various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST Data Sources] and [Creating a REST Data Source]
NEW QUESTION # 16
Select the three ways in which you can create a Form in APEX.
- A. Using the Create Page wizard
- B. Using the Create Application Wizard
- C. Using Shared Components
- D. Create a Form region in Page Designer
Answer: A,B,D
Explanation:
Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.
NEW QUESTION # 17
Select two features of a Smart Filters Page.
- A. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs.
- B. Consists of a single search field with filters at the top of the page and a report at the bottom
- C. Each filter represents the text entered by the end user in the search field
- D. Consists of filters at the left side and report on the right side of the page
Answer: A,B
Explanation:
Explanation
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.
NEW QUESTION # 18
What are the three types of List of Values(LOV) you can create on a page?
- A. Dynamic LOV
- B. Static LOV
- C. Cascading LOV
- D. Popup LOV
Answer: A,B,C
Explanation:
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.
NEW QUESTION # 19
Which two statements are true about creating and using dynamic actions?
- A. You can execute JavaScript code by creating a dynamic action.
- B. If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not
- C. If no client-side condition is defined, true actions will not fire.
- D. Once you create a dynamic action, you cannot add additional true actions.
Answer: A,B
Explanation:
Explanation
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]
NEW QUESTION # 20
What are the required fields while creating a Chart in APEX?
- A. Value Column
- B. Label Column
- C. All of them
- D. Name
- E. Data Source
Answer: C
Explanation:
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.
NEW QUESTION # 21
Choose the three requirements for creating a REST Enabled SQL Reference.
- A. Install Oracle REST Data Services (ORDS) 19.x or later.
- B. Activate REST Enabled SQL for the target schema on the remote database
- C. Set up any remote database
- D. Configure and enable the REST Enabled SQL service feature
Answer: A,B,D
Explanation:
Explanation
To create a REST Enabled SQL Reference, you need to meet the following requirements:
Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.
You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.
NEW QUESTION # 22
Which two statements are true about REST Data Source Synchronization?
- A. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
- B. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
- C. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
- D. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
- E. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
Answer: B,C
Explanation:
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs
NEW QUESTION # 23
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Add Users
- B. Assign roles to users
- C. Create new application roles
- D. Create Authorization schemes
Answer: A,B
Explanation:
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]
NEW QUESTION # 24
In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?
- A. Stacked Master Detail
- B. Side by Side Master Detail
- C. Drill down Master Detail
- D. Editable Interactive Grid
Answer: C
Explanation:
Explanation
A drill down master detail form allows you to create a master detail form that contains two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. You can use the Create Page wizard to create a drill down master detail form. References: Creating Master Detail Forms and [Creating a Drill Down Master Detail Form]
NEW QUESTION # 25
Which two feature pages can you create using the Create Page Wizard?
- A. Search Page
- B. Feedback
- C. Access Control
- D. Unified Task List
Answer: B,C
Explanation:
Explanation
The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types
NEW QUESTION # 26
Which two statements that are TRUE about charts in Interactive grid?
- A. Once a chart is created, you can switch the view between Grid and Chart view.
- B. Once the chart is created, it cannot be reconfigured.
- C. You can create multiple charts at a time in an interactive grid
- D. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
Answer: A,D
Explanation:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid
NEW QUESTION # 27
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Delete database
- C. Create and view database objects
- D. Run SQL commands and scripts
Answer: C,D
Explanation:
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
NEW QUESTION # 28
Which statement is true about the Link Column attribute of an interactive report?
- A. If you select Link Column, it is always displayed as the last column in the report.
- B. It is not possible to include a custom target in Link Column
- C. It is not possible to exclude Link Column.
- D. A Link Column cannot be sorted, hidden, or moved by an end user.
Answer: D
Explanation:
Explanation
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.
NEW QUESTION # 29
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle Autonomous Cloud
- B. Amazon RDS
- C. Oracle XE
- D. Microsoft Azure
- E. All of the above
Answer: E
Explanation:
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure
NEW QUESTION # 30
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?
- A. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
- B. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
- C. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
- D. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
Answer: D
Explanation:
Explanation
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. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]
NEW QUESTION # 31
Choose the two statements that are TRUE about the Universal Theme in APEX.
- A. Responsive UI
- B. Not designed to work on tablets
- C. Easy customization
- D. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
Answer: A,C
Explanation:
Explanation
The Universal Theme is a responsive user interface design for Oracle APEX applications. It has the following features:
Responsive UI: The Universal Theme uses responsive design techniques to adapt to different screen sizes and orientations. It ensures that your applications look great and work well on any device, such as desktops, laptops, tablets, or smartphones.
Easy customization: The Universal Theme allows you to customize the appearance and behavior of your applications using various tools and options. You can use Theme Roller to change the colors, fonts, icons, and styles of your applications. You can also use Template Options to modify the layout and functionality of your components.
The other options are incorrect because:
Not designed to work on tablets: The Universal Theme is designed to work on tablets as well as other devices. It uses responsive design techniques to adapt to different screen sizes and orientations.
The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme: The developers do not need to have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. They can use declarative tools such as Theme Roller and Template Options to customize their applications without coding.
Verified References: [About Universal Theme] [Using Theme Roller] [Using Template Options]
NEW QUESTION # 32
Choose the three correct statements about Charts in APEX.
- A. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
- B. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
- C. You can create charts without using Oracle JET
- D. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
Answer: A,B,D
Explanation:
Explanation
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.
NEW QUESTION # 33
Which three of the following statements are TRUE about saved Public Interactive Grids?
- A. To enable an end user to save a public interactive grid, the user must have the required permission
- B. Any user may save public interactive grids
- C. Public reports are available to all users
- D. Only the user who creates a public interactive grid can save, rename, or delete it
Answer: A,C,D
Explanation:
Explanation
Public reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12
NEW QUESTION # 34
Which statement is true about Theme Styles in Oracle APEX?
- A. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
- B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- C. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
Answer: B
Explanation:
Explanation
Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences. Verified References: Using Themes and Theme Styles - Oracle Help Center, Theme Styles - Oracle APEX
NEW QUESTION # 35
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:
- A. Scroll
- B. Page
- C. No Pagination
- D. Page and Scroll
Answer: D
Explanation:
Explanation
When a table or a SQL query returns many rows, an interactive grid is best displayed to the user with pagination. Pagination enables users to navigate through large data sets by displaying a subset of data at a time3. The two types of pagination available for interactive grids are Page and Scroll3. Page pagination displays a fixed number of rows per page and provides controls to navigate between pages. Scroll pagination displays rows as the user scrolls down the grid and fetches more data as needed
NEW QUESTION # 36
Which three of the following statements are TRUE about Faceted Search?
- A. The facets are displayed on the left and upper part of the screen
- B. You can create only 5 facets per page
- C. After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately.
- D. The right side of the page features a Search Results region, which can display as a classic report or a cards report.
Answer: A,C,D
Explanation:
Explanation
A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:
After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.
NEW QUESTION # 37
......
Oracle 1Z0-770 certification exam consists of 60 multiple-choice questions, which must be completed within 105 minutes. Candidates must achieve a passing score of 63% or higher to earn the certification. 1Z0-770 exam can be taken at any Pearson VUE testing center worldwide, and it can also be taken online using a proctored exam format.
New 1Z0-770 exam dumps Use Updated Oracle Exam: https://www.dumpsquestion.com/1Z0-770-exam-dumps-collection.html
Verified 1Z0-770 Dumps Q&As - 1Z0-770 Test Engine with Correct Answers: https://drive.google.com/open?id=1fBgWA_E8iYoeXq7P4sUDMyPhXS4vHVwA