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

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 Save-Session State to "No."
• B. Update P5_Loc and set Source Type to "Null."
• 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 Source Database Column to DEPTNO.

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

Carl's has created a new region template as a copy of the Standard region template in Universal Theme. He wants to update the template, but is not sure how often the template is used throughout the application.
How can Carl determine all the pages where his custom template is used?

• A. Go to Application utilities > templates and review the utilization report.
• B. Go to Shared Components > Templates, and select References for the given template.
• C. Go to Application Utilities > Cross Page Utilities and review Page Attributes.
• D. Run the Application Advisor and select Template Utilization.

As a project manager, you use spreadsheets to keep track of multiple projects. As you took-responsibility of more projects, you become tired of managing them in spreadsheets.
You have collected all of your project data in one single spreadsheet. You also want to maintain the data in an Oracle Database table by using an Oracle Apex application.
Which two action can you take?

• A. Define a Data Loading page in the Create Application Wizard.
• B. Use SQL Workshop >Utilities > Data Workshop to load the data into a new table, and then use the Create Application wizard to create an application on the new table.
• C. Create a new table by using SQL Workshop > Object Browser .Create Table, and then use the Create Application Wizard to Create an application based on the new table.
• D. Use the Create Application Wizard and select ''From a Spreadsheet.''
• E. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.

Which is Hue about interactive reports?

• A. You can define only one Interactive report on a page.
• B. Interactive reports can be either read-only or editable.
• C. All columns defined In the report query must be shown.
• D. An Interactive report can be based on a PL/SQL function body returning a SQL query.