[2024年最新] 高合格率な1Z0-770テストアンサーかつOracle 1Z0-770テストPDF
完璧1Z0-770問題集試験問題と解答でパス保証されます
質問 # 80
Choose the three types of aggregations you can apply on a column.
- A. Standard Deviation
- B. Average
- C. Sum
- D. Count
正解：B、C、D
質問 # 81
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. Session
- D. Quick Edit
正解：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.
質問 # 82
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 4 columns
- B. Inserts 4 rows of random data into the departments table
- C. Create the departments table with 3 columns
- D. Creates an id column as a primary key
正解：A、B、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]
質問 # 83
In APEX, you can choose which three of the following Authentication methods?
- A. Built-in Authentication Scheme
- B. Custom Authentication Scheme
- C. Authorization Scheme
- D. No Authentication
正解：A、B、D
解説：
Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.
質問 # 84
Which two statements are true about Maps in Oracle APEX?
- A. Maps don't support REST Data Sources
- B. Heat Map and Polygons are not supported Spatial geometry objects
- C. Maps support REST Enabled SQL
- D. Background maps do not require any API keys.
正解：C、D
解説：
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.
質問 # 85
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. Component Events
- B. Custom Events
- C. All of them
- D. Framework Events
- E. Browser Events
正解：C
解説：
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.
質問 # 86
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 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.
- C. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- D. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
正解：C
解説：
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]
質問 # 87
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?
- A. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
- B. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
- C. Set EMPNO, ENAME to "Display Only".
- D. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
正解：A、B
解説：
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
To make an employee's commission editable in the grid, you need to perform two actions:
In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to
"Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid. Verified References: [Managing Interactive Grids - Oracle Help Center], [Interactive Grid Attributes - Oracle Help Center]
質問 # 88
Which two statements are true about Oracle APEX?
- A. Running an APEX app needs client software.
- B. Application definition is not stored in the database.
- C. You can build interactive reporting apps based on data from disparate systems
- D. Processing and data manipulation is not executed in the database.
- E. APEX eliminates middle-tier application logic.
正解：C、E
解説：
Explanation
Oracle APEX is a low-code application development platform that enables developers to build scalable, secure, and data-driven web and mobile apps. Some of the statements that are true about Oracle APEX are:
APEX eliminates middle-tier application logic. APEX runs entirely within Oracle Database and does not require any additional middleware or application server to function. This simplifies the architecture and reduces the complexity, cost, and security risks of deploying applications.
You can build interactive reporting apps based on data from disparate systems. APEX supports various data sources, such as local database, REST Enabled SQL Service, REST Data Source, Web Source Module, etc. You can use these data sources to create interactive reports that allow end users to filter, sort, search, aggregate, and visualize data from different sources.
The other statements are false because:
Application definition is stored in the database. APEX stores the metadata of the application components, such as pages, regions, items, buttons, etc., in the database tables.
Processing and data manipulation is executed in the database. APEX leverages the power and performance of Oracle Database to process and manipulate data using SQL and PL/SQL.
Running an APEX app does not need client software. APEX apps are web-based and can be accessed from any browser on any device without installing any client software. Verified References: [Oracle Application Express (APEX) - Oracle Help Center], [Platform - Oracle APEX]
質問 # 89
Which two statements that are TRUE about charts in Interactive grid?
- A. Once a chart is created, you can switch the view between Grid and Chart view.
- B. Once the chart is created, it cannot be reconfigured.
- C. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- D. You can create multiple charts at a time in an interactive grid
正解：A、C
解説：
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
質問 # 90
Which two functions can be used by an end user when pivoting an interactive report?
- A. Minimum
- B. Rank
- C. List aggregate
- D. list aggregate
- E. Median
正解：A、B
解説：
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56
質問 # 91
From SQL Workshop, you can perform which two of the following actions?
- A. Create an APEX user
- B. Run SQL commands and scripts
- C. Delete database
- D. Create and view database objects
正解：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]
質問 # 92
Which statement is true about using the App Gallery?
- A. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- D. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
正解：B
解説：
Explanation
Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
質問 # 93
What are the three key features of Universal Theme?
- A. Versatile UI Components
- B. Support for single theme
- C. Responsive Design
- D. Easy Customization
正解：A、C、D
解説：
Explanation
Universal Theme has many features that make it an ideal user interface for Oracle APEX applications. Three of the key features of Universal Theme are:
Versatile UI Components: Universal Theme provides a rich set of UI components that can be used to create interactive and engaging applications. Some of the UI components include cards, lists, charts, calendars, maps, timelines, accordions, tabs, modals, alerts, and more.
Responsive Design: Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It ensures that the applications look good and work well on any device, from desktops to tablets to smartphones.
Easy Customization: Universal Theme allows developers to customize the appearance and behavior of their applications using template options and theme styles. Template options enable developers to apply different styles to components on a page without writing custom code. Theme styles enable developers to change the overall look and feel of the application by choosing from a variety of pre-built styles or creating their own.
質問 # 94
The APEX engine uses which component as a key for tracking each user's session state?
- A. APP_USER
- B. HTTP_USER
- C. LDAP_USER
- D. APEX_USER
正解：A
解説：
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.
質問 # 95
Which two of the following types can an end user save the customized Interactive report as?
- A. A private report
- B. Cannot save the report
- C. Default report
- D. A Public report
正解：A、D
質問 # 96
......
1Z0-770試験問題高合格率な1Z0-770問題集PDF：https://jp.fast2test.com/1Z0-770-premium-file.html