What are the two phases of block coordination?
There are two phases of block coordination; the clear phase and the population phase. During the clear phase, Oracle forms navigates internally to the detail block and flushes the obsolete detail records. During the population phase, oracle forms issues a SELECT statement to repopulate the details block with the detail records associated with the new master record. These operations are accomblished through the execution og triggers. 24. what are most common types of complex master_detail relationship? There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters 25. What arethe different types of Delete details we can establish in Master-Details? Cascade Isolate Non-Isolate 26.
