Database Interview Questions
10 Apr, 2007
- What are the different display styles of list items? - Pop_list Text_list Combo box
- Which of the above methods is the faster method? - performing the calculation in the query is faster.
- With which function of summary item is the compute at options required? - percentage of total functions.
- What are parameters? - Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type char, number, date that you define at design time.
10 Apr, 2007
- What is an OLE? - Object Linking & Embedding provides you with the capability to integrate objects from many Windows applications into a single compound document creating integrated applications enables you to use the features form.
- Is it possible to modify an external query in a report which contains it? - No.
- Does a grouping done for objects in the layout editor affect the grouping done in the data model editor? - No.
- Can a repeating frame be created without a data group as a base? - No
10 Apr, 2007
- 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 isolated? - Master Deletes Property Resulting Triggers: Isolated 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 is the diff. bet. setting up of parameters in reports 2.0 reports2.5? - LOVs can be attached to parameters in the reports 2.5 parameter form.
10 Apr, 2007
- How is link tool operation different bet. reports 2 & 2.5? - In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.
- What are the different styles of activation of ole Objects? - In place activation, External activation
- How do you reference a Parameter? - In Pl/SQL, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = ‘’ or :block.item = PARAMETER Parameter name
10 Apr, 2007
- What are different types of modules available in oracle form? - Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application
- What is the remove on exit property? - For a modeless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.
