Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-750

Oracle 1z0-750 Exam Practice Questions (P. 5)

  • Full Access (71 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
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?
  1. A
    Feedback entered into the app can be viewed by developers in Team Development
  2. B
    When an administrator updates the feedback status, the person logging the feedback is notified
  3. C
    A new table is created in your schema to store the feedback for the app
  4. 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 #22
Which three are true about using REST Enabled SQL to access a remote database? (Choose three.)
  1. A
    Authentication must be done using the OAuth2 Client Credentials flow.
  2. B
    REST Enabled SQL must be enabled in the remote databases' ORDS configuration.
  3. C
    A wallet must be defined and configured on the remote database.
  4. D
    A REST Enabled SQL Reference must be created in Shared Components.
  5. E
    Authentication can be done using the remote database username and password.
  6. 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#HTMDB-GUID-0906921E-AF79-49D4-B909-1C090F805D9D

Question #23
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?
  1. A
    Set Start New Row to "Yes" and New Column to "Yes" for the Last Name item.
  2. B
    Set Start New Row to "No" for the Last Name item.
  3. C
    Set Column to "2" for the last Name item.
  4. D
    Set Column Span to "2" for the First Name item.

Correct Answer:
A

Question #24
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.)
  1. A
    Create a Dynamic Action of type Close Dialog that fires whenever the DELETE, SAVE, or CREATE button is pressed.
  2. B
    Change the action on the CANCEL button to "Defined by Dynamic Action."
  3. C
    Create a Dynamic Action of type Cancel Dialog that fires when the CANCEL button is clicked.
  4. D
    Add a Close Dialog process.
  5. E
    Add a branch that redirects to an item holding the calling page.
  6. F
    Create a hidden page item to hold the calling page and update the calls to the form page to populate the item.
  7. 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-demo-projects-2848027/APEX_Advanced_Demo_Projects%
20v2.0.1.html

Question #25
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?
  1. A
    Update P5_LOC and set Source Type to "Null".
  2. B
    Update P5_LOC and set Source Database Column to DEPTNO.
  3. C
    Update P5_LOC and set Source Type to Item and select Item P5_DEPTNO.
  4. D
    Update P5_LOC and set Save Session State to "No."
  5. E
    Update P5_DEPTNO and set Type to "Display Only."

Correct Answer:
A

Previous Questions Next Questions

All Pages