[2025年05月]更新の1Z0-770試験問題集、1Z0-770練習テスト問題
検証済み1Z0-770問題集PDF資料 [2025]
質問 # 42
Which three of the following options are TRUE about a page in an APEX application?
- A. An APEX application can have only one page.
- B. A page can be viewed and edited in the Page Designer.
- C. A page can contain buttons, page items and regions.
- D. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
正解：B、C、D
質問 # 43
Which two statements are true about creating and using dynamic actions?
- A. 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
- B. You can execute JavaScript code by creating a dynamic action.
- C. Once you create a dynamic action, you cannot add additional true actions.
- D. If no client-side condition is defined, true actions will not fire.
正解：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]
質問 # 44
What three are the building blocks of Approvals Component?
- A. Unified Task List
- B. Task Details Page
- C. Automations
- D. Task Definition
正解：A、B、D
解説：
Explanation
The Approvals Component is Oracle APEX's new offering as part of the 22.1 Release. It allows seamless management of approvals across APEX Applications. Approvals are commonly used in business situations involving Expense Reimbursements, Leave Requests, Purchase Requisitions, On-boarding of Employees to name a few. The Approvals Component provides the following building blocks for the approvals functionality:
Task Definition: A shared component for configuring task parameters, participants, and actions. A task definition defines the template for creating tasks based on a specific type of approval request, such as Leave Approval or Purchase Requisition. A task definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks.
Task Details Page: A page that shows task details, which can include metadata, history, comments, and actions. A task details page allows users to view and take action on a specific task, such as approve, reject, reassign, or escalate. A task details page can be created using the Create Page Wizard or the Quick SQL tool in APEX.
Unified Task List: A page type in the Create Page Wizard, used to create a summary of a user's tasks that functions like an inbox. A unified task list allows users to see and manage all their tasks in one place. Users can filter, sort, search, claim, release, or open tasks from the unified task list.
質問 # 45
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 :P1 ENAME as the new employee of the month!
- B. Join me in congratulating v('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]
質問 # 46
Which two among the following are TRUE about Low Code Apps?
- A. Expensive
- B. Not Mobile Friendly
- C. Scalable
- D. Provide Rich Functionality with Less Code
正解：C、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?]
質問 # 47
Which statement is true about session state management in Oracle APEX?
- A. Multiple number of sessions cannot exist in the database at the same time
- B. A user cannot run multiple instances of an application simultaneously in different browser programs.
- C. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
正解：C
解説：
Explanation
Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:
A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
Multiple number of sessions can exist in the database at the same time for different users or applications.
Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]
質問 # 48
Which three of the following statements are TRUE about Data Synchronization?
- A. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.
- B. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.
- C. You must trigger Data Synchronization manually
- D. Helps in Providing efficient reporting on large data sets coming from a REST service
正解：A、B、D
解説：
Explanation
Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:
APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.
Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries. In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.
Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic. If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.
You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.
質問 # 49
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle XE
- B. Amazon RDS
- C. Oracle Autonomous Cloud
- D. All of the above
- E. Microsoft Azure
正解：D
解説：
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
質問 # 50
What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country
- A. Create the departments table with 3 columns
- B. Creates an id column as a primary key
- C. Inserts 4 rows of random data into the departments table
- D. Create the departments table with 4 columns
正解：B、C、D
解説：
Explanation
The QuickSQL shorthand notation departments /insert 4 name /nn location country will do the following:
Create the departments table with 4 columns: The first word in the notation is the table name, followed by a slash and the number of rows to insert. The subsequent words are the column names, separated by spaces. QuickSQL will generate a SQL script to create the table with the specified columns and data types.
Creates an id column as a primary key: QuickSQL will automatically add an id column as a primary key to the table, unless the /no_pk modifier is used. The idcolumn will be of type NUMBER and will use an identity constraint to generate unique values.
Inserts 4 rows of random data into the departments table: QuickSQL will use the /insert modifier to insert random data into the table, based on the column names and data types. The number after the modifier indicates how many rows to insert.
The other option is incorrect because:
Create the departments table with 3 columns: This is not what the notation will do. The notation will create the table with 4 columns, not 3.
Verified References: [Using Quick SQL] [About Quick SQL Shorthand Syntax]
質問 # 51
What are the two primary ways to move database objects and data from one environment toanother, for a single application?
- A. Page Designer
- B. SQL Workshop
- C. App Builder
- D. Oracle SQL Developer
正解：B、D
解説：
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
質問 # 52
Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?
- A. Lists
- B. Navigation Bar List
- C. Breadcrumbs
- D. Navigation Menu
正解：D
解説：
Explanation
The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.
質問 # 53
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 turn off the show Facet Name attribute.
- B. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
- C. 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.
- D. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
正解：D
解説：
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]
質問 # 54
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Delete the application
- B. Create a new page
- C. Navigate to Shared Components
- D. Export the application
正解：B、C
解説：
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.
質問 # 55
Which two statements are true about Maps in Oracle APEX?
- A. Maps support REST Enabled SQL
- B. Background maps do not require any API keys.
- C. Maps don't support REST Data Sources
- D. Heat Map and Polygons are not supported Spatial geometry objects
正解：A、B
解説：
Explanation
A map is a type of component that enables you 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. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
質問 # 56
In a Classic Report, an end user can perform which two of the following actions?
- A. Sort the columns of the report
- B. Create Control Breaks in the report
- C. Filter values of a column in the report
- D. Rearrange the columns in the report
正解：A、C
解説：
Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]
質問 # 57
The APEX engine uses which component as a key for tracking each user's session state?
- A. HTTP_USER
- B. APEX_USER
- C. LDAP_USER
- D. APP_USER
正解：D
解説：
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.
質問 # 58
......
最新の1Z0-770実際の無料試験問題は更新された144問あります：https://jp.fast2test.com/1Z0-770-premium-file.html