Free Oracle 1Z0-750 Exam Dumps Questions & Answers

ABC Company developed an employee directory by using an Interactive report.
The HP. manager (an end user) has customized his or her report to show only employees In the HR department, and wants to review the same report weekly.
How can the HR manager achieve this?

• A.  Download the report to a CSV or HTML file.
• B.  Save the report as the primary report.
• C.  Save the report as a named report.
• D.  Add a control break on Department.
• E.  Add a filter to the report

What Is the least error-phone way to split a long list into two lists?

• A.  Create two new lists, copy list item from the initial list to the first, copy the remaining list items from the initial list to the second list, and then delete the initial list.
• B.  Create an empty second list, copy selected list items from the first to the second list, and then remove the copied items from the first list.
• C.  Copy the entries list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries the are now in the second list.
• D.  Create an empty second list, manually re-create the needed list entries, and then remove the matching list from the first list.

Susan created Page 10 as an interactive report, called Departments, on the DEPT table. She also created Page
11 as an interactive report on the EMP table, called Employees.
Susan would like to add a link in the Departments report (Page 10) that redirects to the Employees report (Page 11) and displays only employees for the selected department.
How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?

• A.  Set item name IR_DEPTNO and value to #DEPTNO#
• B.  Set item name to :P11_DEPTNO and value to #DEPTNO#
• C.  Set item name to :P10_DEPTNO and value to #DEPTNO#
• D.  Set item name to :P11_DEPTNO and value to :P10_DEPTNO

Which two are about an Editable'' interactive grid?

• A.  You can insert multiple records at a time.
• B.  All columns can be updated.
• C.  You can define a computation.
• D.  You can include dynamic actions on a column.
• E.  You can update only one record at a time.

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 Rejoin Session to disabled.
• B.  Set Authentication to Administrator Rights.
• C.  Update Page Access Protection to Arguments Must Have Checksum.
• D.  Set Deep Linking to Disabled.
• E.  Update Page Access Protection to No URL Access.