 |
| Transaction Processing |
1. You are developing a Human Resourced form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commit records, Forms displays the default informative message "FRM-40400: Transaction complete: <n> records applied and saved". You want to replace that with the message "Records inserted: <n> Records updated: <n> Records deleted: <n>, where <n> represents the number of records inserted, updated, and deleted". Which triggers must you create of modify to accomplish this?
A. On-Message only
B. Post-Commit and On-Message
C. Post-Database-Commit and On-Message
D. When-Validate-Record and On-Message
E. Post-Insert, Post-Update, Post-Delete, and On-Message
Answer: E
02. The items form contains the master detail relationship for inventory items and inventory stock available. Users may delete an inventory item if the QUANTITY_ON_HAND=0.
Which commit trigger can you use to implement a cascade delete for the item?
A. Post-Delete
B. Pre-Delete
C. Post-Forms-Commit
D. On-Delete
Answer: B
03. When does transaction processing occur?
A. When the user selects Action --->Post from the menu.
B. When the user selects Action --->Rollback from the menu.
C. When the COMMIT_FORM built-in is called from a trigger.
D. When the POST_CHANGES built-in is called from a trigger.
Answer: C
04. When a user updates the Salary item, you want to ensure that the net value is higher than the existing value before it is inserted into the base table.
Which trigger would you use?
A. Pre-Commit
B. On-Commit
C. Post-Update
D. Pre-Update
E. Post-Form-Commit
Answer: D
05. Which trigger can you use to ensure that no dependent detail rows have been inserted by another user since the master record was marked for deletion from a form?
A. Post-Insert
B. Pre-Update
C. Post-Delete
D. Pre-Delete
Answer: C
06. What trigger is necessary for implementing a cascading delete in a master-detail relation?
A. PRE-CASCADE
B. POST-CASCADE
C. PRE-DELETE
D. PRE-POST
E. PRE-UPDATE
Answer: C
0 Comments