nerdexam
Oracle

1Z0-151 · Question #25

View the exhibit. In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set…

The correct answer is A. The cursor successfully navigates to the first record. SCROLL_UP built-in Scrolls the current block's list of records so that previously hidden records with lower sequence numbers are displayed. This action displays records that were "above" the block's display.SCROLL_UP puts the input focus in the instance of the current item in…

Design Considerations for PL/SQL Code

Question

View the exhibit. In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No. You are coding a When-Button-Pressed trigger for the First Record button with the following code:

SCROLL_UP; WHILE FORM_SUCCESS LOOP SCROLL_UP; END LOOP; What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?

Exhibit

1Z0-151 question #25 exhibit

Options

  • AThe cursor successfully navigates to the first record.
  • BA runtime error is encountered because there is no scroll bar for the block.
  • CThe display scrolls so that the first record is visible, bur the cursor stays on the last visible record,
  • DThe form goes into an infinite loop and has to be killed by using operating system commands.
  • Einternal navigation to the first record occurs, but the visible cursor remains on record 72.
  • FBecause there is no scroll bar, the cursor navigates only as far as the first visible record, which is record 63.

How the community answered

(17 responses)
  • A
    71% (12)
  • C
    6% (1)
  • D
    6% (1)
  • F
    18% (3)

Explanation

SCROLL_UP built-in Scrolls the current block's list of records so that previously hidden records with lower sequence numbers are displayed. This action displays records that were "above" the block's display.SCROLL_UP puts the input focus in the instance of the current item in the displayed record that has thehighest sequence number.

Topics

#SCROLL_UP#When-Button-Pressed#block navigation#loop behavior

Community Discussion

No community discussion yet for this question.

Full 1Z0-151 Practice