Oracle Interview Questions and Answers
Question - 201 : - What are the different modals of windows?
Answer - 201 : - Modalless windows
Modal windows
Question - 202 : - What are modal windows?
Answer - 202 : - Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.
Question - 203 : - What are the different default triggers created when Master Deletes Property is set to Non-isolated?
Answer - 203 : - Master Deletes Property Resulting Triggers
----------------------------------------------------
Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details
Question - 204 : - What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
Answer - 204 : - LOVs can be attached to parameters in the reports 2.5 parameter form.
Question - 205 : - What are the difference between lov & list item?
Answer - 205 : - Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.
Question - 206 : - What is the advantage of the library?
Answer - 206 : - Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, menu, or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.
Question - 207 : - What is lexical reference? How can it be created?
Answer - 207 : - Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.
Question - 208 : - What is system.coordination_operation?
Answer - 208 : - It represents the coordination causing event that occur on the master block in master-detail relation.
Question - 209 : - What is synchronize?
Answer - 209 : - 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.
Question - 210 : - What use of command line parameter cmd file?
Answer - 210 : - It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.