nerdexam
Oracle

1Z0-141 · Question #77

View the Exhibit. You are developing a Human Resources application. There is a query-only form that displays employee IDs, names, and department numbers. When users double-click an employee ID…

The correct answer is C. Requery the data in a When-Form-Navigate trigger of the query-only form. See the full explanation below for the reasoning.

Question

View the Exhibit. You are developing a Human Resources application. There is a query-only form that displays employee IDs, names, and department numbers. When users double-click an employee ID, another form opens displaying all the columns from the EMPLOYEES table so that users can update the records (as shown in the exhibit). You use a global variable to pass the value for Employee_Id to the update form. When users modify the name and exit the update form, how can you synchronize the data in the query-only form so that the new name is displayed?

Exhibit

1Z0-141 question #77 exhibit

Options

  • ARequery the data in a When-New-Form-Instance trigger of the query-only form.
  • BRequery the data in a Pre-Form trigger of the query-only form.
  • CRequery the data in a When-Form-Navigate trigger of the query-only form.
  • DPass the new name value in a global variable from the update form to the query-only form and
  • EPass the new name value in a global variable from the update form to the query-only form and
  • FPass the new name value in a global variable from the update form to the query-only form and

How the community answered

(24 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    83% (20)
  • F
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice