Rick has created an "editable" interactive grid on a table that includes four audit columns: CREATED, CREATED_BY, UPDATED, and UPDATED_BY.
The four audit columns are included in the report with read-only type set to Always.
How can Rick update all four audit columns when a user inserts a row, and the UPDATEDand UPDATED_BY columns when a user updates a row?

• A.using After Header Computations
• B.defining an After Submit process
• C.using "Enable" Dynamic Actions
• D.using default values on the report columns

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_DEPTNOto 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_LOCand set Save Session State to "No."
• E.Update P5_DEPTNO and set Type to "Display Only."

Comment: *

Name: *

Email: *

Verification: *

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 15), 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? (Choose three.)

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

Comment: *

Name: *

Email: *

Verification: *

You want to use the session state value of a page item in the SELECTstatement for a report on another page.
What is the correct way to reference the value of a page item in a SQL statement?

• A.&PAGE_ITEM
• B.v('PAGE_ITEM')
• C.APEX_UTIL.GET_SESSION_STATE(p_item => 'PAGE_ITEM)
• D.:PAGE_ITEM

Comment: *

Name: *

Email: *

Verification: *

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: Reader Rights; Authentication: Page Requires Authentication
• B.Authorization Scheme: Must Not Be Public User; Authentication: Page Requires Authentication
• C.Authorization Scheme: Null; Authentication: Page is Public
• D.Authorization Scheme: {Not Reader Rights}; Authentication: Page Is Public

Comment: *

Name: *

Email: *

Verification: *