Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 51:

  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?

  A. Set item name IR_DEPTNO and value to #DEPTNO#

  B. Set item name to :P11_DEPTNO and value to :P10_DEPTNO

  C. Set item name to :P11_DEPTNO and value to #DEPTNO#

  D. Set item name to :P10_DEPTNO and value to #DEPTNO#

  Correct Answer: C

• Question 52:

  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?

  A. Add a control break on Department

  B. Add a filter to the report

  C. Save the report as a named report

  D. Save the report as the primary report

  E. Download the report to a CSV or HTML file

  Correct Answer: D

• Question 53:

  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?

  A. Update P5_LOC and set Source Type to "Null".

  B. Update P5_LOC and set Source Database Column to DEPTNO.

  C. Update P5_LOC and set Source Type to Item and select Item P5_DEPTNO.

  D. Update P5_LOC and set Save Session State to "No."

  E. Update P5_DEPTNO and set Type to "Display Only."

  Correct Answer: A

• Question 54:

  Mary wants to add feedback to an application. She uses the Create Page Wizard, selects Features, and then selects Feedback. The wizard adds a feedback entry to the navigation bar and creates new pages, in her application, under Administration to review and disposition the feedback.

  Which statement is true about feedback data?

  A. Feedback entered into the app can be viewed by developers in Team Development

  B. When an administrator updates the feedback status, the person logging the feedback is notified

  C. A new table is created in your schema to store the feedback for the app

  D. You can invoke the feedback page from a modal dialog page

  Correct Answer: A

  Reference: https://docs.oracle.com/database/apex-5.1/HTMDB/managing-feedback.htm#HTMDB28146

• Question 55:

  Which three are true about using REST Enabled SQL to access a remote database? (Choose three.)

  A. Authentication must be done using the OAuth2 Client Credentials flow.

  B. REST Enabled SQL must be enabled in the remote databases' ORDS configuration.

  C. A wallet must be defined and configured on the remote database.

  D. A REST Enabled SQL Reference must be created in Shared Components.

  E. Authentication can be done using the remote database username and password.

  F. The application parsing schema must be REST enabled.

  Correct Answer: BDE

  Reference: https://docs.oracle.com/database/apex-18.1/HTMDB/rest-enabled-sql-creating.htm#HTMDBGUID-0906921E-AF79-49D4-B909-1C090F805D9D

• Question 56:

  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?

  A. Set Start New Row to "Yes" and New Column to "Yes" for the Last Name item.

  B. Set Start New Row to "No" for the Last Name item.

  C. Set Column to "2" for the last Name item.

  D. Set Column Span to "2" for the First Name item.

  Correct Answer: A

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

  Correct Answer: BCD

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

• Question 58:

  Robert has a form page, Page 5, on the EMP table. He has defined two validations.

  1.

  Validation 1 checks that P5_MGR is not null.

  2.

  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?

  A. Set stop processing to Yes for the P5_MGR is NOT NULL validation (Validation 1)

  B. Ensure Validation 1 is listed before Validation 2

  C. Add a server-side condition of P5_MGR is NOT NULL to the employee job validation (Validation 2)

  D. Set Always Execute to No for the P5_MGR employee job validation (Validation 2)

  Correct Answer: C

• Question 59:

  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?

  A. Set the Column Mapping > Value to "Percentage".

  B. Set Label > Display As to "Percentage".

  C. Update the query to return percentage values.

  D. Set Tooltip > Show Value to "No."

  Correct Answer: A

• Question 60:

  Martin has a text field on a page that he wants to protect with Session State Protection.

  Select the four valid protection levels available to Martin. (Choose four.)

  A. Checksum Required: User Level

  B. Hidden Item

  C. Checksum Required: Workspace Level

  D. Unrestricted

  E. Checksum Not Required

  F. Checksum Required: Session Level

  G. Restricted: May not be set from browser

  H. Checksum Required: Application Level

  Correct Answer: AFGH

  Reference: https://docs.oracle.com/database/121/HTMDB/sec_dev.htm#HTMDB25976