oracle 1z0-750 practice test

You want to use the session state value of a page item in the select statement 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

Ellie has two related interactive grids on a page. Which two steps must she perform to create a
master detail relationship between them?

• A. Include a join clause in the SQL Query attribute of the detail interactive grid region.
• B. Enter the name of the Foreign key constraint in the Detail Region Foreign Key Relationship attribute.
• C. In the master region, select the correct region for the Detail Region attribute.
• D. Make the master interactive grid read-only.
• E. Move the detail region below the master region.
• F. In the detail region, select the correct region for the Master region attribute.
• H. In one of the columns of the details region, select the related column of the master region for the Master Column attribute.

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.

You' have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

• A. Update the value aggregation to ‘’Percentage.’’
• B. Update the query to calculate the value divided by the total value.
• C. Update the y-axis format to percent.’’
• D. Update the show as percentage to ‘’yes.’’

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

• A. 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.
• B. 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.
• C. Create an empty second list, manually re-create the needed list entries, and then remove the matching list from the first list.
• D. 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.

Susan is building a new bug tracking application by using the Create Application Wizard. She wants to
change the icon on the Login screen to the ‘’app-icon-bug’’ image.
How can Susan change the icon?

• A. Click Appearance, and then click choose New Icon.
• B. Click User Interface defaults, and then select Edit Defaults.
• C. Edit the home page and click select Icon.
• D. Click Advanced Settings, and then use the select list for Icon.

Which is true about interactive reports?

• A. Subscription is supported only on primary reports.
• B. A developer can hide the search bar.
• C. A developer can delete a primary report.
• D. Only reports can be downloaded, not group by charts, or pivots.

Martin has a text field on a page that the wants to protect with session Satate protecton.
Select the four valid protection levels available to Martin.

• A. Checksum Required: User Level
• B. Hidden Item
• C. Checksum Required: Workspace Level
• D. Unrestricted
• E. Checksum NOT Required
• F. Checksum Required: Session Level
• G. Restricted: may not be set from browser
• H. Checksum required: Application Level

Which two are true about using the Create Page Wizard to create a report with "Report with Form on
Table"?

• A. The wizard builds two p3ges using an interactive grid page and a form page.
• B. The report and form must both be based on the same table or view.
• C. The wizard builds two pages, an interactive report page and a form page.
• D. The second page allows users to select the previous and next records.
• E. The first page allows users to update records.

Robert has a form page, Page 5, on the EMP table. He has defined two validations.
Validation 1 checks that P5_MGR is not null.
Validation 2 checks that the employee selected in P5_MGR has a job of PRESIDENT or MANAGER.
How can Robert prevent the employee job validation (Validation 2) from firing when the P5_MGR is
NOT NULL validation (Validation 1) has failed?

• A. Set stop processing to Yea for the P5_MGR is not null validation (Validation 1).
• B. Ensure Validation 1 is listed before Validation 2.
• C. Add a server-side condition of P5_MGR is not null to the employee Job validation (Validation 2).
• D. Set Always Execute to No for the P5_MGR employee Job validation (Validation 2).