Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
Correct Answer: B,D
Explanation An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as: End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings. End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc. The other options are incorrect because: End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu. End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu. Verified References: [About Interactive Reports] [About Interactive Grids]
1Z0-770 Exam Question 12
Which three of the following statements are TRUE about saved Public Interactive Grids?
Correct Answer: A,B,D
Explanation Public reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12
1Z0-770 Exam Question 13
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?
Correct Answer: B,D
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
1Z0-770 Exam Question 14
What are the three types of Master Detail Form you can create in APEX?
Correct Answer: B,C,D
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.
1Z0-770 Exam Question 15
Choose the statement that is TRUE about Universal Theme.
Correct Answer: C
Explanation Universal Theme is a responsive, versatile, and customizable user interface for your APEX apps. It is designed uniquely for Oracle APEX to make it easy for developers to build beautiful, modern applications, at any scale, for any purpose, that work on any device. All of the statements given are true about Universal Theme: Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript. Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It also provides a rich set of UI components, template options, and theme styles that can be used declaratively without writing custom code. Universal theme is the default theme that is shipped with Oracle APEX. Universal Theme is the default theme for new applications created in APEX 5.0 or later. It is also the recommended theme for upgrading existing applications to the latest version of APEX. Uses a 12-column grid layout system for arranging components on a page. Ships with a variety of pre-built theme styles. Universal Theme uses a 12-column grid layout system based on Flexbox to arrange components on a page. It also ships with a variety of pre-built theme styles that can be applied to change the look and feel of the application.