Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-750

Oracle 1z0-750 Exam Practice Questions (P. 3)

  • Full Access (71 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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. A
    &PAGE_ITEM
  2. B
    v("˜PAGE_ITEM')
  3. C
    APEX_UTIL.GET_SESSION_STATE(p_item => "˜PAGE_ITEM)
  4. D
    :PAGE_ITEM

Correct Answer:
C
Reference:
https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/GET_SESSION_STATE-Function.html#GUID-8BB0C252-C4DB-4300-
AA34-9E1FF3B2DAA7

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. A
    Include a join clause in the SQL Query attribute of the detail interactive grid region.
  2. B
    Enter the name of the foreign key constraint in the Detail Region Foreign Key Relationship attribute.
  3. C
    In the master region, select the correct region for the Detail Region attribute.
  4. D
    Make the master interactive grid region read-only.
  5. E
    Move the detail region below the master region.
  6. F
    In the detail region, select the correct region for the Master Region attribute.
  7. G
    In one of the columns of the detail region, select the related column of the master region for the Master Column attribute.

Correct Answer:
CG

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. A
    Go to Application Utilities > Templates and review the utilization report
  2. B
    Go to Shared Components > Templates, and select References for the given template
  3. C
    Go to Application Utilities > Cross Page Utilities and review Page Attributes
  4. D
    Run the Application Advisor and select Template Utilization

Correct Answer:
D
Reference:
https://docs.oracle.com/database/121/HTMDB/ui_templt.htm#HTMDB25621

Question #14
What is the least error-prone way to split a long list into two lists?
  1. A
    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. B
    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. C
    Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
  4. D
    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.

Correct Answer:
C

Question #15
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?
  1. A
    Click Appearance, and then click Choose New Icon
  2. B
    Click User Interface Defaults, and then select Edit Defaults
  3. C
    Edit the home page and click Select Icon
  4. D
    Click Advanced Settings, and then use the select list for Icon

Correct Answer:
A

Previous Questions Next Questions

All Pages