[Nov-2023] Oracle Database 1z1-770 Exam Practice Test Questions Dumps Bundle! [Q62-Q86]

Q62. Which three statements are TRUE about Shared Components?

Once you create a Shared Component, you can add them to any page within your APEX application

Shared components are common elements that can be displayed or applied on any page within an application

Once you create a Shared Component, you can add them to any page within an APEX application in any workspace.

Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components

Q63. You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?

As Primary only

As Public only

As Private only

As Private and public only

Q64. Which two statements are true about REST Data Source Synchronization?

To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application’s parsing schema.

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.

If the local table is not in sync with the Data Profile, Data Synchronization doesn’t work.

You cannot trigger Data Synchronization on a regular schedule using a scheduler job.

The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties

Q65. Choose the three supported spatial geometry objects in Maps.

Polygons

Heat map

Bars

Points

Q66. What three components must be considered whilemigrating an APEX app betweenenvironments?

Move the database objects

Move the images

Move the sessions data

Move the application definition and all associated files

Q67. What three are the key features of Data Load Definition?

The APEX_DATA_LOADING PL/SQL API is available for custom processing.

Only XML data format can be loaded to tables or collections

Column mapping occurs at design time, removing the burden on end users.

Easy workflow for end users: upload the file, verify the preview, and load data

Q68. You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme?

Refreshing the templates

Verifying the theme subscription

Subscribing the copied theme to the master theme and refreshing the theme

Copying the changes made in the master theme to the copied theme

Q69. Which statement is true about using SQL Commands?

You can search and filter database objects.

You can design and prototype data models using a markdown-like shorthand syntax.

In SQL Commands, you can view queries saved in Query Builder.

You can unload data from the database.

Q70. Which of the following are preconfigured authentication schemes?

Open Door Credentials

All of them

LDAP Directory

HTTP Header Variables

Social Sign In

Q71. Which two statements are TRUE about Dynamic Actions?

More dynamic actions you add to a page, the greater your overall page size.

It is not possible to debug Dynamic Actions from the Developer Toolbar

Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.

Dynamic Actions require complex client side Javascript code

Q72. Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?

Page Refresh

Page Validation

Page Rendering

Page Processing

Q73. Choose the three correct statements about Charts in APEX.

You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more

Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.

You can create charts without using Oracle JET

Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.

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.

Q74. Which two statements are true about creating and customizing Smart Filters pages?

If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.

The search results report can be displayed as an interactive report.

The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.

The search results report can be displayed as an interactive grid

Q75. Which statement is true about session state management in Oracle APEX?

A user cannot run multiple instances of an application simultaneously in different browser programs.

APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.

Multiple number of sessions cannot exist in the database at the same time

Q76. When you create an Access Control Page, which three of the following Access Roles get created?

Developer

Reader

Administrator

Contributor

Q77. Which two statements are true about the Create Application Wizard?

It allows application pages to be reordered.

It allows application pages to be added or deleted.

It allows the uploading of JavaScript or CSS files required for an application.

It allows the application authorization to be changed

Q78. Which two actions enable “hide and show” behavior of a data series in a bar chart when its corresponding legend item is clicked?

Setting the on Data Change attribute value to slide to Left

Setting the Hide and Show Behavior attribute value to Rescale

Setting the Hide and Show Behavior attribute value to None

Setting the Hide and Show Behavior attribute value to No Rescaling

Q79. Which two statements are true about REST Data Sources?

AREST Data Source can contain one or many Operations which are the references toa concrete external web service

Oracle APEX doesn’t provide direct integration of REST Data Sources in interactivereports

Oracle APEX supports the REST Enabled SQL Query REST Data Source type

REST Data Sources doesn’t support any authentication

Q80. To create a Dynamic Action, you need to specify which three of the following options?

What action or actions are performed

When the action occurs

What elements are affected by the action

Why the action is performed

Q81. You want to enable anyone to access your application using a built-in login page that captures a user name.
Whichauthentication scheme would youchoose?

Social Sign-In

No Authentication

Open Door Credentials

Custom Authentication

Q82. You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?

#APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#

:APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE

:APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE

#APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#

Q83. Which statement is true about importing an APEX application?

You cannot import an APEX application exported from a latest APEX version to an old APEX version.

The import process does not import the supporting objects defined during the export.

You cannot change the application ID during the import process.

Q84. You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?

Side by Side

Drill Down

Stacked

Q85. I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?

Filter

Data

columns

Format

Q86. Select the three types of Facets you can create in APEX.

Range

Text Area

Checkbox Group