無料Oracle 1Z0-770テスト練習問題試験問題集
試験準備には欠かさない！トップクラスのOracle 1Z0-770試験最新版アプリ学習ガイドで練習
Oracle 1Z0-770認定試験は、Oracle Application Express（APEX）開発の専門知識を実証したい専門家向けに設計されています。この試験は、SQLとPL/SQLの強力な知識を持っている個人と、APEXを使用したWebアプリケーションの開発の経験を対象としています。認定試験では、頂点アプリケーションの設計と構築、さまざまなソースからのデータの統合、セキュリティとユーザーアクセスの管理に関する候補者のスキルをテストします。
質問 # 40
Which three statements are TRUE about Search Configuration?
- A. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- B. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- C. One or more Search Configurations can be configured in a Search Page.
- D. Only one Search Configuration can be used in a Search Page.
正解：A、B、C
解説：
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
質問 # 41
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You can customize the pagination
- B. You cannot modify the report source query
- C. You can customize the Actions menu to include or exclude certain options.
- D. You can modify the data in the report after running the app
正解：A、D
質問 # 42
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.
質問 # 43
Which two feature pages can you create using the Create Page Wizard?
- A. Search Page
- B. Feedback
- C. Access Control
- D. Unified Task List
正解：B、C
解説：
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
質問 # 44
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. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
- B. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
- C. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
- D. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
正解：B
解説：
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;
質問 # 45
Which is a valid method of logging messages to the execution log in APEX automation?
- A. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
- B. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
- C. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
正解：B
解説：
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]
質問 # 46
You can create a report in which of the three following methods?
- A. Create a report region on a page in an application
- B. Create a report when you create a new database application
- C. Create a report from Object Browser
- D. Create a report as a new page in an application
正解：A、B、D
解説：
Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]
質問 # 47
What are the three types of Master Detail Form you can create in APEX?
- A. Side by Side
- B. Two Page Drill Down
- C. One Below the other
- D. Stacked
正解：A、B、D
解説：
Explanation
A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database.
Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:
Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.
質問 # 48
What are the three features of a calendar in APEX?
- A. Reminders - Displays the reminders set by the users
- B. Previous - Navigates to the previous month.
- C. Month, Week, Day - Displays a monthly, weekly and daily view.
- D. Next - Navigates to the next month.
正解：B、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.
質問 # 49
Which three are the main components of APEX workspace homepage?
- A. SQL Workshop
- B. App Builder
- C. RESTful Services
- D. Gallery
正解：A、B、D
解説：
Explanation
The main components of an APEX workspace homepage are:
Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.
SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.
App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.
The other option is incorrect because:
RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.
Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]
質問 # 50
Developers can use Template Options in which of the following ways?
- A. All of them
- B. Applying different spacing and padding
- C. Rendering buttons in different styles, with and without icons
- D. Displaying form fields with different alignments
- E. Applying different colors or accents
正解：A
解説：
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.
質問 # 51
Which two statements are true about creating and using dynamic actions?
- A. If no client-side condition is defined, true actions will not fire.
- B. You can execute JavaScript code by creating a dynamic action.
- 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. Once you create a dynamic action, you cannot add additional true actions.
正解：B、C
解説：
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]
質問 # 52
Choose the three supported spatial geometry objects in Maps.
- A. Bars
- B. Points
- C. Heat map
- D. Polygons
正解：B、C、D
解説：
Explanation
A map is a type of component that enables users 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. Three of the supported spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.
質問 # 53
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. APEX Workspace Admin credentials
- B. Database schema credentials
- C. PEX Developer credentials
正解：A
解説：
Explanation
The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One-Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]
質問 # 54
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 on Data Change attribute value to slide to Left
- D. Setting the Hide and Show Behavior attribute value to None
正解：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]
質問 # 55
Which two of the following types can an end user save the customized Interactive report as?
- A. A Public report
- B. A private report
- C. Cannot save the report
- D. Default report
正解：A、B
質問 # 56
Which two statements are true about the APEX MAIL API?
- A. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- B. You can add files as attachments to your emails using the APEX_MAIL package.
- C. The APEX_MAIL package supports sending emails only to Oracle database users.
- D. You can send emails using the APEX MAIL package from an Oracle APEX application.
正解：B、D
解説：
Explanation
The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:
You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails.
The files can be in various formats, such as PDF, DOCX, XLSX, etc.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]
質問 # 57
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. The Create Page Wizard doesn't support the creation of a classic report and formcombination
- C. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- D. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
正解：A
解説：
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]
質問 # 58
Which two statements are true about REST Data Sources?
- A. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- B. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
- C. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- D. REST Data Sources doesn't support any authentication
正解：A、B
解説：
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]
質問 # 59
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?
- A. Setting the value Required to Yes on P1_SALARY
- B. Setting Display Location to Inline in Notification
- C. Removing P1_SALARY from the validation Associated Item
正解：C
解説：
Explanation
A validation is a rule that checks the data entered by end users before processing it. A validation of type Item is numeric checks if a page item value is a valid number. When the page is submitted, if the validation fails, an error message is displayed both in the notification area (atthe top of the page) and below the item (next to the item label). To cause the validation error to appear only in the notification area, you need to remove P1_SALARY from the validation Associated Item attribute. The Associated Item attribute specifies which page item is associated with the validation and where to display the error message if the validation fails.
Setting the value Required to Yes on P1_SALARY or setting Display Location to Inline in Notification will not affect the validation error display. Verified References: [Creating Validations - Oracle Help Center],
[Validation Attributes - Oracle Help Center]
質問 # 60
Which three of the following statements are TRUE about saved Public Interactive Grids?
- A. Public reports are available to all users
- B. Any user may save public interactive grids
- C. To enable an end user to save a public interactive grid, the user must have the required permission
- D. Only the user who creates a public interactive grid can save, rename, or delete it
正解：A、C、D
解説：
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
質問 # 61
......
Oracle APEX Developer Professional 認定は、APEXを使用した堅牢でスケーラブルなアプリケーションの構築と展開に関する候補者の専門知識を検証します。APEXは、Webベースのアプリケーションを素早く簡単に作成できるローコード開発プラットフォームです。Webベースのアプリケーションに対する需要が増加する中、Oracle APEX Developer Professional 認定は、Web開発の分野でキャリアを進めたい開発者にとって貴重な資格となっています。また、この認定を取得することは、最新の技術と業界のベストプラクティスに継続的に取り組んでいることを示すものです。
今すぐ1Z0-770問題を使おう1Z0-770問題集PDF：https://www.jpntest.com/shiken/1Z0-770-mondaishu
問題集練習試験問題学習ガイドは1Z0-770試験にはこれ：https://drive.google.com/open?id=1meQJFgWT3ZI2KOuC3k-To60xalBsgwBL