[2026年01月]更新の1Z0-770問題集で時間限定！無料アクセスせよ！
1Z0-770問題集で2026年最新のOracle 1Z0-770試験問題
質問 # 22
Which statement is true about the Data Workshop utility?
- A. You cannot load data from an XLSX file with multiple worksheets.
- B. The wizards load and unload table data only.
- C. You can load or unload multiple tables at a time.
- D. The wizards load and unload all types of schema objects.
正解：B
解説：
Explanation
Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop - Oracle Help Center], [Loading Data - Oracle Help Center]
質問 # 23
Which three statements are TRUE about Search Configuration?
- A. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- B. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- C. Only one Search Configuration can be used in a Search Page.
- D. One or more Search Configurations can be configured in a Search Page.
正解：A、B、D
解説：
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
質問 # 24
Select the three types of Card Layout you can create in APEX.
- A. Vertical(Column)
- B. Float
- C. Horizontal(Row)
- D. Grid
正解：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.
質問 # 25
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. Procedure
- B. SQL Query
- C. Function Returning SQL Query
- D. Select List
正解：B、C
解説：
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
質問 # 26
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. Social Sign-In
- B. HTTP Header Variable
- C. Open Door Credentials
- D. SAML Sign-In
正解：A
解説：
Explanation
An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are:
HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server.
SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
Open Door Credentials: Enable anyone to access your application using a built-in login page that captures a user name. Verified References: [Understanding Preconfigured Authentication Schemes - Oracle Help Center], [Social Sign-In - Oracle Help Center]
質問 # 27
You want to enable anyone to access your application using a built-in login page that captures a user name.
Whichauthentication scheme would youchoose?
- A. Custom Authentication
- B. Open Door Credentials
- C. No Authentication
- D. Social Sign-In
正解：B
解説：
Explanation
Open Door Credentials is an authentication scheme that allows anyone to access your application using a built-in login page that captures a user name. You can use this scheme for testing purposes or for applications that do not require secure authentication. You can select this scheme from the Authentication Type list when creating or editing an authentication scheme. References: [Understanding Authentication] and [Creating an Authentication Scheme]
質問 # 28
Which statement is true about using SQL Commands?
- A. In SQL Commands, you can view queries saved in Query Builder.
- B. You can design and prototype data models using a markdown-like shorthand syntax.
- C. You can unload data from the database.
- D. You can search and filter database objects.
正解：C
解説：
Explanation
Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34
質問 # 29
Which two statements are true about the generated SQL?
- A. Creates EMPLOYEES table with 4 columns
- B. Creates DEPARTMENTS table with 2 columns
- C. Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.
- D. Inserts 10 rows of random sample data into the DEPARTMENTS table
正解：A、B
解説：
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
質問 # 30
What three are the uses of Collections in APEX?
- A. Collections enable you to store rows and columns in the current session into database tables
- B. Collections can be accessed, manipulated, or processed during a user's specific session.
- C. You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.
- D. Use collections to temporarily capture one or more nonscalar Values.
正解：B、C、D
解説：
Explanation
Collections are temporary tables that store session-specific data in memory. They can be used for various purposes in APEX applications. Some uses of collections are:
You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. This API provides several procedures and functions to manipulate collections and their members.
Use collections to temporarily capture one or more nonscalar values. For example, you can use collections to store the results of a query, the values of page items, or the selections of a report.
Collections can be accessed, manipulated, or processed during a user's specific session. For example, you can use collections to pass data between pages, perform calculations on collection members, or create reports based on collections.
Collections do not enable you to store rows and columns in the current session into database tables.
Collections are stored in memory and are not persistent across sessions.
質問 # 31
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.
質問 # 32
Which two statements are true about REST Data Source Synchronization?
- A. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
- B. 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. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
- D. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
- E. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
正解：B、C
解説：
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
質問 # 33
Which statement is true about Unified Task List in the Approvals component?
- A. It is a shared component used to configure task parameters, participants, actions, and due dates.
- B. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
- C. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
正解：B
解説：
Explanation
The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users.
The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.
Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]
質問 # 34
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page Processing
- B. Page compilation
- C. Page Rendering
- D. Page rendering and processing
正解：D
解説：
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
質問 # 35
Which statement is true about the Link Column attribute of an interactive report?
- A. A Link Column cannot be sorted, hidden, or moved by an end user.
- B. It is not possible to include a custom target in Link Column
- C. It is not possible to exclude Link Column.
- D. If you select Link Column, it is always displayed as the last column in the report.
正解：A
解説：
Explanation
A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header. However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.
質問 # 36
What are the three features of a calendar in APEX?
- A. Previous - Navigates to the previous month.
- B. Reminders - Displays the reminders set by the users
- C. Month, Week, Day - Displays a monthly, weekly and daily view.
- D. Next - Navigates to the next month.
正解：A、C、D
解説：
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.
質問 # 37
What are the required fields while creating a Chart in APEX?
- A. Name
- B. Data Source
- C. Label Column
- D. Value Column
- E. All of them
正解：E
解説：
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.
質問 # 38
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Session
- B. Quick Edit
- C. Debug
- 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.
質問 # 39
Plug-ins can be used declaratively in which of the following components in APEX?
- A. Items
- B. Regions
- C. Process Type
- D. Dynamic Actions
- E. All of them
正解：E
解説：
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.
質問 # 40
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Create and view database objects
- C. Delete database
- D. Run SQL commands and scripts
正解：B、D
解説：
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
質問 # 41
......
Oracle 1Z0-770は、Oracle Application Express（APEX）を使用してアプリケーションを開発することに興味のある個人の知識とスキルをテストするために設計された認定試験であり、Oracle APEX開発者プロフェッショナル認定試験とも呼ばれています。APEXは、低コード開発プラットフォームであり、開発者が現代的でレスポンシブでスケーラブルなWebアプリケーションを簡単に作成できるようにします。
Oracle 1Z0-770試験実践テスト問題：https://jp.fast2test.com/1Z0-770-premium-file.html