[Q84-Q102] 1z1-770認定で究極のガイド [2024年更新]

Share

1z1-770認定で究極のガイド [2024年更新]

1z1-770練習試験と学習ガイドは厳密検証された


1Z0-770試験の準備をするには、候補者は頂点アーキテクチャ、セキュリティ、データモデリング、Webサービス、およびSQLを強く理解する必要があります。また、APEXを使用してWebアプリケーションを設計および開発する実践的な経験が必要です。 Oracleは、オンラインコース、ワークショップ、練習試験など、候補者が試験の準備を支援するためのいくつかのトレーニングコースとリソースを提供しています。


Oracle 1Z0-770認定試験は、105分以内に完了する60の複数選択質問で構成されています。この試験では、Apexアーキテクチャ、データモデリング、セキュリティ、ユーザーインターフェイス設計、アプリケーションの展開に関する候補者の知識を測定します。認定試験は提案されており、承認されたPearson Vue Testing Centerで世界中で撮影できます。試験に合格した候補者は、Oracle Apex Developer Professional Certificationを獲得します。

 

質問 # 84
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 doesn't provide direct integration of REST Data Sources in interactivereports
  • C. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
  • D. REST Data Sources doesn't support any authentication

正解：A、C

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


質問 # 85
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]


質問 # 86
Select two features of a Smart Filters Page.

  • A. Each filter represents the text entered by the end user in the search field
  • B. Consists of a single search field with filters at the top of the page and a report at the bottom
  • C. Consists of filters at the left side and report on the right side of the page
  • D. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs.

正解：B、D

解説：
Explanation
A smart filters page is a type of component that features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar) at the bottom. A smart filters page behaves similarly to faceted search, but it features a more space efficient layout. Two of the features of a smart filters page are:
Consists of a single search field with filters at the top of the page and a report at the bottom. This feature provides a simple and compact user interface that allows users to enter text in the search field and see suggested filters based on their input. Users can also see and modify applied filters at any time.
Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. This feature provides useful information to users about how many records match each filter value. Users can also choose between different types of suggestions, such as dynamic, static, or SQL query.


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

  • A. You can specify an Authorization Scheme at the column level.
  • 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 cannot customize the Search Button Label.

正解：A、D


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

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

正解：A、C、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.


質問 # 89
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. The APEX_MAIL package supports sending emails only to Oracle database users.
  • C. You can send emails using the APEX MAIL package from an Oracle APEX application.
  • D. You can add files as attachments to your emails using the APEX_MAIL package.

正解：C、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]


質問 # 90
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?

  • A. Open Door Credentials
  • B. HTTP Header Variable
  • C. Social Sign-In
  • D. SAML Sign-In

正解：C

解説：
Explanation
An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are:
HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server.
SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
Open Door Credentials: Enable anyone to access your application using a built-in login page that captures a user name. Verified References: [Understanding Preconfigured Authentication Schemes - Oracle Help Center], [Social Sign-In - Oracle Help Center]


質問 # 91
From SQL Workshop, you can perform which two of the following actions?

  • A. Run SQL commands and scripts
  • B. Create an APEX user
  • C. Delete database
  • D. Create and view database objects

正解：A、D

解説：
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]


質問 # 92
Which three statements are TRUE about Shared Components?

  • A. Once you create a Shared Component, you can add them to any page within an APEX application in any workspace.
  • B. Shared components are common elements that can be displayed or applied on any page within an application
  • C. Once you create a Shared Component, you can add them to any page within your APEX application
  • D. Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components

正解：B、C、D

解説：
Explanation
Shared components are common elements that can be displayed or applied on any page within an application.
Once you create a shared component, you can add them to any page within your APEX application. However, shared components are specific to each application and workspace, so you cannot add them to any page in any workspace4. Breadcrumbs, lists, and navigation bar entries are examples of shared components that can be used for navigation purposes4.


質問 # 93
Select the three ways in which you can create a Form in APEX.

  • A. Using the Create Page wizard
  • B. Create a Form region in Page Designer
  • C. Using the Create Application Wizard
  • D. Using Shared Components

正解：A、B、C

解説：
Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.


質問 # 94
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?

  • A. Non-Modal Dialog
  • B. Help Page
  • C. Normal 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.


