Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_LOC, and a change event dynamic action on P5_DEPTNO to populate the item using Set Value with this SQL:
select loc from dept
where deptno = :P5_DEPTNO;
When Morgan runs the page, he gets this error:
apex_error_code:
WWV_FLOW_DML.COLUMN_NOT_FOUND
original message: Column LOC not found in table EMP
What should Morgan do to prevent this error?

Molly has created a multi-series chart on the EMP table that shows the average salary per job in each department.
The chart below is not showing the data correctly because there are no Analysis or Salesmen In Department 10.

How must Molly update the chart to correctly display the data?

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?

Jules is trying to implement Session State Protection to increase the security of rules' application. On which three components can Jules configure Session State Protection in Oracle Application Express?