Free Oracle 1Z0-750 Exam Dumps Questions & Answers

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.Delete Data Load Definition and re-create it manually.
• B.Use the Create Page Wizard to re-create the pages.
• C.Update the existing generated pages.
• D.Update Data Load Definition.

Penny has created a special survey page, Pago 8, where she wants to hide the standard navigation menu.
Which two ways can Penny hide the navigation menu only for Page 8?

• A.Update the navigation menu and set condition of Never for Page 8?
• B.Delete the Navigation Menu region from Page 8.
• C.Set Override User Interface Level to Yes.
• D.Change Page Template to Minimal (No Navigation) for page 8.
• E.Go to Page Shared Components. Right-click the navigation menu entry and select Delete.
• F.Do not include page e in the list of pages In the navigation menu.

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

Lucy' created an interactive report on the EMP table. She wants to filter the report to show employees with JOB = SALESMAN'.

Which two options could Lucy perform to add an equals filter on the Job column?

• A.Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.
• B.Enter salesman in the search bar text box.
• C.Add a where clause to the SQL Query to restrict the records returned.
• D.Click the Search icon (magnifying glass) on the search bar, and enter SALESMAN in the search bar text box.
• E.Click the Job column and select salesman from the column filter list of values

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