There is a query only form that displays employee ids

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ower of Knowing 1Z0-141 You are developing a Human Resourced 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? A. Requery the data in a When-New-Form-Instance trigger of the query-only form. B. Requery the data in a Pre-Form trigger of the query-only form. C. Requery the data in a When-Form-Navigate trigger of the query-only form. D. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-New-Form-Instance trigger of the query-only form. E. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a Pre-Form trigger of the query-only form. F. Pass the new name value in a global variable from the update form to the query-only form and assign it to the appropriate name item in a When-Form-Navigate trigger of the query-only form. Answer: C QUESTION 56: The Orders form has two Record Groups: the SHIP Record Group that was created at design time, and the SOLD Record Group that was created at run time. You are required to write a Program Unit that will delete both Record Groups. Which two statements describe your situation? (Choose two) A. You cannot delete Record Group SOLD at run time. B. You cannot delete Record Group SHIP at run time. C. You should delete Record Group SOLD with built-in DELETE_GROUP('SOLD'); D. You should delete Record Group SHIP with built-in DELETE_GROUP('SHIP'); E. You should delete Record Group SOLD with built-in DELETE_GROUP_ROW(SOLD',ALL_ROWS); Actualtests.com - The Power of Knowing 1Z0-141 F. You should delete Record Group SHIP with built-in DELETE_GROUP_ROW(SHIP',ALL_ROWS); Answer: B,C QUESTION 57: The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other errors: IF message_code = 40100 THEN MESSAGE('You are already at the first record'); ELSE MESSAGE(message_type || '-' ||...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online