nerdexam
Oracle

1Z0-151 · Question #38

1Z0-151 Question #38: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.

Question

In the Orders form, users often have a need to return to the first record. Because there are many employee records, it may take a long time for them to scroll up to the first record, so you create a button with the label First Record. When users click the first Record button, you want to display your own custom message instead of the system message "FRM-40100: At first record." The system message should be displayed in other cases when users attempt to scroll above the first record. You code the following When-Button-Pressed trigger: :SYSTEM.mesage_level := '5' UP; WHILE FORM_SUCCESS LOOP UP; END LOOP; MESSAGE ('This is the first Order'); The button works perfectly to return to the first record and display your custom message instead of the system message. However, users report that as they continue to use the form after clicking the button, no longer see other helpful messages. For example, the message "FRM 40102: Record must be entered or deleted first" no longer appears when they attempt to scroll past the last record. How can you resolve this Issue so that all system messages continue to be displayed after the trigger code runs?

Options

  • Ainstead of setting the system message level to 5 in the code, set it to 50.
  • Binstead of setting the system message level to 5 in the code, set it to 25.
  • CAdd the line of code just before the end of the loop to reset the system message level.
  • DAdd a line of code just after the end of the loop to reset the system message level.
  • EInstead of setting the system message level in the When-Button-Pressed trigger, use an On- Error
  • FSet the system message level in a When-New-Form-Instance trigger, so that all system messages

Unlock 1Z0-151 to see the answer

You've previewed enough free 1Z0-151 questions. Unlock 1Z0-151 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-151 Practice