質問 # 95
Which three of the following options are TRUE about a page in an APEX application?

  • A. An APEX application can have only one page.
  • B. A page can contain buttons, page items and regions.
  • C. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
  • D. A page can be viewed and edited in the Page Designer.

正解：B、C、D


質問 # 96
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?

  • A. Standard
  • B. List
  • C. Oracle Text

正解：C

解説：
Explanation
Search Configurations is a feature that allows developers to define how end users can search for data in an application. There are three types of search configurations: Standard, List, and Oracle Text. Oracle Text is a search type that provides linguistic and fuzzy search capabilities by using an Oracle Text index on a table column or view column. Linguistic search enables end users to search for data based on language-specific rules and preferences, such as stemming, stopwords, synonyms, etc. Fuzzy search enables end users to search for data based on approximate matches that account for spelling errors, typos, OCR errors, etc. Verified References: [Managing Search Configurations - Oracle Help Center], [Oracle Text User's Guide]


質問 # 97
Plug-ins can be used declaratively in which of the following components in APEX?

  • A. Items
  • B. All of them
  • C. Process Type
  • D. Dynamic Actions
  • E. Regions

正解：B

解説：
Explanation
Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.


質問 # 98
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?

  • A. Join me in congratulating :P1 ENAME as the new employee of the month!
  • B. Join me in congratulating v('P1_ENAME') as the new employee of the month!
  • C. Join me in congratulating &P1 ENAME, as the new employee of the month!

正解：C

解説：
Explanation
A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions. Verified References: [Creating Static Content Regions - Oracle Help Center], [Understanding Substitution Strings - Oracle Help Center]


質問 # 99
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

  • A. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
  • B. Install Oracle APEX in the remote Oracle Database.
  • C. On the remote Oracle Database, install ORDS 19.x or later.
  • D. Create a database link to the remote Oracle Database in the local APEX Schema.

正解：A、C

解説：
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]


質問 # 100
Which two statements are true about the Create Application Wizard?

  • A. It allows the application authorization to be changed
  • B. It allows application pages to be reordered.
  • C. It allows the uploading of JavaScript or CSS files required for an application.
  • D. It allows application pages to be added or deleted.

正解：B、D

解説：
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]


質問 # 101
Which two statements are true about a Progressive Web Application (PWA)?

  • A. PWA features will be rendered even if the application is served in an unsecured environment.
  • B. You can create a PWA only when creating a new application with the Create Application Wizard.
  • C. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
  • D. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
  • E. Enabling the PWA functionality optimizes page loading speed on a mobile device.

正解：D、E

解説：
Explanation
A Progressive Web Application (PWA) is a web application that uses modern web technologies and best practices to provide a native app-like experience to users. Enabling the PWA functionality in your APEX app has the following benefits:
It optimizes page loading speed on a mobile device by caching static resources and using service workers to handle network requests.
It adds a new navigation bar entry named Install App to your app, which allows users to install the app on their device's home screen and access it offline.
It enhances the app's appearance and behavior by using a manifest file to specify the app's name, icon, theme color, orientation, and display mode.
The other options are incorrect because:
To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned On. This attribute enables user-friendly URLs that are required for PWA functionality.
PWA features will not be rendered if the application is served in an unsecured environment. The application must use HTTPS protocol to enable PWA functionality.
You can create a PWA from an existing application or a new application with the Create Application Wizard. You just need to enable the PWA functionality in the User Interface section of the Application Definition.
Verified References: Progressive Web ApplicationsEnabling Progressive Web Application Functionality


質問 # 102
......


Oracle 1Z0-770試験に合格した候補者は、Oracle APEX Developer Professional認定を受けることができます。この認定は世界的に認められており、Oracle APEX開発の専門知識を潜在的な雇用主に示すために使用することができます。さらに、この認定は2年ごとに更新する必要があり、最新のAPEX開発の変更やトレンドについて常に最新情報を得る必要があります。結論として、Oracle 1Z0-770（Oracle APEX Developer Professional）試験は、Oracle APEX開発の専門家を認定するために設計された業界標準の認定試験であり、真剣にOracle APEX開発者としてキャリアアップを目指す人にとって不可欠な部分です。

 

究極のガイドは1z1-770最新時間限定！今すぐダウンロード！：https://www.goshiken.com/Oracle/1z1-770-mondaishu.html

関するブログ

もっと
1z1-770無料問題集