Exam Details

  • Exam Code
    :1Z0-750
  • Exam Name
    :Oracle Application Express 18: Developing Web Applications
  • Certification
    :Oracle Database
  • Vendor
    :Oracle
  • Total Questions
    :77 Q&As
  • Last Updated
    :Apr 23, 2024

Oracle Oracle Database 1Z0-750 Questions & Answers

  • Question 61:

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

    A. The wizard builds two pages 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, and 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.

  • Question 62:

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

    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.

    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.

    C. Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.

    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.

  • Question 63:

    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

  • Question 64:

    Which is true 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

  • Question 65:

    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.)

    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 region 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.

    G. In one of the columns of the detail region, select the related column of the master region for the Master Column attribute.

  • Question 66:

    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?

    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

  • Question 67:

    Kim has defined a validation of "Item is NOT zero" on P5_SAL. When she runs the page, the error is displayed in the notification, but does not highlight the item or display the error below the item. Kim changes Display Location to "Inline with Field and Notification". However, the validation error still does not display under the item.

    What must Kim do to ensure that the validation error appears correctly under the item and also in the notification?

    A. Add JavaScript to the item to display on error

    B. Set Display Location to "Inline with Field"

    C. Set Value Required to Yes on P5_SAL

    D. Set Validation Associated Item to P5_SAL

  • Question 68:

    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. andPAGE_ITEM

    B. v(`PAGE_ITEM')

    C. APEX_UTIL.GET_SESSION_STATE(p_item => `PAGE_ITEM)

    D. :PAGE_ITEM

  • Question 69:

    John is evaluating an old APEX application that has over 20 tabular forms. He wants to update the application and replace all of the tabular forms with interactive grids.

    What is the fastest way for John to replace the old reports?

    A. Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new interactive grid.

    B. Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.

    C. Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid", select all, and then click Upgrade.

    D. Go to each report and change the type from Tabular Form to Interactive Grid.

  • Question 70:

    Jenny has a form page based on ORDER_ITEMS. For certain product types, she needs to redirect to a modal dialog page to ask for additional information, before validating or processing the record on page submission.

    Which processing point should Jenny select for the branch?

    A. Before Computations

    B. After Processing

    C. After Submit

    D. Processing

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-750 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.