Oracle 1Z1-750 : Oracle Application Express 18: Developing Web Applications

Francisco has been tasked with creating a Frequently Asked Questions (FAQ) page. The page security requirements are defined as:
* Anyone who can access the application. In any capacity, shall also be able to view the new FAQ page.
Which page level Authorization Scheme and Authentication options should Francisco choose?

• A. Authorization Scheme: Null; Authentication: Page is Public
• B. Authorization Scheme: Must Not Be Public User; Authentication: Page Requires Authentication
• C. Authorization Scheme: {Not Reader Rights}; Authentication: Page Is Public
• D. Authorization Scheme: Reader Rights; Authentication: Page Requires Authentication

Sam is updating an application with a report (page 10) and form (page 11), where the form page has Page Mode "Normal." She wants to update the form page to a modal dialog, so it can be called from multiple report pages.
Sam has already changed Page Mode to "Modal Dialog." removed the breadcrumb region, added a button region to the dialog footer, and moved the buttons to the new region.
Whenever she opens the form page from a different report page (page is), it keeps returning to the original report page (Page 10) when she cancels or submits the form page.
Which three steps must Sam perform to get the modal page to always return to the report page from which it was called?

• A. Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
• B. Add a branch that redirects to an item holding the calling page.
• C. Change the action on the CANCEL button to "Defined by Dynamic Action."
• D. Add a Close Dialog process.
• E. Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.
• F. Update the branch to return to the correct calling page.
• G. Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.

In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS based RESTful Services?

• A. Navigate to the Shared Components section and configure a REST Enabled SQL resource
• B. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register schema with ORDS' button.
• C. Install the Sample REST Services packaged application.
• D. Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes."

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_Loc and set Source Type to "Null."
• B. Update P5_Loc and set Source Database Column to DEPTNO.
• C. Update P5_Loc and set Source Type to Item and select Item P5_DEPTNO.
• D. Update P5 DEPTNO and set Type to "Display Only."
• E. Update P5_Loc and set Save-Session State to "No."

John has a form page with an email item and a status item.
What must John do to ensure that the email Item is populated before users can enter any value into the status Item on the form page?

• A. server-side condition on the status item
• B. dynamic action on the email item
• C. validation on the email item
• D. plug-in for the status item