Home » Other » Training & Certification » Reg Triggers-Which is the correct answer
Reg Triggers-Which is the correct answer [message #168390] Thu, 20 April 2006 03:18 Go to next message
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.

Re: Reg Triggers-Which is the correct answer [message #168414 is a reply to message #168390] Thu, 20 April 2006 04:54 Go to previous message
Frank Naude
Messages: 4564
Registered: April 1998
Senior Member
C sounds about right. Try to test it yourself to verify the answer.

- Start SQL*Plus
- Create the 3 tables
- Create a triggers on GROSS_RECEIPT and one on ADVANCED_RECEIPT to update THEATER.TOTAL_GROSS.
Previous Topic: Triggers Objective Question
Next Topic: ocp qn. for performance tuning : Resource Manager rules
Goto Forum:
  


Current Time: Sat Apr 04 17:41:35 CDT 2020