Oracle Interview Questions and Answers

Answer - 151 : - Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.

Answer - 152 : - 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.

Answer - 153 : - There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

Answer - 154 : - The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.

Answer - 155 : - The term is terminal definition file that describes the terminal form which you are using r20run.

Answer - 156 : - The term file which key is correspond to which oracle report functions.

Answer - 157 : - The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

Answer - 158 : - The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

Answer - 159 : - The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

Answer - 160 : - The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur.