Martin has a text field on a page that he wants to protect with Session State Protection.
Select the four valid protection levels available to Martin. (Choose four.)

• A.Checksum Required: User Level
• B.Hidden Item
• C.Checksum Required: Workspace Level
• D.Unrestricted
• E.Checksum Not Required
• F.Checksum Required: Session Level
• G.Restricted: May not be set from browser
• H.Checksum Required: Application Level

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Update P5 DEPTNO and set Type to "Display Only."
• B.Update P5_Loc and set Source Type to Item and select Item P5_DEPTNO.
• C.Update P5_Loc and set Save-Session State to "No."
• D.Update P5_Loc and set Source Database Column to DEPTNO.
• E.Update P5_Loc and set Source Type to "Null."

Comment: *

Name: *

Email: *

Verification: *

You can control when an authorization scheme is validated by using the Evaluation Point. Select three valid Evaluation Points.

• A.once per session
• B.once per region
• C.once per page view
• D.once per day
• E.always (no caching)
• F.once per user

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Update the x-axis Baseline Scaling to "Fixed."
• B.Update the Series Column Mapping for Series Name to DEPTNO.
• C.Set Fill Gaps in Chart Data to "Yes."
• D.Update group by In the chart SQL Query.

Comment: *

Name: *

Email: *

Verification: *

William has created the chart on the left, which displays values.
He wants to show the chart on the right, which displays percentages.

Which step should William perform to display percentages?

• A.Update the query to return percentage values.
• B.Set the Column Mapping > Value to "Percentage".
• C.Set Label > Display As to "Percentage".
• D.Set Tooltip > Show Value to "No."

Comment: *

Name: *

Email: *

Verification: *