Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 31:

  In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful Services?

  A. Install the Sample REST Services packaged application.

  B. Navigate to the Shared Components section and configure a REST Enabled SQL resource.

  C. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.

  D. Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".

  Correct Answer: C

  Reference: https://docs.oracle.com/en/database/oracle/application-express/19.1/aeutl/accessing-RESTfulservices.html#GUID-DE5D8763-A650-4FBA-9CC5-17E141C8406C

• Question 32:

  Which four Oracle APEX region types can be created on top of a Web Source module? (Choose four.)

  A. Classic Report

  B. Interactive Report

  C. Chart

  D. Static Content

  E. List View

  F. Interactive Grid (non-editable)

  G. List

  H. Interactive Grid

  I. Tree

  J. PL/SQL Dynamic Content

  Correct Answer: BCHI

  Reference: https://blogs.oracle.com/apex/web-source-modules-and-the-interactive-grid-part-1

• Question 33:

  Which is a predefined authentication scheme in Oracle Application Express?

  A. Universal Authentication Framework (UAF)

  B. HTTP Header Variable

  C. SAML 2.0 Sign-On

  D. OpenID Connect Sign-On

  E. Client Certificate Authentication

  Correct Answer: B

  Reference: https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-throughauthentication.htm#HTMDB25774

• Question 34:

  Thomas has created an app and wants to add a help icon to the navigation bar. He has added the list entry with the Image/Class fa-question-circle-o and List Entry Label "Help". When he runs the app, the question mark is displayed together with the word Help.

  How can Thomas display just the icon and not the word Help in the navigation bar?

  A. Set List Attributes to style="display:none;"

  B. Set List Entry Label to "Null"

  C. Set User Defined Attribute 02 to icon-only

  D. Set List Entry Template to "Icon"

  Correct Answer: C

  Reference: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmdb/managingapplication-attributes.html

• Question 35:

  Fred created a parent/child relationship between the Employees and Departments.

  

  Fred wants to hide the Departments region. What should Fred do to achieve this?

  A. Set the Server-side Condition to "Never"

  B. Set the Road Only condition to "Always"

  C. Delete the region

  D. Set the Read Only condition to "Never"

  E. Set the Parent Region to "Null"

  Correct Answer: E

  Reference: https://docs.oracle.com/html/E39147_04/ui003.htm#CHDBAEEJ

• Question 36:

  Jim has developed a form page. When running the page, the data displayed is not what he expected. Therefore, he wants to review the information in session state while debugging the form.

  How can Jim accomplish this?

  A. View page source information in the browser.

  B. Click the Session button on the Developer toolbar.

  C. Add a debug flag to the URL and rerun the page.

  D. Click the View Debug button on the Developer toolbar.

  E. Edit the page and update session state items to "Display Only".

  Correct Answer: D

  Reference: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmdb/viewing-sessionstate.html#GUID-F218A21D-C153-4BCB-8FE9-51C7FAA13637

• Question 37:

  Which three sources can be used for a classic report? (Choose three.)

  A. RESTful Web Source module

  B. CSV (comma separated values) file

  C. PL/SQL function returning a SQL query

  D. PL/SQL function returning a single value variable

  E. SQL Query

  F. PL/SQL stored procedure with the OUT parameter

  G. Excel spreadsheet

  Correct Answer: ACE

• Question 38:

  Kyle is developing a page with an interactive report, called Employees, using this query:

  SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO)

  On the page, Kyle adds a select list, called P3_DEPTNO, using this query:

  SELECT dname, deptno FROM dept;

  He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.

  Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.

  What must Kyle do to correctly display only employees from the department selected?

  A. Add a computation set to P3_DEPTNO

  B. Add an additional true action of Set Value by using Static Assignment in Dynamic Action

  C. Set a column on the DEPTNO column

  D. Set "Page Items to Submit" to P3_DEPTNO in the report

  Correct Answer: B

• Question 39:

  Taylor has created a report and form on the STATUS table.

  She wants only application administrators to be able to access the report and form.

  What must she do to achieve this?

  A. Select authentication of Administrator Only

  B. Add a before header validation

  C. Add a before header process

  D. Select authorization scheme of Administration Rights

  Correct Answer: A

  Reference: https://docs.oracle.com/database/121/AEADM/E17965-08.pdf

• Question 40:

  Jules is trying to implement Session State Protection to increase the security of Jules' application.

  On which three components can Jules configure Session State Protection in Oracle Application Express? (Choose three.)

  A. pages

  B. page items

  C. page regions

  D. application items

  E. buttons

  F. page processes

  Correct Answer: ABD

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