1z0-750 practice test

1. Question 1 · 1

   Which three item types support defining a list of values? (Choose three.)

   Choose all answers that apply.

   • Color Picker
   • List Manager
   • File Browse
   • Text Field with autocomplete
   • Shuttle
   • Switch

2. Question 2 · 1

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

   Choose all answers that apply.

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

3. Question 3 · 1

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

   Choose one answer.

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

4. Question 4 · 1

   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?

   Choose one answer.

   • Click Appearance, and then click Choose New Icon
   • Click User Interface Defaults, and then select Edit Defaults
   • Edit the home page and click Select Icon
   • Click Advanced Settings, and then use the select list for Icon

5. Question 5 · 1

   Which is true interactive reports?

   Choose one answer.

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

6. Question 6 · 1

   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?

   Choose one answer.

   • Set stop processing to Yes for the P5_MGR is NOT NULL validation (Validation 1)
   • Ensure Validation 1 is listed before Validation 2
   • Add a server-side condition of P5_MGR is NOT NULL to the employee job validation (Validation 2)
   • Set Always Execute to No for the P5_MGR employee job validation (Validation 2)

7. Question 7 · 1

   Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product. For example, for Hedgers, he has defined the application item HEDGER_DEFECTS. How can Michael add the number of open defects in the navigation menu entries?

   Choose one answer.

   • Update the Navigation Menu template to be Include Count.
   • Update Template Options and set Display Count to True.
   • Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products.
   • Add &HEDGER_DEFECTS. to User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other products.

8. Question 8 · 1

   William has created the chart on the left, which displays values. He wants to show the chart on the right, which displays percentages. Which step should William perform to display percentages?

   Choose one answer.

   

   • Set the Column Mapping > Value to "Percentage".
   • Set Label > Display As to "Percentage".
   • Update the query to return percentage values.
   • Set Tooltip > Show Value to "No."

9. Question 9 · 1

   Bill has created a Maintain Customer form as shown in Exhibit 1. Now he wants the Last Name item to be next to the First Name item as shown in Exhibit 2. How can Bill achieve this?

   Choose one answer.

   

   

   • Set Start New Row to "Yes" and New Column to "Yes" for the Last Name item.
   • Set Start New Row to "No" for the Last Name item.
   • Set Column to "2" for the last Name item.
   • Set Column Span to "2" for the First Name item.

10. Question 10 · 1

    Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_LOC, and a change event dynamic action on P5_DEPTNO to populate the item using Set Value with this SQL: select loc from dept where deptno = :P5_DEPTNO; When Morgan runs the page, he gets this error: apex_error_code: WWV_FLOW_DML.COLUMN_NOT_FOUND - original message: Column LOC not found in table EMP What should Morgan do to prevent this error?

    Choose one answer.

    • Update P5_LOC and set Source Type to "Null".
    • Update P5_LOC and set Source Database Column to DEPTNO.
    • Update P5_LOC and set Source Type to Item and select Item P5_DEPTNO.
    • Update P5_LOC and set Save Session State to "No."
    • Update P5_DEPTNO and set Type to "Display Only."

11. Question 11 · 1

    Phil has been given the responsibility for an application that was developed years ago, because the original developer has left the company. End users have complained about accessibility because not all pages have titles. How can Phil ensure that he corrects all pages in the app without page titles?

    Choose one answer.

    • Run a query on the APEX_PAGE_DETAILS view where PAGE_TITLE is null
    • Use Application Advisor to perform a check
    • Ask end users to identify the problem pages
    • Bring up each page in Page Designer and review the Page Name

12. Question 12 · 1

    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?

    Choose one answer.

    • Set item name IR_DEPTNO and value to #DEPTNO#
    • Set item name to :P11_DEPTNO and value to :P10_DEPTNO
    • Set item name to :P11_DEPTNO and value to #DEPTNO#
    • Set item name to :P10_DEPTNO and value to #DEPTNO#

13. Question 13 · 1

    ABC Company developed an employee directly by using an interactive report. The HR 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?

    Choose one answer.

    • Add a control break on Department
    • Add a filter to the report
    • Save the report as a named report
    • Save the report as the primary report
    • Download the report to a CSV or HTML file

14. Question 14 · 1

    Betty has created a zip file, app100_files.zip, to include all of her static application files that she references in her application. The files are divided into different subdirectories for JavaScript and CSS. How can Betty upload the static files, so they can be referenced, and maintain the subdirectory structure?

    Choose one answer.

    • Unzip app100_files.zip, and upload each directory individually.
    • Upload app100_files.zip to the file server and unzip the file. In User Interface Properties, edit the Theme, and set JavaScript File URLs.
    • In Shared Components, create the required subdirectories. Unzip app100_files.zip, and upload each file into their subdirectories.
    • Upload app100_files.zip, and set Unzip File to Yes.

15. Question 15 · 1

    As a project manager, you use spreadsheets to keep track of multiple projects. As you took responsibility of more projects, you became tired of managing them in spreadsheets. You have collated all of your project data in one single spreadsheet. You also want to maintain the data in an Oracle Database table by using an Oracle APEX application. Which two actions can you take? (Choose two.)

    Choose all answers that apply.

    • Define a Data Loading page in the Create Application Wizard.
    • Use SQL Workshop > Utilities > Data Workshop to load the data into a new table, and then use the Create Application Wizard to create an application on the new table.
    • Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
    • Use the Create Application Wizard and select "From a Spreadsheet."
    • Create a new table by using SQL Workshop > Object Browser > Create Table, and then use the Create Application Wizard to create an application based on the new table.

Paid access to all 29 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.