Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?
Correct Answer: B
Explanation A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
1Z0-770 Exam Question 52
Which three statements are TRUE about Shared Components?
Correct Answer: A,B,D
Explanation Shared components are common elements that can be displayed or applied on any page within an application. Once you create a shared component, you can add them to any page within your APEX application. However, shared components are specific to each application and workspace, so you cannot add them to any page in any workspace4. Breadcrumbs, lists, and navigation bar entries are examples of shared components that can be used for navigation purposes4.
1Z0-770 Exam Question 53
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?
Correct Answer: C,E
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]
1Z0-770 Exam Question 54
Choose the two statements that are TRUE about the Universal Theme in APEX.
Correct Answer: B,C
Explanation The Universal Theme is a responsive user interface design for Oracle APEX applications. It has the following features: Responsive UI: The Universal Theme uses responsive design techniques to adapt to different screen sizes and orientations. It ensures that your applications look great and work well on any device, such as desktops, laptops, tablets, or smartphones. Easy customization: The Universal Theme allows you to customize the appearance and behavior of your applications using various tools and options. You can use Theme Roller to change the colors, fonts, icons, and styles of your applications. You can also use Template Options to modify the layout and functionality of your components. The other options are incorrect because: Not designed to work on tablets: The Universal Theme is designed to work on tablets as well as other devices. It uses responsive design techniques to adapt to different screen sizes and orientations. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme: The developers do not need to have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. They can use declarative tools such as Theme Roller and Template Options to customize their applications without coding. Verified References: [About Universal Theme] [Using Theme Roller] [Using Template Options]
1Z0-770 Exam Question 55
What are the three types of List of Values(LOV) you can create on a page?
Correct Answer: A,B,C
Explanation A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page: Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually. Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV. Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.