Oracle DBA Interview Questions Part 5

What is a timer?

Timer is an “internal time clock” that you can programmatically create to perform an action each time the times.

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

What are Most Common types of Complex master-detail relationships?

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

What is a text list?

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 values that are not displayed.

What is term?

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

What is use of term?

The term file which key is correspond to which oracle report functions.

What is pop list?

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.

What is the maximum no of chars the parameter can store?

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

What are the default extensions of the files created by library module?

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

What are the Coordination Properties in a Master-Detail relationship?

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

How do you display console on a window?

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned. To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

What are the different Parameter types?

Text ParametersData Parameters

State any three mouse events system variables?  System.mouse_button_pressedSystem.mouse_button_shift

What are the types of calculated columns available?

Summary, Formula, Placeholder column.

Explain about stacked canvas views?

Stacked canvas view is displayed in a window on top of, or “stacked” on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

What are the built_ins used the display the LOV?

Show_lov List_values

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

 Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the text item before the built-in is executed.

What are the built-ins that are used to Attach an LOV programmatically to an item?

 set_item_property get_item_property (by setting the LOV_NAME property)