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

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

Comment: *

Name: *

Email: *

Verification: *

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"
• B.\Donuts,Coffee\
• C./Donuts,Coffee/
• D.Donuts\,Coffee

Comment: *

Name: *

Email: *

Verification: *

What is the least error-prone way to split a long list into two lists?

• A.Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
• B.Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
• C.Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.
• D.Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.

Comment: *

Name: *

Email: *

Verification: *

Taylor has created a report and form on the status table.
She wants only application administrator to be able to access the report and form.
What must she do to achieve this?

• A.Select authentication of Administrator Only.
• B.Add a before header validation.
• C.Select authorization scheme of Administration Rights
• D.Add a before header process.

Comment: *

Name: *

Email: *

Verification: *

Mark has created a modal form page to enter new calendar events. Mark now wants to call the form when an spot.
How can Mark update the calendar region to call the form?

• A.Define a dynamic action of type click in the calendar region.
• B.Use the view/edit link attribute to display the selected calendar entry.
• C.In the rendering tree, right-click the calendar region and select the Link Form to calendar option.
• D.Use the create link attribute and the APEXSNEW_START_DATE placeholder.
• E.Use the create link attribute and use the :APEXSNEW_STANT_DATE bind variable.

Comment: *

Name: *

Email: *

Verification: *