Nancy has an application that is performing unexpectedly. She has turned on debug for the page and reviewed the debug messages and still can’t determine the cause of the inconsistent behavior. She believes it may be an APEX bug. What…
Bob has created an interactive report on the EMP table. Oracle BI Publisher has been configured as the report server in his environment. He has been asked to output a high-fidelity PDF report, which lists all employees. How can Bob…
Which is true about interactive reports? A. Interactive reports can be either read-only or editable. B. All columns defined in the report query must be shown. C. You can define only one interactive report on a page. D. An interactive…
You have defined a form page on the ORDERS table and changed page item :P5_ORDER_TOTAL to type Hidden. You also created a dynamic action to update the value of :P5_ORDER_TOTAL when any order items are added, updated, or deleted on…
A City Administration app has two select lists (LOVs). P1_STATE is based on “STATE” and P1_CITY is based on “CITY”. The CITIES table includes both the STATE and CITY columns. When a state is selected, the application should display only…
Mary is using an APEX Interactive Grid report that has many columns and wants to see the most important information while minimizing horizontal scrolling. Which three actions will help her to best accomplish this goal? (Choose three.) A. Define a…
You created an application where the home page looks like: You now want to change the page to look like: What do you need to do to change the appearance of the page? A. Update the region Type to “List…
Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, in the URL when calling another page. How can Trillian escape the item value so that the comma is interpreted correctly? A. /Donuts,Coffee/…
Francisco has been tasked with creating a Frequently Asked Questions (FAQ) page. The page security requirements are defined as: Anyone who can access the application, in any capacity, shall also be able to view the new FAQ page. Which page…
Jason has developed an app for maintaining customers. He has a navigation menu for customers that he needs to associate with multiple pages. How can Jason associate one list entry with multiple pages? A. Set List Entry Current for Pages…