1z0-750

1z0-750 practice questions, page 3 of 3, with answer review and explanations.

Question 11

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?

  1. &PAGE_ITEM
  2. v("˜PAGE_ITEM')
  3. APEX_UTIL.GET_SESSION_STATE(p_item => "˜PAGE_ITEM)
  4. :PAGE_ITEM

Question 12

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

  1. Include a join clause in the SQL Query attribute of the detail interactive grid region.
  2. Enter the name of the foreign key constraint in the Detail Region Foreign Key Relationship attribute.
  3. In the master region, select the correct region for the Detail Region attribute.
  4. Make the master interactive grid region read-only.
  5. Move the detail region below the master region.
  6. In the detail region, select the correct region for the Master Region attribute.
  7. In one of the columns of the detail region, select the related column of the master region for the Master Column attribute.

Question 13

Carl 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 of the pages where his custom template is used?

  1. Go to Application Utilities > Templates and review the utilization report
  2. Go to Shared Components > Templates, and select References for the given template
  3. Go to Application Utilities > Cross Page Utilities and review Page Attributes
  4. Run the Application Advisor and select Template Utilization

Question 14

What is the least error-prone way to split a long list into two lists?

  1. Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.
  2. Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
  3. Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
  4. Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.