最新の無料1Z0-770効率的問題集をダウンロード2024年08月24日更新された144問がある
Oracle 1Z0-770試験練習テスト解答
Oracle 1Z0-770試験は、APEXアーキテクチャ、セキュリティ、データモデリング、ユーザーインターフェース開発、アプリケーション展開など、幅広いトピックをカバーしています。この試験は、105分以内に完了する必要がある60問の選択式問題で構成されています。この試験の合格スコアは63％です。
Oracle 1Z0-770 認定試験は、Oracle Application Express（APEX）開発の専門知識を検証するために設計されたプロフェッショナルレベルの試験です。この試験は、Oracleデータベース技術の競争が激しい分野で際立つために必要な認定資格です。この試験に合格することで、プロフェッショナルは、Oracle APEX開発で使用される最新の技術とプログラミング手法に熟練していることを簡単に証明できます。
質問 # 60
Which two statements are true about REST Data Sources?
- A. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- B. REST Data Sources doesn't support any authentication
- 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]
質問 # 61
Which two layout options are available for Page Designer under Utilities?
- A. Single Pane Mode
- B. Four Pane Mode
- C. Three Pane Mode
- D. Two Pane Mode
正解：A、D
解説：
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]
質問 # 62
Which three of the following are use cases of Automations?
- A. Deleting a database record based on an end user's request
- B. Approving specific requests
- C. Sending email alerts at a particular time of the week
- D. Monitoring log tables and raising an alert when there is an issue
正解：B、C、D
解説：
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
質問 # 63
The APEX engine uses which component as a key for tracking each user's session state?
- A. LDAP_USER
- B. HTTP_USER
- C. APP_USER
- D. APEX_USER
正解：C
解説：
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.
質問 # 64
Which two statements are true about REST Data Source Synchronization?
- A. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
- B. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
- C. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
- D. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
- E. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
正解：A、B
解説：
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs
質問 # 65
What are the required fields while creating a Chart in APEX?
- A. Label Column
- B. All of them
- C. Name
- D. Data Source
- E. Value Column
正解：B
解説：
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.
質問 # 66
You can apply an authorization scheme for which three of the following components?
- A. A session
- B. A page
- C. An entire application
- D. Specific control such as region,item or button
正解：B、C、D
解説：
Explanation
You can apply an authorization scheme for the following components in APEX:
A specific control such as a region, item, or button. You can select an authorization scheme from the Authorization Scheme list on the attributes page of the control. This will control the rendering and processing of the control based on the user privileges12.
A page. You can select an authorization scheme from the Authorization Scheme list on the Security page of the page definition. This will control the access to the page based on the user privileges12.
An entire application. You can select an authorization scheme from the Authorization Scheme list on the Security Attributes page of the application definition. This will control the access to the entire application based on the user privileges12.
You cannot apply an authorization scheme for a session, as a session is not a component in APEX. A session is a stateful connection between a browser and the APEX engine that persists across multiple requests and responses3. You can control session security by using session state protection, session expiration, and session isolation4.
質問 # 67
Which two are valid evaluation points for Authorization Schemes?
- A. Once per page view
- B. Once per user
- C. Never
- D. Once per session
正解：A、C
解説：
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]
質問 # 68
Choose the two statements that are TRUE about the Universal Theme in APEX.
- A. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
- B. Not designed to work on tablets
- C. Responsive UI
- D. Easy customization
正解：C、D
解説：
Explanation
The Universal Theme is a responsive user interface design for Oracle APEX applications. It has the following features:
Responsive UI: The Universal Theme uses responsive design techniques to adapt to different screen sizes and orientations. It ensures that your applications look great and work well on any device, such as desktops, laptops, tablets, or smartphones.
Easy customization: The Universal Theme allows you to customize the appearance and behavior of your applications using various tools and options. You can use Theme Roller to change the colors, fonts, icons, and styles of your applications. You can also use Template Options to modify the layout and functionality of your components.
The other options are incorrect because:
Not designed to work on tablets: The Universal Theme is designed to work on tablets as well as other devices. It uses responsive design techniques to adapt to different screen sizes and orientations.
The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme: The developers do not need to have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. They can use declarative tools such as Theme Roller and Template Options to customize their applications without coding.
Verified References: [About Universal Theme] [Using Theme Roller] [Using Template Options]
質問 # 69
Which two Plugin types can be created in Oracle APEX?
- A. Validation
- B. Region
- C. Email Template
- D. Process
正解：B、D
解説：
Explanation
A plugin is a component that extends the native functionality of Oracle APEX by allowing developers to create custom components using SQL, PL/SQL, HTML, CSS, and JavaScript. A plugin can be created for any of the following component types: Dynamic Action, Item, Process, Region, Report Layout, Authentication Scheme, Authorization Scheme, or Data Load Method. A process plugin is a custom process type that can be executed when a page is submitted or loaded. A region plugin is a custom region type that can display data or content on a page. Verified References: [Creating Plugins - Oracle Help Center], [Plugin Concepts - Oracle Help Center]
質問 # 70
Which three of the following statements are TRUE about saved Public Interactive Grids?
- A. Only the user who creates a public interactive grid can save, rename, or delete it
- B. To enable an end user to save a public interactive grid, the user must have the required permission
- C. Any user may save public interactive grids
- D. Public reports are available to all users
正解：A、B、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
質問 # 71
Developers can use Template Options in which of the following ways?
- A. All of them
- B. Rendering buttons in different styles, with and without icons
- C. Applying different colors or accents
- D. Displaying form fields with different alignments
- E. Applying different spacing and padding
正解：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.
質問 # 72
Which two statements are true about creating and customizing Smart Filters pages?
- A. The search results report can be displayed as an interactive report.
- B. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
- C. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
- D. The search results report can be displayed as an interactive grid
正解：B、C
解説：
Explanation
Smart Filters is a component that allows end users to filter data by typing keywords in a single search field.
Some of the statements that are true about creating and customizing Smart Filters pages are:
If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.
The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center],
[Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]
質問 # 73
Select the two places from where you can access the Shared Components Page?
- A. Gallery
- B. Application homepage
- C. Page Designer
- D. SQL Workshop
正解：B、C
解説：
Explanation
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.
質問 # 74
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle XE
- B. Microsoft Azure
- C. All of the above
- D. Oracle Autonomous Cloud
- E. Amazon RDS
正解：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
質問 # 75
What are the three key features of Universal Theme?
- A. Support for single theme
- B. Versatile UI Components
- C. Responsive Design
- D. Easy Customization
正解：B、C、D
解説：
Explanation
Universal Theme has many features that make it an ideal user interface for Oracle APEX applications. Three of the key features of Universal Theme are:
Versatile UI Components: Universal Theme provides a rich set of UI components that can be used to create interactive and engaging applications. Some of the UI components include cards, lists, charts, calendars, maps, timelines, accordions, tabs, modals, alerts, and more.
Responsive Design: Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It ensures that the applications look good and work well on any device, from desktops to tablets to smartphones.
Easy Customization: Universal Theme allows developers to customize the appearance and behavior of their applications using template options and theme styles. Template options enable developers to apply different styles to components on a page without writing custom code. Theme styles enable developers to change the overall look and feel of the application by choosing from a variety of pre-built styles or creating their own.
質問 # 76
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?
- A. Non-Modal Dialog
- B. Normal Page
- C. Help Page
- D. Modal Dialog
正解：D
解説：
Explanation
A modal dialog is a type of page mode that displays an overlay window within the viewport when a button is pressed. A modal dialog is a stand-alone page that does not interact with the base page where it was launched.
A modal dialog blocks access to the base page until it is closed by the user. A modal dialog can be used for various purposes, such as displaying additional information, confirming an action, or collecting user input.
質問 # 77
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. Default report
- D. Cannot save the report
正解：A、B
質問 # 78
......
最新の検証済み1Z0-770問題集と解答合格保証もしくは全額返金です：https://jp.fast2test.com/1Z0-770-premium-file.html