2024年最新の1z1-770問題集レビュー専門クイズ学習材料 [Q39-Q63]

2024年最新の1z1-770問題集レビュー専門クイズ学習材料

1z1-770テスト準備トレーニング練習試験問題 練習テスト

Oracle 1Z0-770試験は、APEXアーキテクチャ、セキュリティ、データモデリング、ユーザーインターフェース開発、アプリケーション展開など、幅広いトピックをカバーしています。この試験は、105分以内に完了する必要がある60問の選択式問題で構成されています。この試験の合格スコアは63％です。

 

質問 # 39
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. Page and Scroll
• B. Scroll
• C. Page
• D. No Pagination

正解：A

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

質問 # 40
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 TRUE.
• B. It will default to FALSE.
• C. It will restrict acceptable values to Y or N.
• D. It will restrict acceptable values to TRUE or FALSE.

正解：D

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

質問 # 41
Which two feature pages can you create using the Create Page Wizard?

• A. Search Page
• B. Unified Task List
• C. Feedback
• D. Access Control

正解：C、D

解説：
Explanation
The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types

質問 # 42
Which two are true when the Edit option is NOT enabled for an Interactive Grid?

• A. The end user can edit the underlying data in the database
• B. The end user cannot edit the underlying data in the database
• C. The end user cannot create charts
• D. The end user can customize the report

正解：B、D

解説：
Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.

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

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

正解：D

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

質問 # 44
Using Data Workshop, you can perform which three tasks:

• A. Load data using various file formats such as XLSX, CSV, XML, and JSON
• B. Export vast amount of data from the database into a file
• C. Delete data from the database
• D. Load vast amount of data into the database

正解：A、B、D

解説：
Explanation
Using Data Workshop, you can perform the following tasks:
Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data.
Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data.
Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.
The other option is incorrect because:
Delete data from the database: You cannot use Data Workshop to delete data from the database. You can use SQL Commands or SQL Scripts in SQL Workshop to run DELETE statements to delete data from the database.
Verified References: [About Data Workshop] [Loading Data] [Unloading Data]

質問 # 45
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?

• A. Filter
• B. Format
• C. Data
• D. columns

正解：D

解説：
Explanation
To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option.
The other options are incorrect because:
Filter allows you to filter the data in your report by applying one or more conditions on the columns.
Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing.
Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors.
Verified References: [Customizing Interactive Reports] [Actions Menu]

質問 # 46
What are Task definitions that exist on the application level inthe Shared Components section made up of?

• A. Parameters
• B. Particpants
• C. Task Settings
• D. Actions
• E. All of them

正解：E

解説：
Explanation
Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions. Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes. Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.

質問 # 47
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. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
• C. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
• D. You can create a PWA only when creating a new application with the Create Application Wizard.
• E. Enabling the PWA functionality optimizes page loading speed on a mobile device.

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

質問 # 48
Choose the two statements that are TRUE about an Interactive Report. As a developer:

• A. You cannot modify the report source query
• B. You can customize the Actions menu to include or exclude certain options.
• C. You can modify the data in the report after running the app
• D. You can customize the pagination

正解：C、D

質問 # 49
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?

• A. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
• B. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
• C. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
• D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.

正解：A

解説：
Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]

質問 # 50
Which two statements are true about creating and managing an APEX Workspace?

• A. A workspace enables multiple users to work within the same Oracle APEX installation.
• B. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
• C. New schemas cannot be created during workspace creation.
• D. A workspace can be associated with only one schema.
• E. During workspace creation, you can associate the workspace with an existing databaseschema.

正解：A、E

解説：
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces

質問 # 51
Developers can use Template Options in which of the following ways?

• A. Displaying form fields with different alignments
• B. Applying different spacing and padding
• C. Rendering buttons in different styles, with and without icons
• D. Applying different colors or accents
• E. All of them

正解：E

解説：
Explanation
Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways:
Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions.
Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page.
Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports.
Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.

質問 # 52
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?

• A. End user can customize how and what data is displayed.
• B. End user can save the report
• C. End user can rearrange the report interactively using the mouse.
• D. End user can add, modify, and refresh data directly on the report.

正解：A、D

解説：
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]

質問 # 53
You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?

• A. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
• B. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
• C. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
• D. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE

正解：A

解説：
Explanation
d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this:
UPDATE events
SET start_date = :APEX.NEW_START_DATE,
end_date = :APEX.NEW_END_DATE
WHERE id = :APEX.PK_VALUE;

質問 # 54
You can create an APEX workspace and build APEX apps on which of the following platforms?

