1Z0-770試験問題集を提供していますOracle問題 [Q30-Q55]

1Z0-770試験問題集を提供していますOracle問題

1Z0-770認定ガイドPDFはリアル試験問題で100%カバー率

Oracle 1Z0-770認定試験に備えるためには、SQLとPL/SQLの強い理解、およびOracleデータベースの経験が推奨されます。さらに、Oracleは、練習問題を含むトレーニングコースや学習資料を提供して、試験に備えるための支援を行っています。

Oracle 1Z0-770認定試験は、60の複数選択質問で構成されており、105分以内に完了する必要があります。候補者は、認定を獲得するには、63％以上の合格スコアを達成する必要があります。この試験は、世界中のPearson Vue Testing Centerで行うことができます。また、提案された試験形式を使用してオンラインで撮影することもできます。

 

質問 # 30
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?

• A. Removing P1_SALARY from the validation Associated Item
• B. Setting Display Location to Inline in Notification
• C. Setting the value Required to Yes on P1_SALARY

正解：A

解説：
Explanation
A validation is a rule that checks the data entered by end users before processing it. A validation of type Item is numeric checks if a page item value is a valid number. When the page is submitted, if the validation fails, an error message is displayed both in the notification area (atthe top of the page) and below the item (next to the item label). To cause the validation error to appear only in the notification area, you need to remove P1_SALARY from the validation Associated Item attribute. The Associated Item attribute specifies which page item is associated with the validation and where to display the error message if the validation fails.
Setting the value Required to Yes on P1_SALARY or setting Display Location to Inline in Notification will not affect the validation error display. Verified References: [Creating Validations - Oracle Help Center],
[Validation Attributes - Oracle Help Center]

質問 # 31
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?

• A. Debug
• B. Quick Edit
• C. Session
• D. Customize

正解：D

解説：
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.

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

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

正解：A、B、C

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

質問 # 33
Which two statements are true about creating and using dynamic actions?

• A. You can execute JavaScript code by creating a dynamic action.
• 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. If no client-side condition is defined, true actions will not fire.
• D. Once you create a dynamic action, you cannot add additional true actions.

正解：A、B

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

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

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

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

質問 # 35
Choose from the below options the actions that can be performed when a button is clicked.

• A. Redirect to a URL
• B. Submit Page
• C. Redirect to a page in the same application
• D. Redirect to a page in a different application
• E. All of them

正解：E

解説：
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.

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

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

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

質問 # 37
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. Master Detail
• C. Unified Task List
• D. Interactive Grid

正解：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

質問 # 38
Which two among the following are TRUE about Low Code Apps?

• A. Scalable
• B. Expensive
• C. Not Mobile Friendly
• D. Provide Rich Functionality with Less Code

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

質問 # 39
Select the three types of Card Layout you can create in APEX.

• A. Horizontal(Row)
• B. Grid
• C. Float
• D. Vertical(Column)

正解：A、B、C

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

質問 # 40
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?

• A. App Builder
• B. Data Generator
• C. Quick SQL
• D. Data Workshop

正解：D

解説：
Explanation
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database.
You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.

質問 # 41
What three are the key features of Data Load Definition?

• A. Only XML data format can be loaded to tables or collections
• B. Easy workflow for end users: upload the file, verify the preview, and load data
• C. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
• D. Column mapping occurs at design time, removing the burden on end users.

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

質問 # 42
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?

• A. mycompany is the path-prefix which is by default the workspace name
• B. session=13766599855150 Ahr-app is the application alias.
• C. 13766599855150 is the session ID. A new ID is generated for each session.
• D. update-employees is the PL/SQL procedure to update the employee details.

正解：A、B、C

解説：
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]

質問 # 43
Which statement is true about Theme Styles in Oracle APEX?

• A. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
• B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
• C. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.

正解：B

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

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

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

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

質問 # 45
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. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
• C. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
• D. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
• 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.

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

質問 # 46
Which two actions can you perform using the Object Browser?

• A. Export and import SQL scripts.
• B. Browse database objects of the current schema.
• C. Restore dropped database objects.
• D. Create and run SQL scripts.
• E. Create a lookup table based on a column in the current table.

正解：B、E

解説：
Explanation
Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are:
Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs.
Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin,SQL Commands, and SQL Scripts.
Verified References: [Managing Database Objects with Object Browser - Oracle Help Center], [Creating Lookup Tables - Oracle Help Center]

質問 # 47
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. Framework Events
• B. Component Events
• C. Browser Events
• D. Custom Events
• E. All of them

正解：E

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

質問 # 48
What are the three types of List of Values(LOV) you can create on a page?

• A. Popup LOV
• B. Static LOV
• C. Dynamic 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.

質問 # 49
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?

• A. Page Rendering
• B. Page Validation
• C. Page Refresh
• D. Page Processing

正解：B、D

解説：
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process

質問 # 50
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:

• A. Dynamic LOV
• B. Popup LOV
• C. Static LOV
• D. Cascading LOV

正解：D

解説：
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.

質問 # 51
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:

• A. No Pagination
• B. Scroll
• C. Page and Scroll
• D. Page

正解：C

解説：
Explanation
When a table or a SQL query returns many rows, an interactive grid is best displayed to the user with pagination. Pagination enables users to navigate through large data sets by displaying a subset of data at a time3. The two types of pagination available for interactive grids are Page and Scroll3. Page pagination displays a fixed number of rows per page and provides controls to navigate between pages. Scroll pagination displays rows as the user scrolls down the grid and fetches more data as needed

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

質問 # 53
Which two statements are true about creating and customizing Smart Filters pages?

• A. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
• B. The search results report can be displayed as an interactive grid
• C. The search results report can be displayed as an interactive report.
• D. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.

正解：A、D

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

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

正解：B、C

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

質問 # 55
......

合格させる1Z0-770試験にはリアル問題解答：https://jp.fast2test.com/1Z0-770-premium-file.html