Oracle Interview Questions – Part 5
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.
Q.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.
Q.What is difference between open_form and call_form?
when one form invokes another form by executing open_form the first form remains displayed, and operators can navigate between the forms as desired. when one form invokes another form by executing call_form, the called form is modal with respect to the calling form. That is, any windows that belong to the calling form are disabled, and operators cannot navigate to them until they first exit the called form.
Q.What is new_form built-in?
When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.
Q.What is trigger associated with the timer?
Q.What is the “LOV of Validation” Property of an item? What is the use of it?
When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.
Q.What are the two types of views available in the object navigator(specific to report 2.5)?
View by structure and view by type .
Q.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 products invoked with the run_product built-in subprogram.
Q.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
Q.What are visual attributes?
Visual attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.
Q.What is the use of image_zoom built-in?
To manipulate images in image items.
Q.What is use of term?
The term file which key is correspond to which oracle report functions.
Q.What is the use of transactional triggers?
Using transactional triggers we can control or modify the default functionality of the oracle forms.
Q.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 upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
Q.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 multiple forms with open form and call_form in the same application, state whether the following are true/False
Q.What are the ways to monitor the performance of the report?
Use reports profile executable statement. Use SQL trace facility.
Q.If two groups are not linked in the data model editor, What is the hierarchy between them?
Two group that is above are the left most rank higher than the group that is to right or below it.
Q.What is the purpose of the product order option in the column property sheet?
To specify the order of individual group evaluation in a cross products.
Q.What is the diff. when confine mode is on and when it is off?
When confine mode is on, an object cannot be moved outside its parent in the layout.
Q.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.
Q.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
Q.How do you reference a parameter indirectly?
To indirectly reference a parameter use the NAME IN, COPY ‘built-ins to indirectly set and reference the parameters value’ Example name_in (‘capital parameter my param’), Copy (‘SURESH’,’Parameter my_param’)
Q.What is a timer?
Timer is an “internal time clock” that you can programmatically create to perform an action each time the times.
Q.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.
Q.What is the diff. when Flex mode is mode on and when it is off?
When flex mode is on, reports automatically resizes the parent when the child is resized.
Q.Which of the two views should objects according to possession?
view by structure.
Q.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
Q.An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
Q.Explain about horizontal, Vertical tool bar canvas views?
Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window
Q.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 undisplayed values.
Q.State any three mouse events system variables?
Q.What is term?
The term is terminal definition file that describes the terminal form which you are using r20run.
Q.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.
Q.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.
Q.What are the types of calculated columns available?
Summary, Formula, Placeholder column.
Q.What are the Coordination Properties in a Master-Detail relationship?
The coordination properties are
These Properties determine when the population phase of block
coordination should occur.
Q.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.
Q.How does one do off-line database backups? (for DBA )
Shut down the database from sqlplus or server manager. Backup all files to secondary storage (eg. tapes). Ensure that you backup all data files, all control files and all log files. When completed, restart your database.
Do the following queries to get a list of all files that needs to be backed up:
select name from sys.v_$datafile;
select member from sys.v_$logfile;
select name from sys.v_$controlfile;
Sometimes Oracle takes forever to shutdown with the “immediate” option. As workaround to this problem, shutdown using these commands:
alter system checkpoint;
Note that if you database is in ARCHIVELOG mode, one can still use archived log files to roll forward from an off-line backup. If you cannot take your database down for a cold (off-line) backup at a convenient time, switch your database into ARCHIVELOG mode and perform hot (on-line) backups.
Q.What are the different Parameter types?
Text ParametersData Parameters
Q.What are the built-ins that are used to Attach an LOV programmatically to an item?
(by setting the LOV_NAME property)