2024 Valid 1Z0-770 test answers & Oracle Exam PDF
Free Oracle 1Z0-770 Exam Questions and Answer from Training Expert Prep4pass
NEW QUESTION # 25
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, select COMM for "Allowed Row Operations Column".
- C. Set EMPNO, ENAME to "Display Only".
- D. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
Answer: A,D
Explanation:
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]
NEW QUESTION # 26
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?
- A. Format
- B. Filter
- C. columns
- D. Data
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 # 27
In APEX, you can choose which three of the following Authentication methods?
- A. Custom Authentication Scheme
- B. No Authentication
- C. Built-in 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 # 28
Choose the three Form types that you can create using the Create Page wizard.
- A. Interactive Report
- B. Interactive Grid
- C. Master Detail
- D. Form
Answer: B,C,D
Explanation:
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.
NEW QUESTION # 29
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. SQL Query
- B. Procedure
- C. Select List
- D. Function Returning SQL Query
Answer: A,D
Explanation:
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
NEW QUESTION # 30
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. Data Workshop
- C. App Builder
- D. Quick SQL
Answer: B
Explanation:
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.
NEW QUESTION # 31
Which statement is true about creating and using a report with form?
- A. The Create Page Wizard doesn't support the creation of a classic report and formcombination
- B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
- C. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- D. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
Answer: D
Explanation:
Explanation
You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on. Verified References: [Creating a Report Using the Create Page Wizard - Oracle], [Creating a Report with Form on Table - Oracle]
NEW QUESTION # 32
Which two statements that are TRUE about charts in Interactive grid?
- A. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- B. Once a chart is created, you can switch the view between Grid and Chart view.
- C. You can create multiple charts at a time in an interactive grid
- D. Once the chart is created, it cannot be reconfigured.
Answer: A,B
Explanation:
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
NEW QUESTION # 33
You can apply an authorization scheme for which three of the following components?
- A. A page
- B. An entire application
- C. A session
- D. Specific control such as region,item or button
Answer: A,B,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 # 34
Which two statements are true about the generated SQL?
- A. Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.
- B. Creates EMPLOYEES table with 4 columns
- C. Inserts 10 rows of random sample data into the DEPARTMENTS table
- D. Creates DEPARTMENTS table with 2 columns
Answer: B,D
Explanation:
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
NEW QUESTION # 35
Which is a valid Page Process type?
- A. Execute JavaScript Code
- B. Send E-Mail
- C. Set Value
Answer: C
Explanation:
Explanation
A page process type defines what action the page process performs when it is executed. There are many page process types available in Oracle APEX, such as Execute PL/SQL Code, Data Loading, Branch, etc. One of the valid page process types is Set Value. The Set Value page process type sets session state for an item or items on a page using a computation or PL/SQL expression. You can use this page process type to assign values to items based on logic or conditions. The other options are not valid page process types. Execute JavaScript Code is a dynamic action type, not a page process type. Send E-Mail is an application process type, not a page process type. Verified References: [Understanding Page Processes - Oracle Help Center], [Set Value Process Type - Oracle Help Center]
NEW QUESTION # 36
Which is NOT a valid Geometry Column Data Type available for maps region?
- A. GeoJSON
- B. JSON_OBJECT
- C. Latitude/Longitude
- D. SDO_GEOMETRY
Answer: B
Explanation:
Explanation
The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database.
Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region. Verified References: About Supported MapsEditing Maps
NEW QUESTION # 37
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
- A. Cascading LOV
- B. Popup LOV
- C. Static LOV
- D. Dynamic LOV
Answer: A
Explanation:
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
NEW QUESTION # 38
Which two layout options are available for Page Designer under Utilities?
- A. Four Pane Mode
- B. Two Pane Mode
- C. Three Pane Mode
- D. Single Pane Mode
Answer: B,D
Explanation:
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]
NEW QUESTION # 39
Which statement is true about Theme Styles in Oracle APEX?
- A. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
- B. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
- C. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
Answer: C
Explanation:
Explanation
Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences. Verified References: Using Themes and Theme Styles - Oracle Help Center, Theme Styles - Oracle APEX
NEW QUESTION # 40
Select the three ways in which you can create a Form in APEX.
- A. Using the Create Application Wizard
- B. Using Shared Components
- C. Using the Create Page wizard
- D. Create a Form region in Page Designer
Answer: A,C,D
Explanation:
Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.
NEW QUESTION # 41
What are the three types of Master Detail Form you can create in APEX?
- A. Side by Side
- B. Stacked
- C. Two Page Drill Down
- D. One Below the other
Answer: A,B,C
Explanation:
Explanation
A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database.
Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:
Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.
NEW QUESTION # 42
Select the two places from where you can access the Shared Components Page?
- A. Gallery
- B. Application homepage
- C. SQL Workshop
- D. Page Designer
Answer: B,D
Explanation:
Explanation
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.
NEW QUESTION # 43
What three are the building blocks of Approvals Component?
- A. Task Definition
- B. Task Details Page
- C. Automations
- D. Unified Task List
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 44
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Create Authorization schemes
- B. Add Users
- C. Assign roles to users
- D. Create new application roles
Answer: B,C
Explanation:
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]
NEW QUESTION # 45
Which two statements are true about loading data from the "Create an Application From a File" wizard?
- A. XML and JSON data can be pasted and loaded.
- B. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
- C. A sample data set from the sample list can be uploaded.
- D. Data from remote web services can be uploaded.
- E. Seed data from a SQL script can be uploaded.
Answer: B,C
Explanation:
Explanation
The "Create an Application From a File" wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are:
A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc.
CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc. VerifiedReferences: [Creating an Application From a File - Oracle Help Center], [Creating an Application Based on Sample Data Sets - Oracle Help Center]
NEW QUESTION # 46
Choose the three types of aggregations you can apply on a column.
- A. Standard Deviation
- B. Count
- C. Average
- D. Sum
Answer: B,C,D
NEW QUESTION # 47
......
Top Oracle 1Z0-770 Courses Online: https://www.prep4pass.com/1Z0-770_exam-braindumps.html
1Z0-770 Practice Dumps - Verified By Prep4pass Updated 144 Questions: https://drive.google.com/open?id=1h0sveFbXXSub9pF2v4uK0MWZdPelK2qA
