D2K - What triggers are activated when master detailed relationship established?

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 47 of 71

What triggers are activated when master detailed relationship established?

Total Answers and Comments: 4

Last Update: July 02, 2008 Asked by: suhasshah2007

Sponsored Links

Best Rated Answer

—

Submitted by: Lavanya Chowdary

The triggers created when u establish a relation between two blocks r
on-clear-details(form level)
on-populate-details(master block level)
on-check-delete-master(master block level)
on-clear-details will be fired whenever u r clearing the master records.
on-populate-details will fire when ever ur executing the query for the master records.
on-check-delete-master fires whenever u r deleting the master records

Above answer was rated as good by the following members:
Binuthomas

May 06, 2007 08:44:14

Lavanya Chowdary

Member Since: May 2007 Contribution: 4

RE: what triggers are activated when master detailed r...

The triggers created when u establish a relation between two blocks r
on-clear-details(form level)
on-populate-details(master block level)
on-check-delete-master(master block level)
on-clear-details will be fired whenever u r clearing the master records.
on-populate-details will fire when ever ur executing the query for the master records.
on-check-delete-master fires whenever u r deleting the master records

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 03, 2007 07:20:02

joybanerjee

Member Since: November 2007 Contribution: 19

RE: What triggers are activated when master detailed relationship established?

on populate details
on clear details etc

Is this answer useful? Yes | No

January 26, 2008 16:12:41

kmtailor

Member Since: January 2008 Contribution: 2

RE: What triggers are activated when master detailed relationship established?

1) master delete property * NON-ISOLATED (default)a) on check delete masterb) on clear detailsc) on populate details * ISOLATEDa) on clear detailsb) on populate details * CASCADEa) per-deleteb) on clear detailsc) on populate details

Is this answer useful? Yes | No

July 02, 2008 01:11:55

shahnirav86

Member Since: July 2008 Contribution: 1

RE: What triggers are activated when master detailed relationship established?

1) Which trigger are created when master -detail rela?1) master delete property * NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details * ISOLATED a) on clear detailsb) on populate details * CASCADE a) per-deleteb) on clear details

c) on populate details

Nirav shah

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank