Pass Oracle 1Z0-770 Exam Quickly With FreeCram
Prepare 1Z0-770 Question Answers - 1Z0-770 Exam Dumps
Oracle 1Z0-770 exam consists of 75 multiple-choice questions that need to be completed within 150 minutes. 1Z0-770 exam covers a wide range of topics, including Oracle APEX architecture, page processing, data loading and manipulation, security, and more. Passing the exam requires a strong understanding of Oracle APEX, as well as practical experience in developing and deploying applications using this platform. By obtaining the Oracle APEX Developer Professional certification, developers can showcase their skills and expertise to potential employers and clients, opening up new career opportunities and increasing their earning potential.
NEW QUESTION # 15
You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?
- A. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
- B. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
- C. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
- D. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
Answer: B
Explanation:
Explanation
d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this:
UPDATE events
SET start_date = :APEX.NEW_START_DATE,
end_date = :APEX.NEW_END_DATE
WHERE id = :APEX.PK_VALUE;
NEW QUESTION # 16
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. Page and Scroll
- B. Page
- C. Scroll
- D. No Pagination
Answer: A
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 # 17
Which three statements are TRUE about Search Configuration?
- A. One or more Search Configurations can be configured in a Search Page.
- B. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- C. Only one Search Configuration can be used in a Search Page.
- D. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 18
You can apply an authorization scheme for which three of the following components?
- A. An entire application
- B. Specific control such as region,item or button
- C. A page
- D. A session
Answer: A,B,C
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 # 19
Which statement is true about the Approvals component?
- A. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
- B. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
- C. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- D. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
Answer: B
Explanation:
Explanation
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.
NEW QUESTION # 20
Which statement is true about Unified Task List in the Approvals component?
- A. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- 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 shared component used to configure task parameters, participants, actions, and due dates.
Answer: B
Explanation:
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]
NEW QUESTION # 21
Which statement is true about using the App Gallery?
- A. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- B. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- C. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
- D. Custom Apps are only available if your instance administrator has enabled them.
Answer: D
Explanation:
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
NEW QUESTION # 22
What are the three types of Master Detail Form you can create in APEX?
- A. Side by Side
- B. One Below the other
- C. Stacked
- D. Two Page Drill Down
Answer: A,C,D
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 # 23
Select the two advantages of using One-click Remote Deployment.
- A. Deploy the app, and explicitly install the supporting objects in one-click.
- B. Simplify the process of deploying an application
- C. You need to access your production environment to import the app directly.
- D. Directly deploy your app definition along with the objects from the source system to the target system
Answer: A,D
Explanation:
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.
NEW QUESTION # 24
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?
- A. Page Validation
- B. Page Rendering
- C. Page Refresh
- D. Page Processing
Answer: A,D
Explanation:
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process
NEW QUESTION # 25
An application includes a report and form on the PRODUCTS table.
The form page includes page items P21 PRODUCT NAME and P21_UNIT_PRICE.
P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
Now, you need to reposition the items and display P21 UNIT_PRICE next to P21_PRODUCT_NAME.
Which two statements are true?
- A. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
- B. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.
- C. In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.
- D. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.
Answer: A,B
Explanation:
Explanation
To reposition the page items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME, you can use either of these methods:
In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21_PRODUCT_NAME. This method allows you to visually arrange the items on the page layout.
In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes. This method changes the attribute of the item to start a new row in the grid layout. The other options, A and D, are incorrect because they would not achieve the desired result. Setting Start New Row to Yes for P21_PRODUCT_NAME would move it to a new row, not next to P21_UNIT_PRICE. Right-clicking P21_UNIT_PRICE and selecting Start New Row would not change the attribute of the item, but only move it to a new position in the Layout tab. Verified References: Positioning Page ItemsLayout Tab
NEW QUESTION # 26
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 rendering and processing
- B. Page compilation
- C. Page Rendering
- D. Page Processing
Answer: A
Explanation:
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.
NEW QUESTION # 27
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle XE
- B. All of the above
- C. Microsoft Azure
- D. Oracle Autonomous Cloud
- E. Amazon RDS
Answer: B
Explanation:
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
NEW QUESTION # 28
An Employees App includes a form to enter and update employee details.
Examine this Exhibit.
Now you must extend the functionality of this form so that:
* If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed
* If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?
- A. Create a dynamic action on P2_HIREDATE and P2_COMM.
- B. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
- C. ......... and enter SALESMAN for Value.
- D. Create a dynamic action on P2_JOB.
- E. Create a dynamic action on form load.
Answer: C,D
Explanation:
Explanation
To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows:
Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action.
Set Name to Show/Hide Hire Date and Commission.
Set Event to Change.
Set Selection Type to Item(s).
Set Item(s) to P2_JOB.
Set Condition Type to Equal To.
Set Value to SALESMAN.
Add two true actions by clicking the Add True Action button twice.
For the first true action, set Action to Show.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second true action, set Action to Show.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
Add two false actions by clicking the Add False Action button twice.
For the first false action, set Action to Hide.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second false action, set Action to Hide.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex - OrclQA.Com], [Managing Dynamic Actions - Oracle Help Center]
NEW QUESTION # 29
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. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- C. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
- D. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
Answer: C
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 # 30
Select the three types of Card Layout you can create in APEX.
- A. Grid
- B. Float
- C. Horizontal(Row)
- D. Vertical(Column)
Answer: A,B,C
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 # 31
What are the required fields while creating a Chart in APEX?
- A. Name
- B. Label Column
- C. Value Column
- D. All of them
- E. Data Source
Answer: D
Explanation:
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.
NEW QUESTION # 32
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. Select List
- B. Procedure
- C. Function Returning SQL Query
- D. SQL Query
Answer: C,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 # 33
Which two of the following types can an end user save the customized Interactive report as?
- A. Cannot save the report
- B. A Public report
- C. Default report
- D. A private report
Answer: B,D
NEW QUESTION # 34
Which is a valid Page Process type?
- A. Send E-Mail
- B. Set Value
- C. Execute JavaScript Code
Answer: B
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 # 35
......
Real Oracle 1Z0-770 Exam Questions [Updated 2024]: https://www.freecram.com/Oracle-certification/1Z0-770-exam-dumps.html
Free 1Z0-770 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1UBAQSRBOzWvspyv7Owsyu-i5ttkDrxrT