In a few sentences, describe the main differences between a post-query and a when-new-record-instance trigger. When does it make sense to use one and not the other?

For each of the given situations, where would be the most appropriate place to put the described trigger?

1. A when-new-form-instance trigger to populate global variables shared by all blocks

1. Form Level
2. Block Level
3. Item Level

1. A when-new-block-instance trigger to automatically populate each block as it is navigated to

1. Form Level
2. Block Level
3. Item Level

1. A post-query trigger to calculate the sum of a number of items in a block and display the result in a display item

1. Form Level
2. Block Level
3. Item Level

1. A when-new-item-instance trigger containing a null statement that overrides a form level when-new-item-instance trigger highlighting an item. The form level trigger should be overridden only for one particular item

1. Form Level
2. Block Level
3. Item Level

1. A pre-delete trigger that always asks the user whether he/she is sure that the current record should be deleted, regardless of the current block

1. Form Level
2. Block Level
3. Item Level

1. What is the correct nautical term for the big bulbous thing that hangs off the bottom of a sailboat in order to keep it stable when under way?

1. Barnacle
2. Keel
3. Anchor
4. Jimmy Hoffa

1. What is the correct nautical term for the bathroom on a sailboat?

1. Latrine
2. Outhouse
3. Head
4. Stateroom

1. When cruising around the world a yacht should always fly the following flag:

1. The Jolly Roger
2. A "Terrible Towel"
3. The flag of your favorite baseball team
4. The flag of the country where the boat is from

1. Which of the following would be the most logical to wear in the event you are thrown overboard?

1. A straight jacket
2. A life vest
3. A pair of sailing gloves
4. A baseball cap

1. A powerboat and a sailboat under sail are on a collision course in the middle of Lake Erie. Which has the right of way?

1. The powerboat
2. The sailboat
3. Whichever boat is bigger
4. Whoever wins at playing "chicken"

Assume that your boat table (TBL_BOATS) includes the following columns:

Boat_Id Number

Boat_Name Varchar2(15)

Sold Varchar2(1) '0' = No, '1' = Yes

Also, assume that your customer table (TBL_CUSTOMERS) includes the following columns:

Cust_Id Number

First_Name Varchar2(10)

Last_Name Varchar2(15)

Boat_Id Number

Note: assume that each customer can only own one boat and that each boat has an owner.

Finally, there is a third, empty table (TBL_NEW_OWNERS) that has the following columns:

Boat_Name Varchar2(15)

Owner_First Varchar2(10)

Owner_Last Varchar2(15)

Write a procedure that takes no arguments which does the following:

Use a cursor and a loop to parse through all rows of boats that have been sold. For each sold boat, find the customer first and last names, and insert the boat name, first name and last name into the TBL_NEW_OWNERS table. Finally, make sure you commit the results to the database.