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 cities within the selected state, not all cities.How can you limit the cities to display only those for the selected state?
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 the page.However, when you submit the page, you get this error:Session state protection violation: This may be caused by manual alteration of protected page item P5_ORDER_TOTAL. If you are unsure what caused this error, please contact the application administrator for assistance.How should you update :P5_ORDER_TOTAL page item to prevent this error?
Which is true about interactive reports?
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 define the report?
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 action should Nancy take to identify the issue?
