Oracle 1z0-770 Actual Exam Questions

Last updated on July 2, 2025.

Topic 1 - Exam A

Question #1 Topic 1

Which two statements are true about customizing an interactive report by an end user? (Choose two.)

  • A. Standard Oracle functions cannot be added to columns.
  • B. A flashback query can be executed.
  • C. Mathematical computations can be added to columns.
  • D. From the Actions menu, multiple charts can be created.
Reveal Solution Hide Solution   Discussion  

Correct Answer: AC 🗳️

Question #2 Topic 1

Which is a valid method of logging messages to the execution log in APEX automation?

  • A. apex_error.add_error ( p_message => 'SAL for ' || :ENAME || ' increased by 1%.', p_displav_location => apex_error.c_inline_in_notification );
  • B. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
  • C. apex_automation.log_info('SAL for ' || :ENAME || ' increased by 1%.');
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #3 Topic 1

There is a validation of type Item is numeric on the Pl_SALARY item. When the page is submitted, this error message is displayed both in the notification and below the item:

What will cause the validation error to appear only in the Notification area?

  • A. Setting Display Location to Inline in Notification
  • B. Removing P1_SALARY from the validation Associated Item
  • C. Setting the Value Required to Yes on P1_SALARY
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #4 Topic 1

Which two are valid evaluation points for Authorization Schemes? (Choose two.)

  • A. Once per session
  • B. Once per user
  • C. Once per page view
  • D. Never
Reveal Solution Hide Solution   Discussion  

Correct Answer: AC 🗳️

file Viewing page 1 out of 15 pages.
Viewing questions 1-4 out of 57 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Loading ...