Oracle 1z1-770リアル試験問題テストエンジン問題集トレーニングには144問あります
1z1-770実際の問題解答PDFには100%カバー率リアル試験問題
Oracle 1Z0-770、またはOracle APEX Developer Professional Certification Examとしても知られる試験は、Oracle Corporationが提供するプロフェッショナルレベルの認定試験です。試験は、Oracle Application Express（APEX）を使用してWebベースのアプリケーションを開発および展開する専門家の知識とスキルを検証するために設計されています。試験に合格すると、業界で広く認知されているOracle APEX Developer Professional認定を取得できます。
質問 # 86
Which three of the following are use cases of Automations?
- A. Monitoring log tables and raising an alert when there is an issue
- B. Deleting a database record based on an end user's request
- C. Approving specific requests
- D. Sending email alerts at a particular time of the week
正解：A、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.
質問 # 87
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. Create a database link to the remote Oracle Database in the local APEX Schema.
- C. Install Oracle APEX in the remote Oracle Database.
- D. On the remote Oracle Database, install ORDS 19.x or later.
正解：A、D
解説：
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]
質問 # 88
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 customize the Search Button Label.
- D. You cannot restrict users from saving private reports by using the Authorization Scheme.
正解：A、C
質問 # 89
You can create a report in which of the three following methods?
- A. Create a report from Object Browser
- B. Create a report when you create a new database application
- C. Create a report as a new page in an application
- D. Create a report region on a page in an application
正解：B、C、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]
質問 # 90
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Add Users
- B. Create new application roles
- C. Create Authorization schemes
- D. Assign roles to users
正解：A、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]
質問 # 91
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 v('P1_ENAME') as the new employee of the month!
- B. Join me in congratulating :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]
質問 # 92
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Navigate to Shared Components
- B. Export the application
- C. Delete the application
- D. Create a new page
正解：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.
質問 # 93
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 default to FALSE.
- B. It will restrict acceptable values to TRUE or FALSE.
- C. It will restrict acceptable values to Y or N.
- 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
質問 # 94
Using the App Builder component, you can perform which three tasks?
- A. Edit pages in the page designer
- B. Create a new App
- C. Install a sample App
- D. Run SQL scripts and commands
正解：A、B、C
解説：
Explanation
Using the App Builder component, you can perform the following tasks:
Edit pages in the page designer: You can use the Page Designer tool to modify the pages in your application using drag-and-drop operations, property editors, and code editors. You can also preview how your pages will look on different devices.
Install a sample app: You can use the Gallery option to install a sample app from a list of pre-built applications that demonstrate various features and best practices of Oracle APEX. You can also use the Packaged Apps option to install a packaged app from a list of ready-to-use applications that provide common functionality and solutions.
Create a new app: You can use the Create App option to create a new app from scratch or from an existing data source using the Create Application Wizard. You can also use the From a File option to create a new app from a file that contains data or metadata.
The other option is incorrect because:
Run SQL scripts and commands: You cannot use the App Builder component to run SQL scripts and commands. You can use the SQL Workshop component to run SQL scripts and commands using the SQL Commands or SQL Scripts tools.
Verified References: [About App Builder] [Using Page Designer] [Installing Sample Apps] [Installing Packaged Apps] [Creating Applications]
質問 # 95
Which two tasks can you perform using App Builder?
- A. Create and manage database objects.
- B. Create join queries using drag and drop.
- C. Generate data definition language (DDL) statements from the Oracle data dictionary.
- D. Import previously exported apps.
- E. Create and manage apps.
正解：D、E
解説：
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
質問 # 96
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]
質問 # 97
Which two statements are true about creating and using dynamic actions?
- A. Once you create a dynamic action, you cannot add additional true actions.
- B. 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
- C. You can execute JavaScript code by creating a dynamic action.
- D. If no client-side condition is defined, true actions will not fire.
正解：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]
質問 # 98
Which is a valid Page Process type?
- A. Execute JavaScript Code
- B. Set Value
- C. Send E-Mail
正解：B
解説：
Explanation
A page process type defines what action the page process performs when it is executed. There are many page process types available in Oracle APEX, such as Execute PL/SQL Code, Data Loading, Branch, etc. One of the valid page process types is Set Value. The Set Value page process type sets session state for an item or items on a page using a computation or PL/SQL expression. You can use this page process type to assign values to items based on logic or conditions. The other options are not valid page process types. Execute JavaScript Code is a dynamic action type, not a page process type. Send E-Mail is an application process type, not a page process type. Verified References: [Understanding Page Processes - Oracle Help Center], [Set Value Process Type - Oracle Help Center]
質問 # 99
Choose the statement that is TRUE about Universal Theme.
- A. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript
- B. Universal theme is the default theme that is shipped with Oracle APEX
- C. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles
- D. All of them
正解：D
解説：
Explanation
Universal Theme is a responsive, versatile, and customizable user interface for your APEX apps. It is designed uniquely for Oracle APEX to make it easy for developers to build beautiful, modern applications, at any scale, for any purpose, that work on any device. All of the statements given are true about Universal Theme:
Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript. Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It also provides a rich set of UI components, template options, and theme styles that can be used declaratively without writing custom code.
Universal theme is the default theme that is shipped with Oracle APEX. Universal Theme is the default theme for new applications created in APEX 5.0 or later. It is also the recommended theme for upgrading existing applications to the latest version of APEX.
Uses a 12-column grid layout system for arranging components on a page. Ships with a variety of pre-built theme styles. Universal Theme uses a 12-column grid layout system based on Flexbox to arrange components on a page. It also ships with a variety of pre-built theme styles that can be applied to change the look and feel of the application.
質問 # 100
Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?
- A. Interactive Report
- B. Cards
- C. Side by Side Master Detail
- D. Stacked Master Detail
正解：D
解説：
Explanation
A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
質問 # 101
Which two statements that are TRUE about charts in Interactive grid?
- A. Once the chart is created, it cannot be reconfigured.
- B. You can create multiple charts at a time in an interactive grid
- C. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- D. Once a chart is created, you can switch the view between Grid and Chart view.
正解：C、D
解説：
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
質問 # 102
......
PassTest 1z1-770試験練習テスト問題：https://www.passtest.jp/Oracle/1z1-770-shiken.html
1z1-770試験問題解答：https://drive.google.com/open?id=1z-sf7THHtg1lsL5Y-U2lQBOuFxLhBuws