[2024年11月17日] 最新でリアルな1Z0-770試験問題集解答
あなたを簡単に合格させる1Z0-770試験問と正確なOracle APEX Developer ProfessionalのPDF問題
1Z0-770試験の準備をするには、候補者は頂点アーキテクチャ、セキュリティ、データモデリング、Webサービス、およびSQLを強く理解する必要があります。また、APEXを使用してWebアプリケーションを設計および開発する実践的な経験が必要です。 Oracleは、オンラインコース、ワークショップ、練習試験など、候補者が試験の準備を支援するためのいくつかのトレーニングコースとリソースを提供しています。
試験は80問の択一形式問題から構成され、105分以内に解答する必要があります。問題は、Oracle APEXの知識とその知識を現実世界のシナリオに適用する能力を試験するように設計されています。この試験は、世界中のPearson VUEテストセンターで受験することができます。
質問 # 48
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?
- A. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
- B. Set EMPNO, ENAME to "Display Only".
- C. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
- D. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
正解：A、D
解説：
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
To make an employee's commission editable in the grid, you need to perform two actions:
In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to
"Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid. Verified References: [Managing Interactive Grids - Oracle Help Center], [Interactive Grid Attributes - Oracle Help Center]
質問 # 49
To create a Dynamic Action, you need to specify which three of the following options?
- A. What action or actions are performed
- B. When the action occurs
- C. What elements are affected by the action
- D. Why the action is performed
正解：A、B、C
解説：
Explanation
To create a dynamic action, you need to specify at least three options: what action or actions are performed, when the action occurs, and what elements are affected by the action1. The action is the behavior that you want to happen when the event is triggered. You can choose from a list of predefined actions or create your own custom action using JavaScript code1. The event is the user interaction or condition that causes the dynamic action to fire. You can select an event from a list of available events based on the type of element you select1. The affected elements are the items, buttons, or regions that are affected by the action. You can select one or more elements by using jQuery selectors1. You do not need to specify why the action is performed, as this is not a required option for creating a dynamic action.
質問 # 50
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Create and view database objects
- C. Run SQL commands and scripts
- D. Delete database
正解：B、C
解説：
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]
質問 # 51
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. Drill down Master Detail
- B. Side by Side Master Detail
- C. Stacked Master Detail
- D. Editable Interactive Grid
正解：A
解説：
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]
質問 # 52
Which two statements are true about creating and using dynamic actions?
- A. Once you create a dynamic action, you cannot add additional true actions.
- B. If no client-side condition is defined, true actions will not fire.
- C. 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
- D. You can execute JavaScript code by creating a dynamic action.
正解：C、D
解説：
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]
質問 # 53
Which two statements are true about Maps in Oracle APEX?
- A. Maps don't support REST Data Sources
- B. Background maps do not require any API keys.
- C. Heat Map and Polygons are not supported Spatial geometry objects
- D. Maps support REST Enabled SQL
正解：B、D
解説：
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.
質問 # 54
Which statement is true about Unified Task List in the Approvals component?
- A. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
- B. It is a shared component used to configure task parameters, participants, actions, and due dates.
- C. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
正解：A
解説：
Explanation
The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users.
The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.
Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]
質問 # 55
What are the three features of a calendar in APEX?
- A. Next - Navigates to the next month.
- B. Month, Week, Day - Displays a monthly, weekly and daily view.
- C. Previous - Navigates to the previous month.
- D. Reminders - Displays the reminders set by the users
正解：A、B、C
解説：
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.
質問 # 56
Choose the three requirements for creating a REST Enabled SQL Reference.
- A. Activate REST Enabled SQL for the target schema on the remote database
- B. Set up any remote database
- C. Install Oracle REST Data Services (ORDS) 19.x or later.
- D. Configure and enable the REST Enabled SQL service feature
正解：A、C、D
解説：
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.
質問 # 57
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. Social Sign-In
- B. Open Door Credentials
- C. SAML Sign-In
- D. HTTP Header Variable
正解：A
解説：
Explanation
An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are:
HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server.
SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
Open Door Credentials: Enable anyone to access your application using a built-in login page that captures a user name. Verified References: [Understanding Preconfigured Authentication Schemes - Oracle Help Center], [Social Sign-In - Oracle Help Center]
質問 # 58
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?
- A. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
- B. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
- C. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
- D. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
正解：A
解説：
Explanation
d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this:
UPDATE events
SET start_date = :APEX.NEW_START_DATE,
end_date = :APEX.NEW_END_DATE
WHERE id = :APEX.PK_VALUE;
質問 # 59
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is
'Salesman'. This can be achieved by which feature of APEX?
- A. Dynamic Actions
- B. Processing
- C. PL/SQL procedure
- D. Conditional SQL
正解：A
解説：
Explanation
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by using Dynamic Actions in APEX. Dynamic Actions are declarative components that define client-side behavior without writing JavaScript code. You can create Dynamic Actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties. In this scenario, you can create a Dynamic Action on Job item with Change as event, Execute JavaScript Code as action, and use jQuery to enable or disable Commission and Hire Date fields based on Job value. Processing, Conditional SQL, and PL/SQL procedure are not features of APEX that can achieve this requirement without writing JavaScript code.
質問 # 60
Which statement is true about using SQL Commands?
- A. In SQL Commands, you can view queries saved in Query Builder.
- B. You can search and filter database objects.
- C. You can unload data from the database.
- D. You can design and prototype data models using a markdown-like shorthand syntax.
正解：C
解説：
Explanation
Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34
質問 # 61
Which statement is true about using the App Gallery?
- A. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
- D. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
正解：B
解説：
Explanation
Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
質問 # 62
Which of the following are preconfigured authentication schemes?
- A. All of them
- B. Social Sign In
- C. Open Door Credentials
- D. LDAP Directory
- E. HTTP Header Variables
正解：A
解説：
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.
質問 # 63
What are the two primary ways to move database objects and data from one environment toanother, for a single application?
- A. SQL Workshop
- B. Oracle SQL Developer
- C. App Builder
- D. Page Designer
正解：A、B
解説：
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
質問 # 64
Which statement is true about importing an APEX application?
- A. The import process does not import the supporting objects defined during the export.
- B. You cannot import an APEX application exported from a latest APEX version to an old APEX version.
- C. You cannot change the application ID during the import process.
正解：B
解説：
Explanation
As a general rule, you cannot import an application created in a newer release of APEX into an earlier version.
This is because the newer release may have features or attributes that are not supported or recognized by the older version. For example, you cannot import an application created in APEX 21.2 into APEX 19.2.
However, you can import an application created in an older release into a newer one, as long as the application is compatible with the newer release. For example, you can import an application created in APEX 18.2 into APEX 21.2, but you may need to upgrade or modify some components to use the latest features.
質問 # 65
Which two are valid evaluation points for Authorization Schemes?
- A. Once per session
- B. Once per user
- C. Once per page view
- D. Never
正解：C、D
解説：
Explanation
An authorization scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authorization scheme can be evaluated at different points in time depending on its evaluation point attribute. The valid evaluation points for authorization schemes are:
Never: The authorization scheme is never evaluated and always returns false.
Once per session: The authorization scheme is evaluated only once per user session and caches the result for subsequent requests.
Once per page view: The authorization scheme is evaluated once per page view and caches the result for subsequent requests within the same page view.
On each new page view or partial page refresh: The authorization scheme is evaluated on each new page view or partial page refresh (for example, when using dynamic actions) and caches the result until the next page view or partial page refresh.
On each request (not cached): The authorization scheme is evaluated on each request and does not cache the result. Once per user and Once per page load are not valid evaluation points for authorization schemes. Verified References: [Creating Authorization Schemes - Oracle Help Center], [Authorization Scheme Attributes - Oracle Help Center]
質問 # 66
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Amazon RDS
- B. Oracle XE
- C. All of the above
- D. Oracle Autonomous Cloud
- E. Microsoft Azure
正解：C
解説：
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
質問 # 67
......
Oracle 1Z0-770認定試験に備えるためには、SQLとPL/SQLの強い理解、およびOracleデータベースの経験が推奨されます。さらに、Oracleは、練習問題を含むトレーニングコースや学習資料を提供して、試験に備えるための支援を行っています。
更新された1Z0-770試験練習テスト問題：https://jp.fast2test.com/1Z0-770-premium-file.html