| Reg Triggers-Which is the correct answer [message #168390] |
Thu, 20 April 2006 03:18  |
ssrividhya
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
The TOTAL_GROSS column of the THEATER table can be derived from the GROSS_RECEIPT and ADVANCED_RECEIPT tables. Which implementation will you use to keep the TOTAL_GROSS column synchronized with changes to the GROSS_RECEIPT and ADVANCED_RECEIPT tables?
a. Create one database trigger to update the TOTAL_GROSS whenever the tables are modified.
b. Create one package that will execute implicitly to update the TOTAL_GROSS column whenever the tables are modified.
c. Create two database triggers, one for each table, to update the TOTAL_GROSS column whenever the tables are modified.
d. Add a deferred referential constraint on the TOTAL_GROSS column. This will reference the two tables and will automatically keep the TOTAL_GROSS column synchronized.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
