The following are some useful Oracle Forms questions and answers for the fresher and advanced level users. These rapid-fire questions and answers can be used to take quick interviews and are helpful for both interviewer and the candidates.
Blocks are logical containers that have no physical representation?
True.
A single block can be connected to multiple database objects like a table, view or synonym?
False.
When a frame associated with a block, the items in the block are automatically arranged within the frame?
True.
Scrollbar for a block can be attached to a block only at the time of block creation?
False.
Is a window connected to a block?
False.
Every form contains at least one block, one window, one canvas, and one or more items?
True.
Which three types of compilation Oracle Forms builder provides?
- Full Compilation
- Incremental Compilation
- Selective Compilation
When a new form is created, forms builder creates which object by default?
A window named Window0.
The enabled and visible property of an item cannot be disabled at runtime if the cursor is on that item.
True.
The pre-form trigger fires before the when-new-form-instance trigger?
True.
The when-validate-item trigger cannot have navigational code like next_item, next_block, etc.
True.
By default, the type of canvas is content?
True.
A control block is created by using a block wizard?
False.
The new_record procedure creates a New record at runtime?
False.
Execute_Query retrieves rows from the table and displays the first record on the form?
True.
Messagebox() is used to display messages on the status bar?
False.
A where clause that uses operators other than '=', can be created by entering '&' in any test item on the form?
True.
Which two types of layouts are allowed in Oracle Forms?
Form and Tabular.
Which function is used to set window property at runtime?
Set_window_property().
Which property used to set to open a window in maximized mode?
Forms_mdi_window.
What values are returned by system.form_status variable?
- QUERY
- NEW
- CHANGED
Multiple level property inheritance is not allowed in Oracle Forms?
False.
A property class can be created from an existing object?
True.
There is a fixed number of properties defined for a Visual Attributes.
True.
The Named visual attribute can be changed at runtime?
False.
Which property is used to change Visual attribute at runtime?
Current_Record_Attribute.
If a PL/SQL subprogram exists in a library and a PL/SQL subprogram with the same name also resides program unit in the form, only the subprogram in the libraries will get executed?
False.
Can an alert have a maximum of five buttons?
False.
When is a library attached to a form the PL/SQL blocks included in the library are included in the form file?
False.
Which function is used to display the Alert?
Show_Alert().
Which three types of alerts available in Oracle Forms?
- Stop
- Caution
- Note
Visual attributes and property classes help in maintaining standards of the objects placed within the form?
True.
Object libraries allow the creation of objects stored within them?
False.
An object library path is stored along with the file name when the library objects are referenced in the form?
False.
The master-detail relationship can be set only if the foreign key / primary key is defined at the table level?
False.
An LOV can be connected to the Display Item?
False.
An LOV is created by specifying static values for an LOV?
False.
If ON DELETE CASCADE is specified at the time of defining a foreign key, the delete record behavior property must not be set to Cascading?
True.
The updatable property cannot be set for the objects if the Canvas property is set to Null?
True.
Database Item property must be set to 'No' if the item is not connected to a base table column?
True.
Prompt adjustment edge property is used to determine the position of the label relative to the associated item?
True.
To change the list of values dynamically at runtime, the automatic refresh property must be set to true?
False.
What values are returned by the system.record_status Variable?
- NEW
- INSERT
- CHANGED
- QUERY
