Database Administrator (DBA) Question:
Download Questions PDF

What are the two phases of block coordination?

Answer:

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 detail block with detail records associated with the new master record. These operations are accomplished through the execution of triggers.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What is a timer?What are Most Common types of Complex master-detail relationships?