[2024年08月]更新の1Z0-770試験問題集、1Z0-770練習テスト問題
検証済み1Z0-770問題集PDF資料 [2024]
Oracle 1Z0-770認定試験は、開発者がApexを使用してWebアプリケーションを設計、開発、展開するためのスキルと知識を検証する優れた方法です。それは、専門家が自分のキャリアを前進させ、雇用市場で際立っているのに役立つ世界的に認められた資格情報です。試験の準備をするために、候補者は頂点アーキテクチャ、セキュリティ、データモデリング、Webサービス、およびSQLを強く理解し、Oracleが提供するトレーニングリソースを活用する必要があります。
質問 # 79
Which component in SQL Workshop allows you to build queries graphically without manual SQLcoding?
- A. Data Workshop
- B. Query Builder
- C. Quick SQL
- D. SQL commands
正解：B
解説：
Explanation
Query Builder is a component in SQL Workshop that allows you to build queries graphically without manual SQL coding. You can use Query Builder to select tables and views from your schema, join them using drag-and-drop operations, add filters andgroupings, and view the results in a grid or chart format. You can also switch to the SQL mode to view or edit the generated SQL statement.
The other options are incorrect because:
Quick SQL is a component in SQL Workshop that allows you to generate SQL scripts for creating tables and other database objects using shorthand syntax. You cannot use Quick SQL to build queries graphically.
SQL Commands is a component in SQL Workshop that allows you to run individual SQL statements or PL/SQL blocks interactively. You cannot use SQL Commands to build queries graphically.
Data Workshop is a component in SQL Workshop that allows you to load or unload data from the database using various file formats. You cannot use Data Workshop to build queries graphically.
Verified References: [About Query Builder] [Using Query Builder]
質問 # 80
To create a Dynamic Action, you need to specify which three of the following options?
- A. What action or actions are performed
- B. When the action occurs
- C. What elements are affected by the action
- D. Why the action is performed
正解：A、B、C
解説：
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.
質問 # 81
Choose the three correct statements about Charts in APEX.
- A. You can create charts without using Oracle JET
- B. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
- C. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
- D. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
正解：B、C、D
解説：
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.
質問 # 82
When you create an Access Control Page, which three of the following Access Roles get created?
- A. Developer
- B. Contributor
- C. Administrator
- D. Reader
正解：B、C、D
解説：
Explanation
When you create an Access Control Page using the Create Page Wizard, three of the following Access Roles get created: Reader, Administrator, and Contributor. These roles are predefined by APEX and correspond to the authorization schemes that control the access to the application, pages, or page components1. Reader role grants read-only access to the application. Administrator role grants full access to the application, including administrative and edit privileges. Contributor role grants edit privileges to the application, but not administrative privileges2. Developer role is not a default Access Role created by the wizard, but you can create your own custom roles and assign them to users on the Application Access Control page.
質問 # 83
Choose the three Form types that you can create using the Create Page wizard.
- A. Interactive Report
- B. Master Detail
- C. Interactive Grid
- D. Form
正解：B、C、D
解説：
Explanation
The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
質問 # 84
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You can customize the pagination
- B. You can modify the data in the report after running the app
- C. You can customize the Actions menu to include or exclude certain options.
- D. You cannot modify the report source query
正解：A、B
質問 # 85
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?
- A. Help Page
- B. Non-Modal Dialog
- C. Modal Dialog
- D. Normal Page
正解：C
解説：
Explanation
A modal dialog is a type of page mode that displays an overlay window within the viewport when a button is pressed. A modal dialog is a stand-alone page that does not interact with the base page where it was launched.
A modal dialog blocks access to the base page until it is closed by the user. A modal dialog can be used for various purposes, such as displaying additional information, confirming an action, or collecting user input.
質問 # 86
Choose the three supported spatial geometry objects in Maps.
- A. Polygons
- B. Points
- C. Heat map
- D. Bars
正解：A、B、C
解説：
Explanation
A map is a type of component that enables users to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST data source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Three of the supported spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.
質問 # 87
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?
- A. Data Generator
- B. Quick SQL
- C. App Builder
- 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.
質問 # 88
What are the two primary ways to move database objects and data from one environment toanother, for a single application?
- A. Oracle SQL Developer
- B. SQL Workshop
- C. App Builder
- D. Page Designer
正解：A、B
解説：
Explanation
Oracle SQL Developer and SQL Workshop are two primary ways to move database objects and data from one environment to another, for a single application. Oracle SQL Developer is a graphical tool that allows you to export and import data schemas using Data Pump or SQL scripts. SQL Workshop is a component of Oracle APEX that enables you to perform tasks such as exporting and importing data, running SQL commands, and generating DDL scripts. Both tools can help you migrate your database objects and data to a different instance or workspace. References: Using SQL Developer to Migrate Your Oracle Database and Using Data Workshop to Manage Data
質問 # 89
Which three are the main components of APEX workspace homepage?
- A. SQL Workshop
- B. RESTful Services
- C. App Builder
- D. Gallery
正解：A、C、D
解説：
Explanation
The main components of an APEX workspace homepage are:
Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.
SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.
App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.
The other option is incorrect because:
RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.
Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]
質問 # 90
You can create a report in which of the three following methods?
- A. Create a report region on a page in an application
- B. Create a report from Object Browser
- C. Create a report when you create a new database application
- D. Create a report as a new page in an application
正解：A、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]
質問 # 91
Which two statements are true about Faceted Search pages?
- A. A facet's chart can be seen only in a nonmodal dialog.
- B. Faceted Search supports the ability to filter columns storing multiple values as one string.
- C. Facets map to specific database columns.
- D. Multiple charts are not visible in the same region.
正解：B、C
解説：
Explanation
Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]
質問 # 92
To highlight certain rows in the interactive report based on a condition, you must:
- A. Choose a condition in Format > Highlight
- B. Rows cannot be highlighted in an Interactive report
- C. Provide a conditional SQL query
- D. Edit the rows in the report and select a color
正解：A
解説：
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]
質問 # 93
Which two statements are true about creating and managing an APEX Workspace?
- A. During workspace creation, you can associate the workspace with an existing databaseschema.
- B. A workspace can be associated with only one schema.
- C. New schemas cannot be created during workspace creation.
- D. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
- E. A workspace enables multiple users to work within the same Oracle APEX installation.
正解：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
質問 # 94
Developers can use Template Options in which of the following ways?
- A. All of them
- B. Rendering buttons in different styles, with and without icons
- C. Applying different spacing and padding
- D. Applying different colors or accents
- E. Displaying form fields with different alignments
正解：A
解説：
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.
質問 # 95
......
Oracle 1Z0-770試験を受けるには、候補者はSQL、PL/SQL、HTML、CSS、およびJavaScriptを強く理解する必要があります。また、Oracleデータベースを操作した経験があり、Oracle Apexを使用してアプリケーションを設計、開発、展開できる必要があります。この試験は、60の複数選択の質問で構成されており、105分の時間制限があります。認定を獲得するには、63％以上の合格スコアが必要です。
Oracle 1Z0-770 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
最新の1Z0-770実際の無料試験問題は更新された144問あります：https://jp.fast2test.com/1Z0-770-premium-file.html