[2023年12月10日] 最新1z1-770試験問題集には高得点で一発合格 [Q55-Q70]

Share

[2023年12月10日] 最新1z1-770試験問題集には高得点で一発合格

無料提供中1z1-770ブレーン問題集と1z1-770リアル試験問題


Oracle 1Z0-770、またはOracle APEX Developer Professional Certification Examとしても知られる試験は、Oracle Corporationが提供するプロフェッショナルレベルの認定試験です。試験は、Oracle Application Express(APEX)を使用してWebベースのアプリケーションを開発および展開する専門家の知識とスキルを検証するために設計されています。試験に合格すると、業界で広く認知されているOracle APEX Developer Professional認定を取得できます。

 

質問 # 55
Choose the three different ways in which you can add a checkbox to a page.

  • A. Use the context sensitive menu in the Gallery pane.
  • B. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
  • C. Add a checkbox from the Property Editor
  • D. Drag and drop the checkbox item into the Layout pane

正解:A、B、D

解説:
Explanation
There are three different ways in which you can add a checkbox to a page in APEX:
Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.
Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.


質問 # 56
Which two statements that are TRUE about charts in Interactive grid?

  • A. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
  • B. Once the chart is created, it cannot be reconfigured.
  • C. Once a chart is created, you can switch the view between Grid and Chart view.
  • D. You can create multiple charts at a time in an interactive grid

正解:A、C

解説:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid


質問 # 57
Which two types of pages behave similarly in functionality?

  • A. Cards
  • B. Faceted Search
  • C. Map
  • D. Smart Filter

正解:B、D

解説:
Explanation
A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:
A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.
The other options are incorrect because:
A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.
Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]


質問 # 58
Which statement is true about using the App Gallery?

  • A. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
  • B. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
  • C. Custom Apps are only available if your instance administrator has enabled them.
  • D. You cannot install Sample Apps and Starter Apps directly from the Gallery.

正解:C

解説:
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


質問 # 59
Which two statements are true about REST Data Source Synchronization?

  • A. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
  • B. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
  • C. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
  • D. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
  • E. 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.

正解:D、E

解説:
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


質問 # 60
The Page Designer Toolbar allows you to perform which two of the following actions?

  • A. Create a new page
  • B. Delete the application
  • C. Export the application
  • D. Navigate to Shared Components

正解:A、D

解説:
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.


質問 # 61
Which two are true about Oracle APEX?

  • A. Requires no additional client software. A web browser is the app development IDE.
  • B. Performs the data processing in a middle-tier server
  • C. Is declarative. It requires no code generation.
  • D. Requires developers to be proficient in Java, Python and other programming languages.

正解:A、C

解説:
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]


質問 # 62
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?

  • A. As Private only
  • B. As Public only
  • C. As Primary only
  • D. As Private and public only

正解:D

解説:
Explanation
When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids
- Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]


質問 # 63
Which is NOT a valid Geometry Column Data Type available for maps region?

  • A. SDO_GEOMETRY
  • B. JSON_OBJECT
  • C. GeoJSON
  • D. Latitude/Longitude

正解:B

解説:
Explanation
The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database.
Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region. Verified References: About Supported MapsEditing Maps


質問 # 64
In a Classic Report, an end user can perform which two of the following actions?

  • A. Filter values of a column in the report
  • B. Create Control Breaks in the report
  • C. Rearrange the columns in the report
  • D. Sort the columns of the report

正解:A、D

解説:
Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]


質問 # 65
Which statement is true about the Data Workshop utility?

  • A. You can load or unload multiple tables at a time.
  • B. The wizards load and unload table data only.
  • C. You cannot load data from an XLSX file with multiple worksheets.
  • D. The wizards load and unload all types of schema objects.

正解:B

解説:
Explanation
Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop - Oracle Help Center], [Loading Data - Oracle Help Center]


質問 # 66
You can create a report in which of the three following methods?

  • A. Create a report when you create a new database application
  • B. Create a report as a new page in an application
  • C. Create a report region on a page in an application
  • D. Create a report from Object Browser

正解:A、B、C

解説:
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]


質問 # 67
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. You must trigger Data Synchronization manually
  • D. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.

正解:A、B、D

解説:
Explanation
Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:
APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.
Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries. In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.
Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic. If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.
You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.


質問 # 68
Which two statements are true about creating and using an interactive report?

  • A. You cannot customize the Search Button Label.
  • B. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
  • C. You cannot restrict users from saving private reports by using the Authorization Scheme.
  • D. You can specify an Authorization Scheme at the column level.

正解:A、D


質問 # 69
In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?

  • A. Cards
  • B. Unified Task List
  • C. Interactive Grid
  • D. Master Detail

正解:A

解説:
Explanation
Cards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way1 Verified References: 1: Understanding Page Types, Features, and Settings - Oracle Help Center


質問 # 70
......


Oracle 1Z0-770の認定は、APEX開発者がキャリアアップし、雇用主やクライアントに対して専門知識を示すための貴重な資格です。この認定は、ビジネス要件を満たし、他のOracleテクノロジーと統合されたAPEXアプリケーションを設計、開発、展開できる候補者の能力を示します。認定されたプロフェッショナルは、APEX開発のベストプラクティスに関する知識と、APEXアプリケーションのトラブルシューティングと問題解決能力に対しても認められます。


Oracle 1Z0-770(Oracle Apex Developer Professional)試験は、Oracle Application Express(APEX)テクノロジーで働く専門家のスキルと知識をテストするために設計された認定試験です。 Apexは、開発者がSQLとPL/SQLを使用して迅速かつ効率的にWebベースのアプリケーションを構築できるようにする低コード開発プラットフォームです。この試験は、Apexの経験があり、Apexアプリケーションの設計、開発、展開の習熟度を実証したい専門家向けです。

 

1z1-770合格させる問題集でOracle24時間で試験合格できます:https://www.passtest.jp/Oracle/1z1-770-shiken.html

Oracle 1z1-770実際の問題とブレーン問題集:https://drive.google.com/open?id=1z-sf7THHtg1lsL5Y-U2lQBOuFxLhBuws