• A. All of the above
• B. Amazon RDS
• C. Microsoft Azure
• D. Oracle XE
• E. Oracle Autonomous Cloud

正解：A

解説：
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure

質問 # 55
To highlight certain rows in the interactive report based on a condition, you must:

• A. Edit the rows in the report and select a color
• B. Provide a conditional SQL query
• C. Choose a condition in Format > Highlight
• D. Rows cannot be highlighted in an Interactive report

正解：C

解説：
Explanation
To highlight certain rows in the interactive report based on a condition, you must choose a condition in Format
> Highlight. This option allows you to apply a conditional formatting rule to the report, which changes the appearance of the rows that match the condition. You can specify the condition type, expression, column, operator, and value. You can also choose the highlighting style, such as background color, text color, or icon.
The other options are incorrect because:
Provide a conditional SQL query: This option will not highlight certain rows in the interactive report based on a condition. It will filter the data in the report by applying a WHERE clause to the SQL query that defines the report source.
Edit the rows in the report and select a color: This option will not highlight certain rows in the interactive report based on a condition. It will modify the data in the report by using inline editing or modal dialog editing. You cannot select a color for the rows in this option.
Rows cannot be highlighted in an Interactive report: This option is false. Rows can be highlighted in an Interactive Report by using the Format > Highlight option.
Verified References: [Customizing Interactive Reports] [Highlighting Rows Based on Conditions]

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

• A. The search results report can be displayed as an interactive grid
• B. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
• 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.

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

質問 # 57
Which two Query Source types can be used to create a dynamic Navigation Bar List?

• A. Procedure
• B. Function Returning SQL Query
• C. Select List
• D. SQL Query

正解：B、D

解説：
Explanation
The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists

質問 # 58
Choose the three correct statements about Charts in APEX.

• A. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
• B. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
• C. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
• D. You can create charts without using Oracle JET

正解：A、B、C

解説：
Explanation
A chart is a type of component that enables users to visualize data in different ways and perform data analysis.
A chart can display data in various formats, such as bars, lines, areas, ranges, combinations, scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development principles. Three of the correct statements about charts in Oracle APEX are:
You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that can be used to display data in different ways and support different analysis scenarios. You can choose from over 20 chart types when creating a chart in Oracle APEX.
Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying technology for rendering charts in the browser. Oracle JET provides high-performance and interactive data visualizations that are compatible with various devices and browsers.
Each Oracle JET visualization supports animation, accessibility, responsive layout, internationalization, test automation, and a range of inter activity features. This statement is true because Oracle JET offers many features and capabilities that enhance the user experience and functionality of the charts. For example:
Animation: Charts can have smooth transitions and effects when loading or updating data.
Accessibility: Charts can support keyboard navigation, screen reader compatibility, and high contrast mode for users with disabilities.
Responsive layout: Charts can adapt to different screen sizes and orientations by resizing or repositioning elements.
Internationalization: Charts can support different languages, date formats, number formats, and text directions for users from different regions.
Test automation: Charts can support automated testing tools and frameworks by providing unique identifiers for elements.
Interactivity: Charts can support user actions such as zooming, panning, filtering, selecting, drilling down, or popping up tooltips.

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

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

正解：A

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

質問 # 60
Which two of the following types can an end user save the customized Interactive report as?

• A. A Public report
• B. A private report
• C. Cannot save the report
• D. Default report

正解：A、B

質問 # 61
Choose the statement that is TRUE about Universal Theme.

• A. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles
• B. All of them
• C. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript
• D. Universal theme is the default theme that is shipped with Oracle APEX

正解：B

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

質問 # 62
The APEX engine uses which component as a key for tracking each user's session state?

• A. APEX_USER
• B. APP_USER
• C. LDAP_USER
• D. HTTP_USER

正解：B

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

質問 # 63
......

Oracle 1Z0-770 (Oracle APEX Developer Professional) 試験は、Oracle Application Express (APEX) を使用して堅牢でスケーラブルなWebアプリケーションを開発する専門家のスキルと専門知識をテストするために設計された認定試験です。 APEX は、Oracle データベースに特化した開発ツールで、開発者が簡単かつ効率的に Web アプリケーションを構築できます。この認定は、Oracle APEX 開発者としてのキャリアをさらに進め、潜在的な雇用主に専門知識を示すことを望む個人を対象としています。

 

試験問題解答ブレーン問題集で1z1-770試験問題集PDF問題：https://jp.fast2test.com/1z1-770-premium-file.html