Oracle 1Z0-750 Online Practice Questions and Exam Preparation

Oracle 1Z0-750 Online Questions & Answers

• Question 51:

  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
  B. After Processing

  ---

  Reference: https://stackoverflow.com/questions/49449300/oracle-apex-submit-and-open-modal-in-the-same-time

• Question 52:

  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?

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

• Question 53:

  Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the instance.

  Which step should Jane perform in the Create Application Wizard?

  A. Under Authentication, select Single Sign On (SSO).
  B. Include a Sign-In page in the list of pages.
  C. Include the Access Control feature.
  D. Update Advanced Settings to specify authentication.
  A. Under Authentication, select Single Sign On (SSO).

  ---

  Reference https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-through-authentication.htm#HTMDB12003

• Question 54:

  Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, in the URL when calling another page. How can Trillian escape the item value so that the comma is interpreted correctly?

  A. /Donuts,Coffee/
  B. \Donuts,Coffee\
  C. Donuts\,Coffee
  D. "Donuts,Coffee"
  D. "Donuts,Coffee"

• Question 55:

  Which is true about interactive reports?

  A. Interactive reports can be either read-only or editable.
  B. All columns defined in the report query must be shown.
  C. You can define only one interactive report on a page.
  D. An interactive report can be based on a PL/SQL function body returning a SQL query.
  A. Interactive reports can be either read-only or editable.

  ---

  Reference: https://docs.oracle.com/database/apex-5.1/HTMDB/about-making-grids-editable.htm#HTMDB-GUID-0A317D17-5B12-4F4A-B5C8-68807DB5A4C1

• Question 56:

  Maurice wants to have a report on employees, which shows only employees or the department selected in a select list item. He has created a report, called REPORT_1, based on the EMP table. Above the region, he has defined a select list called P6_DEPTNO. Maurice has added the correct Where clause for REPORT_1 and defined an "on change" dynamic action on P6_DEPTNO to refresh the REPORT_1 region. When he runs the page, no data is displayed, irrespective of the department selected.

  What must Maurice do to get the page to work correctly?

  A. Add a set value action, before the refresh action, of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO.
  B. On the REPORT_1 region, set page items to submit to P6_DEPTNO.
  C. In the "on change" dynamic action, set page items to submit to P6_DEPTNO.
  D. In the "on change" dynamic action, set event scope to "dynamic".
  C. In the "on change" dynamic action, set page items to submit to P6_DEPTNO.

  ---

  Reference: https://docs.oracle.com/cd/E10513_01/appdev.310/e10497/rprt_query.htm#BABGAFID

• Question 57:

  Sam is updating an application with a report (Page 10) and form (Page 11), where the form page has Page Mode "Normal." She wants to update the form page to a modal dialog, so it can be called from multiple report pages.

  Sam has already changed Page Mode to "Modal Dialog", removed the breadcrumb region, added a button region to the dialog footer, and moved the buttons to the new region. Whenever she opens the form page from a different report page

  (Page 15), it keeps returning to the original report page (Page 10) when she cancels or submits the form page.

  Which three steps must Sam perform to get the modal page to always return to the report page from which it was called? (Choose three.)

  A. Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.
  B. Change the action on the CANCEL button to "Defined by Dynamic Action."
  C. Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
  D. Add a Close Dialog process.
  E. Add a branch that redirects to an item holding the calling page.
  F. Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.
  G. Update the branch to return to the correct calling page.
  B. Change the action on the CANCEL button to "Defined by Dynamic Action."
  C. Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
  D. Add a Close Dialog process.

  ---

  Reference: https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r50/apex-adv-demo-projects-2848027/APEX_Advanced_Demo_Projects%20v2.0.1.html

• Question 58:

  Robin develops many apps in his workspace that use various APEX plug-ins. Some apps use the same plug-in as other apps. When a newer version of a plug-in is available, Robin has to update the plug-in in multiple apps. How can Robin upgrade a plug-in once and have all other apps that use the same plug-in get updated at the same time?

  A. Run a SQL command to update the plug-in definition in each application.
  B. Write a PL/SQL package that he can reuse to update the plug-in definitions in each application.
  C. Update one of the plug-ins, and then click Push Update to update the other apps.
  D. Create a "Plug-ins Master" app where he stores all plug-ins and then subscribes the plug-ins in all of his other apps to the plug-ins in the "Plug-ins Master" app.
  B. Write a PL/SQL package that he can reuse to update the plug-in definitions in each application.

• Question 59:

  Which two actions can be done by a Page Process of type Automatic Row Processing (DML)? (Choose two.)

  A. Perform automatic detection of lost updates.
  B. Perform CRUD operations on multiple tables.
  C. Log a user-defined message when an exception is raised.
  D. Apply a SQL WHERE clause to append to all generated INSERT, UPDATE, and DELETE statements at run time.
  E. generate a primary key column value on a SQL INSERT statement.
  F. Invoke PL/SQL code to perform the inserts, updates, and deletes.
  D. Apply a SQL WHERE clause to append to all generated INSERT, UPDATE, and DELETE statements at run time.
  F. Invoke PL/SQL code to perform the inserts, updates, and deletes.

  ---

  Reference: https://docs.oracle.com/html/E39147_04/app_forms004.htm

• Question 60:

  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
  B. A developer can hide the search bar