The Oracle 1Z0-770 Questions & Practice Test are Available On-Demand
Valid 1Z0-770 Exam Dumps Ensure you a HIGH SCORE
To prepare for the Oracle 1Z0-770 certification exam, candidates are recommended to have a strong understanding of SQL and PL/SQL, as well as experience with Oracle Database. In addition, Oracle provides training courses and study materials, including practice exams, to help candidates prepare for the exam.
NEW QUESTION # 74
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?
- A. Setting the Hide and Show Behavior attribute value to No Rescaling
- B. Setting the Hide and Show Behavior attribute value to None
- C. Setting the Hide and Show Behavior attribute value to Rescale
- D. Setting the on Data Change attribute value to slide to Left
Answer: A,C
Explanation:
Explanation
A bar chart is a type of chart that displays data as horizontal or vertical bars with lengths proportional to the values they represent. A bar chart can have one or more data series, which are groups of data points that share the same color and legend item. To enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked, you need to set the Hide and Show Behavior attribute value to either Rescale or No Rescaling. The Hide and Show Behavior attribute determines how the chart behaves when a data series is hidden or shown by clicking on its legend item. The possible values are:
None: The chart does not support hiding or showing data series by clicking on legend items.
Rescale: The chart supports hiding or showing data series by clicking on legend items, and rescales the axes accordingly.
No Rescaling: The chart supports hiding or showing data series by clicking on legend items, but does not rescale the axes. Setting the on Data Change attribute value to slide to Left will not affect the "hide and show" behavior of a data series in a bar chart. This attribute determines how the chart behaves when new data is loaded, such as when using dynamic actions or refresh actions. The possible values are:
None: The chart does not animate when new data is loaded.
Slide to Left: The chart slides to the left when new data is loaded.
Slide to Right: The chart slides to the right when new data is loaded. Verified References: [Creating Bar Charts - Oracle Help Center], [Bar Chart Attributes - Oracle Help Center]
NEW QUESTION # 75
You can create a report in which of the three following methods?
- A. Create a report from Object Browser
- B. Create a report when you create a new database application
- C. Create a report as a new page in an application
- D. Create a report region on a page in an application
Answer: B,C,D
Explanation:
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]
NEW QUESTION # 76
Choose from the below options the actions that can be performed when a button is clicked.
- A. Submit Page
- B. Redirect to a URL
- C. Redirect to a page in the same application
- D. All of them
- E. Redirect to a page in a different application
Answer: D
Explanation:
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.
NEW QUESTION # 77
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. Install Oracle APEX in the remote Oracle Database.
- B. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
- C. On the remote Oracle Database, install ORDS 19.x or later.
- D. Create a database link to the remote Oracle Database in the local APEX Schema.
Answer: B,C
Explanation:
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]
NEW QUESTION # 78
Which two statements are true about Maps in Oracle APEX?
- A. Maps support REST Enabled SQL
- B. Heat Map and Polygons are not supported Spatial geometry objects
- C. Maps don't support REST Data Sources
- D. Background maps do not require any API keys.
Answer: A,D
Explanation:
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.
NEW QUESTION # 79
In APEX, you can choose which three of the following Authentication methods?
- A. No Authentication
- B. Built-in Authentication Scheme
- C. Custom Authentication Scheme
- D. Authorization Scheme
Answer: A,B,C
Explanation:
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.
NEW QUESTION # 80
Select the three types of Facets you can create in APEX.
- A. Range
- B. Text Area
- C. Checkbox Group
- D. Input Field
Answer: A,C,D
Explanation:
Explanation
A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:
Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
Input Field: An input field facet displays a text field that users can enter text to filter the search results.
An input field facet does not have any values but uses an operator to compare the user input with the data.
NEW QUESTION # 81
Choose the three different ways in which you can add a checkbox to a page.
- A. Add a checkbox from the Property Editor
- B. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
- C. Use the context sensitive menu in the Gallery pane.
- D. Drag and drop the checkbox item into the Layout pane
Answer: B,C,D
Explanation:
Explanation
There are three different ways in which you can add a checkbox to a page in APEX:
Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.
Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.
NEW QUESTION # 82
Select the three types of Card Layout you can create in APEX.
- A. Float
- B. Horizontal(Row)
- C. Vertical(Column)
- D. Grid
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 83
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. Choose a condition in Format > Highlight
- C. Rows cannot be highlighted in an Interactive report
- D. Provide a conditional SQL query
Answer: B
Explanation:
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]
NEW QUESTION # 84
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. Scroll
- B. No Pagination
- C. Page and Scroll
- D. Page
Answer: C
Explanation:
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
NEW QUESTION # 85
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the database objects
- B. Move the images
- C. Move the application definition and all associated files
- D. Move the sessions data
Answer: A,B,C
Explanation:
Explanation
To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.
NEW QUESTION # 86
From SQL Workshop, you can perform which two of the following actions?
- A. Delete database
- B. Run SQL commands and scripts
- C. Create and view database objects
- D. Create an APEX user
Answer: B,C
Explanation:
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]
NEW QUESTION # 87
What are the three features of a calendar in APEX?
- A. Previous - Navigates to the previous month.
- B. Next - Navigates to the next month.
- C. Reminders - Displays the reminders set by the users
- D. Month, Week, Day - Displays a monthly, weekly and daily view.
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 88
Which of the following are preconfigured authentication schemes?
- A. HTTP Header Variables
- B. Social Sign In
- C. All of them
- D. LDAP Directory
- E. Open Door Credentials
Answer: C
Explanation:
Explanation
Oracle APEX provides several preconfigured authentication schemes that follow a standard behavior for authentication and session management. You can select a preconfigured authentication scheme from the gallery when you create an authentication scheme for your application. The preconfigured authentication schemes are:
Open Door Credentials: This scheme enables anyone to access your application using a built-in login page that captures a user name.
LDAP Directory: This scheme authenticates a user and password with an authentication request to a LDAP server.
HTTP Header Variable: This scheme authenticates users externally by storing the username in a HTTP Header variable set by the web server.
Social Sign-In: This scheme supports authentication with Google, Facebook, and other social networks that support OpenID Connector OAuth2 standards.
Oracle APEX Accounts: This scheme authenticates users against Oracle APEX user accounts that are created within and managed in the APEX user repository.
Custom Authentication: This scheme allows you to create a custom authentication scheme from scratch to have complete control over your authentication interface.
Database Accounts: This scheme authenticates users using database schema accounts.
Oracle Application Server Single Sign-On Server: This scheme delegates authentication to the Oracle AS Single Sign-On (SSO) Server.
SAML Sign-In: This scheme delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
NEW QUESTION # 89
You can apply an authorization scheme for which three of the following components?
- A. A page
- B. A session
- C. An entire application
- D. Specific control such as region,item or button
Answer: A,C,D
Explanation:
Explanation
You can apply an authorization scheme for the following components in APEX:
A specific control such as a region, item, or button. You can select an authorization scheme from the Authorization Scheme list on the attributes page of the control. This will control the rendering and processing of the control based on the user privileges12.
A page. You can select an authorization scheme from the Authorization Scheme list on the Security page of the page definition. This will control the access to the page based on the user privileges12.
An entire application. You can select an authorization scheme from the Authorization Scheme list on the Security Attributes page of the application definition. This will control the access to the entire application based on the user privileges12.
You cannot apply an authorization scheme for a session, as a session is not a component in APEX. A session is a stateful connection between a browser and the APEX engine that persists across multiple requests and responses3. You can control session security by using session state protection, session expiration, and session isolation4.
NEW QUESTION # 90
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?
- A. Data
- B. Filter
- C. columns
- D. Format
Answer: C
Explanation:
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]
NEW QUESTION # 91
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. The wizards load and unload all types of schema objects.
- D. You can load or unload multiple tables at a time.
Answer: B
Explanation:
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]
NEW QUESTION # 92
......
Oracle APEX Developer Professional certification exam covers a wide range of topics, including database design and development, SQL and PL/SQL, APEX architecture, and APEX development. 1Z0-770 exam is designed to test the candidate's ability to design, develop, and deploy APEX applications using the latest tools and technologies.
1Z0-770 Exam Practice Questions prepared by Oracle Professionals: https://www.examtorrent.com/1Z0-770-valid-vce-dumps.html
Pass 1Z0-770 Exam with Latest Questions: https://drive.google.com/open?id=10xiN2PfwsUkW8wXTynxE5ADNHIR0ZItH
