[2025年04月]に更新されたOracle Database 1Z0-770試験練習テスト問題集豪華セット！
2025年最新のに更新された1Z0-770のPDFは1Z0-770本日更新のテスト無料最新！
Oracle 1Z0-770（Oracle Apex Developer Professional）試験は、Oracle Application Express（APEX）テクノロジーで働く専門家のスキルと知識をテストするために設計された認定試験です。 Apexは、開発者がSQLとPL/SQLを使用して迅速かつ効率的にWebベースのアプリケーションを構築できるようにする低コード開発プラットフォームです。この試験は、Apexの経験があり、Apexアプリケーションの設計、開発、展開の習熟度を実証したい専門家向けです。
質問 # 61
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 APEXSNEW_END_DATE
- B. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
- C. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
- D. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
正解：D
解説：
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;
質問 # 62
Which three of the following statements are TRUE about Data Synchronization?
- A. Helps in Providing efficient reporting on large data sets coming from a REST service
- 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. You must trigger Data Synchronization manually
正解：A、B、C
解説：
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.
質問 # 63
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. Set EMPNO, ENAME to "Display Only".
- B. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
- C. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
- D. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
正解：B、C
解説：
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]
質問 # 64
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?
- A. Popup LOV
- B. Checkbox Group
- C. Range
- D. Date Picker
正解：B、C
解説：
Explanation
In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types.
Verified References: [Faceted Search Attributes - Oracle Help Center], [Facet Item Types - Oracle APEX]
質問 # 65
Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?
- A. It will restrict acceptable values to Y or N.
- B. It will restrict acceptable values to TRUE or FALSE.
- C. It will default to FALSE.
- D. It will default to TRUE.
正解：B
解説：
Explanation
The commission yn column will restrict acceptable values to TRUE or FALSE because of the /check modifier in the column name. This modifier adds a check constraint to the column based on the values specified after it.
The yn suffix indicates that the column is of type VARCHAR2(1). The other options are incorrect because they do not reflect the effect of the /check modifier or the yn suffix. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax
質問 # 66
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
正解：C、D
解説：
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]
質問 # 67
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?
- A. Setting the Hide and Show Behavior attribute value to Rescale
- B. Setting the Hide and Show Behavior attribute value to No Rescaling
- C. Setting the Hide and Show Behavior attribute value to None
- D. Setting the on Data Change attribute value to slide to Left
正解：A、B
解説：
Explanation
A bar chart is a type of chart that displays data as horizontal or vertical bars with lengths proportional to the values they represent. A bar chart can have one or more data series, which are groups of data points that share the same color and legend item. To enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked, you need to set the Hide and Show Behavior attribute value to either Rescale or No Rescaling. The Hide and Show Behavior attribute determines how the chart behaves when a data series is hidden or shown by clicking on its legend item. The possible values are:
None: The chart does not support hiding or showing data series by clicking on legend items.
Rescale: The chart supports hiding or showing data series by clicking on legend items, and rescales the axes accordingly.
No Rescaling: The chart supports hiding or showing data series by clicking on legend items, but does not rescale the axes. Setting the on Data Change attribute value to slide to Left will not affect the "hide and show" behavior of a data series in a bar chart. This attribute determines how the chart behaves when new data is loaded, such as when using dynamic actions or refresh actions. The possible values are:
None: The chart does not animate when new data is loaded.
Slide to Left: The chart slides to the left when new data is loaded.
Slide to Right: The chart slides to the right when new data is loaded. Verified References: [Creating Bar Charts - Oracle Help Center], [Bar Chart Attributes - Oracle Help Center]
質問 # 68
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Create new application roles
- B. Add Users
- C. Create Authorization schemes
- D. Assign roles to users
正解：B、D
解説：
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]
質問 # 69
What are the three features of a calendar in APEX?
- A. Month, Week, Day - Displays a monthly, weekly and daily view.
- B. Reminders - Displays the reminders set by the users
- C. Previous - Navigates to the previous month.
- D. Next - Navigates to the next month.
正解：A、C、D
解説：
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.
質問 # 70
Developers can use Template Options in which of the following ways?
- A. Applying different colors or accents
- B. Displaying form fields with different alignments
- 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.
質問 # 71
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. SQL Query
- B. Procedure
- C. Function Returning SQL Query
- D. Select List
正解：A、C
解説：
Explanation
The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists
質問 # 72
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page compilation
- B. Page Processing
- C. Page Rendering
- D. Page rendering and processing
正解：D
解説：
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
質問 # 73
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. Parameters
- B. Particpants
- C. Actions
- D. Task Settings
- 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.
質問 # 74
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the images
- B. Move the application definition and all associated files
- C. Move the sessions data
- D. Move the database objects
正解：A、B、D
解説：
Explanation
To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.
質問 # 75
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. 13766599855150 is the session ID. A new ID is generated for each session.
- B. update-employees is the PL/SQL procedure to update the employee details.
- C. session=13766599855150 Ahr-app is the application alias.
- D. mycompany is the path-prefix which is by default the workspace name
正解：A、C、D
解説：
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]
質問 # 76
Which two statements are true about Faceted Search pages?
- A. Multiple charts are not visible in the same region.
- B. Facets map to specific database columns.
- C. A facet's chart can be seen only in a nonmodal dialog.
- D. Faceted Search supports the ability to filter columns storing multiple values as one string.
正解：B、D
解説：
Explanation
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]
質問 # 77
Which two statements are TRUE about Dynamic Actions?
- A. More dynamic actions you add to a page, the greater your overall page size.
- B. Dynamic Actions require complex client side Javascript code
- C. It is not possible to debug Dynamic Actions from the Developer Toolbar
- D. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
正解：A、D
解説：
Explanation
Dynamic actions provide a way to define complex client-side behavior declaratively without the need for JavaScript. You can create dynamic actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties1. However, more dynamic actions you add to a page, the greater your overall page size. This can affect the performance and user experience of your application2. It is possible to debug dynamic actions from the Developer Toolbar by using the Debug option3. Dynamic actions do not require complex client-side JavaScript code, but they can optionally include custom JavaScript code as an action or a condition1.
質問 # 78
Which is a valid method of logging messages to the execution log in APEX automation?
- A. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
- B. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
- C. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
正解：C
解説：
Explanation
APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center],
[APEX_DEBUG - Oracle Help Center]
質問 # 79
Choose from the following the different kinds of page components you can create in APEX.
- A. Search Page
- B. Smart Filters
- C. Faceted Search
- D. Interactive Grid
- E. All of them
正解：E
解説：
Explanation
All of the options listed are different kinds of page components that you can create in APEX. A page component is an area of a page that serves as a container for content. Each page component contains a different type of content, such as HTML, a report, a form, a chart, a list, a breadcrumb, PL/SQL, a tree, a URL, or a calendar. You can create page components by using the Create Page Wizard, dragging and dropping from the Gallery pane in Page Designer, or using the context-sensitive menu in the Rendering tree in Page Designer.
質問 # 80
Select the three types of Facets you can create in APEX.
- A. Checkbox Group
- B. Text Area
- C. Range
- D. Input Field
正解：A、C、D
解説：
Explanation
A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:
Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
Input Field: An input field facet displays a text field that users can enter text to filter the search results.
An input field facet does not have any values but uses an operator to compare the user input with the data.
質問 # 81
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Hide
- B. Control Break
- C. Group By
- D. Delete
正解：A、B
解説：
Explanation
The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:
Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.
The other options are incorrect because:
Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.
Verified References: [Customizing Interactive Reports] [Column Heading Menu]
質問 # 82
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?
- A. Copying the changes made in the master theme to the copied theme
- B. Verifying the theme subscription
- C. Subscribing the copied theme to the master theme and refreshing the theme
- D. Refreshing the templates
正解：C
解説：
Explanation
A theme is a collection of templates and stylesheets that define the layout and appearance of an application.
You can create a custom theme for an application by using the Create Theme Wizard or by copying an existing theme. If you want to use a custom theme for anotherapplication in the same workspace, you can copy the theme to that application by using the Copy Theme option in Shared Components. However, if the master theme (the original theme) may still require changes, you need to subscribe the copied theme to the master theme and refresh the theme whenever there are changes in the master theme. This solution guarantees that any changes to the master theme are reflected in the copied theme by using a synchronization process that updates templates and stylesheets based on their subscription status. Verified References: [Creating Themes - Oracle Help Center], [Managing Theme Subscriptions - Oracle Help Center]
質問 # 83
Choose from the below options the actions that can be performed when a button is clicked.
- A. Redirect to a page in the same application
- B. Redirect to a page in a different application
- C. Redirect to a URL
- D. Submit Page
- E. All of them
正解：E
解説：
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.
質問 # 84
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You cannot modify the report source query
- B. You can customize the Actions menu to include or exclude certain options.
- C. You can customize the pagination
- D. You can modify the data in the report after running the app
正解：C、D
質問 # 85
......
Oracle 1Z0-770認定試験は、60の複数選択の質問で構成されるコンピューターベースの試験です。候補者は試験を完了するのに105分です。試験の合格スコアは63％であり、候補者は試験を完了した直後にスコアを受け取ります。この試験は英語で入手可能で、Oracle Testing Centersで世界中で提供されています。
全幅的な更新された問題集PDFのテスト1Z0-770試験問題とアンサー：https://www.jpntest.com/shiken/1Z0-770-mondaishu
100%無料1Z0-770試験問題集を試験簡単にパスせよ：https://drive.google.com/open?id=1IxtuinzwmovMUUG5JwBOG8Zn7QiVhTkL