-
-
-
What are the three types of user exits available ?
Oracle Precompiler exits, Oracle call interface, NonOracle user exits.
-
How can values be passed bet. precompiler exits & Oracle call interface?
By using the statement EXECIAFGET & EXECIAFPUT.
-
How can I message to passed to the user from reports?
By using SRW.MESSAGE function.
-
What is a Text_io Package?
It allows you to read and write information to a file in the file system.
-
What is a User_exit?
Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.
-
What is synchronize?
It is a terminal screen with the internal state of the form. It updates the screen display to reflect the information that oracle forms has in its internal representation of the screen.
-
What is the difference between boiler plat images and image items?
Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are special types of interface controls that store and display either vector or bitmap images. Like other items that store values, image items can be either base table items(items that relate directly...
-
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 is the use of image_zoom built-in?
To manipulate images in image items.
-
What is a master detail relationship?
A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.
-
What is coordination Event?
Any event that makes a different record in the master block the current record is a coordination causing event.
-
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...
-
What are Most Common types of Complex master-detail relationships?
There are three most common types of complex master-detail relationships:master with dependent detailsmaster with independent detailsdetail with two masters
-
What are the different types of Delete details we can establish in Master-Details?
Cascade Isolate Non-isolate
-
What are the different default triggers created when Master Deletes Property is set to Non-isolated?
Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details
-
What are the different default triggers created when Master Deletes Property is set to Cascade?
Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete
-
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 blockcoordination should occur.
-
What is the User-Named Editor?
A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.
Oracle Concepts Interview Questions
Ans