Database Interview Questions
10 Apr, 2007
- What are the trigger associated with image items? - When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item
- What are the different windows events activated at runtimes? - When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variable system. event_window to determine the name of the window for which the trigger fired.
- When do you use data parameter type? - When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogram.
10 Apr, 2007
- What are the vbx controls? - Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.
- What is the use of transactional triggers? - Using transactional triggers we can control or modify the default functionality of the oracle forms.
- How do you create a new session while open a new form? - Using open_form built-in setting the session option Ex. Open_form (’Stocks ‘,active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False
10 Apr, 2007
- 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.
10 Apr, 2007
- 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
10 Apr, 2007
- How do you call other Oracle Products from Oracle Forms? - Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.
- What is the main diff. bet. Reports 2.0 & Reports 2.5? - Report 2.5 is object oriented.
- What are the different file extensions that are created by oracle reports? - Rep file and Rdf file.
