[2024年05月26日] 問題集お試しセット1z1-770テストエンジントレーニング問題集には144問あります
Oracle 1z1-770問題集で100%カバー率リアル試験問題
Oracle Apex Developer Professional認定を獲得することは、Oracle Apexアプリケーションを開発および維持するために必要なスキルと知識を持っていることを潜在的な雇用主とクライアントに示しています。この認定は、混雑した雇用市場で際立っており、収益の可能性を高めるのに役立ちます。さらに、Oracle Apex Developmentの分野における継続的な学習と専門能力開発へのコミットメントを示しています。
Oracle 1Z0-770試験は、Oracle Application Express（APEX）を使用してアプリケーションを開発する能力を証明するための認定試験です。APEXは、低コード開発プラットフォームであり、スケーラブルで安全でレスポンシブなWebアプリケーションを構築することができます。この試験は、APEXの概念を強く理解し、APEXを使用してアプリケーションを開発した経験を持つプロフェッショナルを対象としています。
質問 # 68
Which statement is true about Theme Styles in Oracle APEX?
- A. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- B. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
- C. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
正解：A
解説：
Explanation
Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences. Verified References: Using Themes and Theme Styles - Oracle Help Center, Theme Styles - Oracle APEX
質問 # 69
Choose the two correct statements about PWA.
- A. To download the app as PWA, one must visit the App Store
- B. Enables users to install the application on devices
- C. Provides a customizable offline page when users areoffline and cannot request thenetwork.
- D. An existing APEX app cannot be made a PWA
正解：B、C
質問 # 70
Which two statements are true about creating and customizing Smart Filters pages?
- A. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
- B. The search results report can be displayed as an interactive grid
- C. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
- D. The search results report can be displayed as an interactive report.
正解：A、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]
質問 # 71
Select the three types of Card Layout you can create in APEX.
- A. Vertical(Column)
- B. Grid
- C. Horizontal(Row)
- D. Float
正解：B、C、D
解説：
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
質問 # 72
Which is NOT a valid Geometry Column Data Type available for maps region?
- A. Latitude/Longitude
- B. SDO_GEOMETRY
- C. JSON_OBJECT
- D. GeoJSON
正解：C
解説：
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
質問 # 73
What are the three types of List of Values(LOV) you can create on a page?
- A. Popup LOV
- B. Dynamic LOV
- C. Static LOV
- D. Cascading LOV
正解：B、C、D
解説：
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.
質問 # 74
In a Classic Report, an end user can perform which two of the following actions?
- A. Sort the columns of the report
- B. Filter values of a column in the report
- C. Rearrange the columns in the report
- D. Create Control Breaks in the report
正解：A、B
解説：
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]
質問 # 75
To create a Dynamic Action, you need to specify which three of the following options?
- A. Why the action is performed
- B. What elements are affected by the action
- C. What action or actions are performed
- D. When the action occurs
正解：B、C、D
解説：
Explanation
To create a dynamic action, you need to specify at least three options: what action or actions are performed, when the action occurs, and what elements are affected by the action1. The action is the behavior that you want to happen when the event is triggered. You can choose from a list of predefined actions or create your own custom action using JavaScript code1. The event is the user interaction or condition that causes the dynamic action to fire. You can select an event from a list of available events based on the type of element you select1. The affected elements are the items, buttons, or regions that are affected by the action. You can select one or more elements by using jQuery selectors1. You do not need to specify why the action is performed, as this is not a required option for creating a dynamic action.
質問 # 76
Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?
- A. Breadcrumbs
- B. Lists
- C. Navigation Bar List
- D. Navigation Menu
正解：D
解説：
Explanation
The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.
質問 # 77
When you create a Dynamic Action, you specify the event that causes the dynamic action to fire.
Choose the categories these events are classified into.
- A. Browser Events
- B. Framework Events
- C. All of them
- D. Component Events
- E. Custom Events
正解：C
解説：
Explanation
The events that cause the dynamic action to fire are classified into five categories: Browser Events, Component Events, Custom Events, Framework Events, and jQuery Events1. Browser events are triggered by user interactions with the browser window, such as resize, scroll, or unload. Component events are triggered by user interactions with specific APEX components, such as interactive grids, interactive reports, or trees.
Custom events are user-defined events that can be triggered by other dynamic actions or JavaScript code.
Framework events are triggered by APEX framework actions, such as page load, page submit, or dialog close. jQuery events are triggered by user interactions with jQuery UI widgets, such as accordion, tabs, or date picker1.
質問 # 78
Which two among the following are TRUE about Low Code Apps?
- A. Expensive
- B. Provide Rich Functionality with Less Code
- C. Not Mobile Friendly
- D. Scalable
正解：B、D
解説：
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
質問 # 79
The APEX engine uses which component as a key for tracking each user's session state?
- A. APEX_USER
- B. LDAP_USER
- C. HTTP_USER
- D. APP_USER
正解：D
解説：
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.
質問 # 80
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the sessions data
- B. Move the database objects
- C. Move the images
- D. Move the application definition and all associated files
正解：B、C、D
解説：
Explanation
To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.
質問 # 81
Which two statements are true about the generated SQL?
- A. Creates DEPARTMENTS table with 2 columns
- B. Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.
- C. Creates EMPLOYEES table with 4 columns
- D. Inserts 10 rows of random sample data into the DEPARTMENTS table
正解：A、C
解説：
Explanation
The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified columns and data types. It does not insert any data into the tables, nor does it create any primary or foreign keys. The script only creates the tables and their columns. References: Creating a Desktop Database Application and Using SQL Workshop
質問 # 82
Using the App Builder component, you can perform which three tasks?
- A. Run SQL scripts and commands
- B. Install a sample App
- C. Edit pages in the page designer
- D. Create a new App
正解：B、C、D
解説：
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]
質問 # 83
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Group By
- B. Hide
- C. Delete
- D. Control Break
正解：B、D
解説：
Explanation
The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:
Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.
The other options are incorrect because:
Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.
Verified References: [Customizing Interactive Reports] [Column Heading Menu]
質問 # 84
What three are the key features of Data Load Definition?
- A. Only XML data format can be loaded to tables or collections
- B. Column mapping occurs at design time, removing the burden on end users.
- C. Easy workflow for end users: upload the file, verify the preview, and load data
- D. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
正解：B、C、D
解説：
Explanation
Data Load Definition is a feature that enables developers to create pages with data loading capability. Users can upload files and load data into tables or collections. Some key features of Data Load Definition are:
The APEX_DATA_LOADING PL/SQL API is available for custom processing. Developers can use this API to programmatically load data by calling an application data loading definition .
Column mapping occurs at design time, removing the burden on end users. Developers can define SQL expressions, SQL queries, lookups, or transformation rules for each data profile column.
Easy workflow for end users: upload the file, verify the preview, and load data. Users can follow a simple three-step process to load data from a file into a table or a collection.
Data Load Definition does not support only XML data format. It also supports CSV, JSON, XLSX, and XML formats.
質問 # 85
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 no client-side condition is defined, true actions will not fire.
- C. You can execute JavaScript code by creating a dynamic action.
- D. 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、D
解説：
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]
質問 # 86
Which two statements are true about the Create Application Wizard?
- A. It allows the uploading of JavaScript or CSS files required for an application.
- B. It allows application pages to be added or deleted.
- C. It allows the application authorization to be changed
- D. It allows application pages to be reordered.
正解：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]
質問 # 87
Which two functions can be used by an end user when pivoting an interactive report?
- A. List aggregate
- B. Rank
- C. Median
- D. list aggregate
- E. Minimum
正解：B、E
解説：
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56
質問 # 88
Which three of the following are use cases of Automations?
- A. Deleting a database record based on an end user's request
- B. Sending email alerts at a particular time of the week
- C. Approving specific requests
- 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.
質問 # 89
Which two tasks can you perform using App Builder?
- A. Import previously exported apps.
- B. Generate data definition language (DDL) statements from the Oracle data dictionary.
- C. Create and manage apps.
- D. Create and manage database objects.
- E. Create join queries using drag and drop.
正解：A、C
解説：
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]
質問 # 90
......
実際にある1z1-770問題集PDFで100%合格率保証付きます：https://jp.fast2test.com/1z1-770-premium-file.html