When testing the Data Load Wizard pages, you realize that you forgot to add a transformation rule. What should you do to add the transformation rule?

• A.Update Data Load Definition.
• B.Update the existing generated pages.
• C.Use the Create Page Wizard to re-create the pages.
• D.Delete Data Load Definition and re-create it manually.

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.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.
• C.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.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

Kyle is developing a page with an interactive report, called Employees, using this query:
SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO) On the page, Kyle adds a select list, called P3_DEPTNO, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.
Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?

• A.Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
• B.Add a computation set to p3_ DEPTNO
• C.Set a column on the DEPTNO column.
• D.Set "Page Items to Submit" to p3_deptho in the report.

Comment: *

Name: *

Email: *

Verification: *

Which four Oracle APEX region types can be created on top of a Web Source module?

• A.Classic Report
• B.Chart
• C.Tree
• D.Interactive Grid (non-editable)
• E.Interactive Grid
• F.Static Content
• G.Interactive Report
• H.List View
• I.List
• J.PL/SQL Dynamic Content

Comment: *

Name: *

Email: *

Verification: *

Sunny has developed a report and form on customers, which is open partners. The report displays only customers associated with partners, based on their user credentials.
Partners can click an Edit button to go to a form to update their customers.
Sunny Is concerned that IT savvy users will be able to to alter the URL to be able to see and Update records from other partners.
What must Sunny do to protect the form page from URL tampering?

• A.Set Authentication to Administrator Rights.
• B.Update Page Access Protection to Arguments Must Have Checksum.
• C.Update Page Access Protection to No URL Access.
• D.Set Rejoin Session to disabled.
• E.Set Deep Linking to Disabled.

Comment: *

Name: *

Email: *

Verification: *