[2024年08月]更新のOracle 1Z0-770公式認定ガイドPDF
試験1Z0-770 Oracle APEX Developer Professional
Oracle 1Z0-770認定を取得すると、Apex開発者に多くの利点があります。 Apexを使用して高品質のWebアプリケーションを開発する習熟度を実証することができます。これにより、キャリアを進めて収益の可能性を高めることができます。さらに、Oracleが提供するトレーニングおよび認定プログラムなど、認定専門家やリソースのコミュニティへのアクセスを提供できます。
質問 # 74
Which of the following are preconfigured authentication schemes?
- A. Open Door Credentials
- B. HTTP Header Variables
- C. LDAP Directory
- D. Social Sign In
- E. All of them
正解：E
解説：
Explanation
Oracle APEX provides several preconfigured authentication schemes that follow a standard behavior for authentication and session management. You can select a preconfigured authentication scheme from the gallery when you create an authentication scheme for your application. The preconfigured authentication schemes are:
Open Door Credentials: This scheme enables anyone to access your application using a built-in login page that captures a user name.
LDAP Directory: This scheme authenticates a user and password with an authentication request to a LDAP server.
HTTP Header Variable: This scheme authenticates users externally by storing the username in a HTTP Header variable set by the web server.
Social Sign-In: This scheme supports authentication with Google, Facebook, and other social networks that support OpenID Connector OAuth2 standards.
Oracle APEX Accounts: This scheme authenticates users against Oracle APEX user accounts that are created within and managed in the APEX user repository.
Custom Authentication: This scheme allows you to create a custom authentication scheme from scratch to have complete control over your authentication interface.
Database Accounts: This scheme authenticates users using database schema accounts.
Oracle Application Server Single Sign-On Server: This scheme delegates authentication to the Oracle AS Single Sign-On (SSO) Server.
SAML Sign-In: This scheme delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
質問 # 75
What are the two primary ways to move database objects and data from one environment toanother, for a single application?
- A. SQL Workshop
- B. Page Designer
- C. Oracle SQL Developer
- D. App Builder
正解：A、C
解説：
Explanation
Oracle SQL Developer and SQL Workshop are two primary ways to move database objects and data from one environment to another, for a single application. Oracle SQL Developer is a graphical tool that allows you to export and import data schemas using Data Pump or SQL scripts. SQL Workshop is a component of Oracle APEX that enables you to perform tasks such as exporting and importing data, running SQL commands, and generating DDL scripts. Both tools can help you migrate your database objects and data to a different instance or workspace. References: Using SQL Developer to Migrate Your Oracle Database and Using Data Workshop to Manage Data
質問 # 76
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You can modify the data in the report after running the app
- B. You can customize the pagination
- C. You cannot modify the report source query
- D. You can customize the Actions menu to include or exclude certain options.
正解：A、B
質問 # 77
Developers can use Template Options in which of the following ways?
- A. Displaying form fields with different alignments
- B. Applying different colors or accents
- C. Applying different spacing and padding
- D. Rendering buttons in different styles, with and without icons
- E. All of them
正解：E
解説：
Explanation
Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways:
Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions.
Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page.
Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports.
Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.
質問 # 78
Which two statements are true about Maps in Oracle APEX?
- A. Background maps do not require any API keys.
- B. Heat Map and Polygons are not supported Spatial geometry objects
- C. Maps support REST Enabled SQL
- D. Maps don't support REST Data Sources
正解：A、C
解説：
Explanation
A map is a type of component that enables you to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
質問 # 79
Choose the three correct statements about Charts in APEX.
- A. You can create charts without using Oracle JET
- B. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
- C. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
- D. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
正解：B、C、D
解説：
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.
質問 # 80
Which two among the following are TRUE about Low Code Apps?
- A. Scalable
- B. Provide Rich Functionality with Less Code
- C. Expensive
- D. Not Mobile Friendly
正解：A、B
解説：
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
質問 # 81
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. Actions
- B. Parameters
- C. Task Settings
- D. Particpants
- E. All of them
正解：E
解説：
Explanation
Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions. Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes. Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.
質問 # 82
In APEX, you can choose which three of the following Authentication methods?
- A. Built-in Authentication Scheme
- B. Authorization Scheme
- C. Custom Authentication Scheme
- D. No Authentication
正解：A、C、D
解説：
Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.
質問 # 83
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. Create a database link to the remote Oracle Database in the local APEX Schema.
- B. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
- C. On the remote Oracle Database, install ORDS 19.x or later.
- D. Install Oracle APEX in the remote Oracle Database.
正解：B、C
解説：
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]
質問 # 84
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
- A. End user can rearrange the report interactively using the mouse.
- B. End user can save the report
- C. End user can customize how and what data is displayed.
- D. End user can add, modify, and refresh data directly on the report.
正解：C、D
解説：
Explanation
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]
質問 # 85
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
- A. Popup LOV
- B. Dynamic LOV
- C. Static LOV
- D. Cascading LOV
正解：D
解説：
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
質問 # 86
Which three of the following statements are TRUE about Data Synchronization?
- A. You must trigger Data Synchronization manually
- B. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.
- C. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.
- D. Helps in Providing efficient reporting on large data sets coming from a REST service
正解：B、C、D
解説：
Explanation
Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:
APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.
Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries. In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.
Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic. If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.
You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.
質問 # 87
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 disable the Batch Facet Changes attribute
- D. 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.
正解：C
解説：
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]
質問 # 88
In a Classic Report, an end user can perform which two of the following actions?
- A. Rearrange the columns in the report
- B. Create Control Breaks in the report
- C. Filter values of a column in the report
- D. Sort the columns of the report
正解：C、D
解説：
Explanation
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]
質問 # 89
......
無料1Z0-770試験問題集試験点数を伸ばそう：https://jp.fast2test.com/1Z0-770-premium-file.html