Download Oracle.1z0-750.Test4Prep.2020-05-04.27q.vcex

Download Exam

File Info

Exam Oracle Application Express 18-Developing Web Applications
Number 1z0-750
File Name Oracle.1z0-750.Test4Prep.2020-05-04.27q.vcex
Size 323 KB
Posted May 04, 2020
Download Oracle.1z0-750.Test4Prep.2020-05-04.27q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 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?


  1. Update the Navigation Menu template to be Include Count.
  2. Update Template Options and set Display Count to True.
  3. Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products.
  4. Add &HEDGER_DEFECTS. to User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other products.
Correct answer: C



Question 2

Which three actions can be performed by a workspace administrator? (Choose three.)


  1. Add space to a schema
  2. View usage reports for a workspace
  3. Manage user accounts
  4. Monitor workspace activity
  5. Manage workspace to schema assignments
  6. Approve workspace requests
Correct answer: CDF
Explanation:
Reference: https://docs.oracle.com/cd/E14373_01/admin.32/e13371/wrkspc.htm#AEADM101
Reference: https://docs.oracle.com/cd/E14373_01/admin.32/e13371/wrkspc.htm#AEADM101



Question 3

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?


  1. 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.
  2. Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
  3. Use the Upgrade Application utility and select the candidate objects listed for “Upgrade Tabular Form to Interactive Grid”, select all, and then click Upgrade.
  4. Go to each report and change the type from Tabular Form to Interactive Grid.
Correct answer: D
Explanation:
Reference: https://community.oracle.com/thread/3937159?start=0&tstart=0
Reference: https://community.oracle.com/thread/3937159?start=0&tstart=0



Question 4

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?


  1. Before Computations
  2. After Processing
  3. After Submit
  4. Processing
Correct answer: B
Explanation:
Reference: https://stackoverflow.com/questions/49449300/oracle-apex-submit-and-open-modal-in-the-same-time
Reference: https://stackoverflow.com/questions/49449300/oracle-apex-submit-and-open-modal-in-the-same-time



Question 5

Brian created a page with multiple regions. He now wants to include a list of links to selectively display each region. 
  
How can Brian achieve this?


  1. Create a region of type Region Display Selector, and ensure that each region has Region Display Selector set to “Yes”.
  2. Create a parent region called REGIONS. For each region, update the Parent Region attribute to REGIONS.
  3. Create a list in Shared Components containing each region. Create a region of type List and associated the list created.
  4. Define static IDs for each region. Create a region called REGIONS of type Static Content with named anchors to other regions.
Correct answer: A



Question 6

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?


  1. Add JavaScript to the item to display on error
  2. Set Display Location to “Inline with Field”
  3. Set Value Required to Yes on P5_SAL
  4. Set Validation Associated Item to P5_SAL
Correct answer: B
Explanation:
Reference: https://stackoverflow.com/questions/57100939/display-error-message-inline-with-field-in-oracle-apex-interactive-grid
Reference: https://stackoverflow.com/questions/57100939/display-error-message-inline-with-field-in-oracle-apex-interactive-grid



Question 7

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
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/GET_SESSION_STATE-Function.html#GUID-8BB0C252-C4DB-4300-AA34-9E1FF3B2DAA7
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 8

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.
Correct answer: C



Question 9

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. Click Appearance, and then click Choose New Icon
  2. Click User Interface Defaults, and then select Edit Defaults
  3. Edit the home page and click Select Icon
  4. Click Advanced Settings, and then use the select list for Icon
Correct answer: A



Question 10

Which is true interactive reports?


  1. Subscription is supported only on primary reports
  2. A developer can hide the search bar
  3. A developer can delete a primary report
  4. Only reports can be downloaded, not group by, charts, or pivots
Correct answer: B









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files