Database Interview Questions
10 Apr, 2007
- What are the various sub events a mouse double click event involves? - What are the various sub events a mouse double click event involves? - Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
- How can a break order be created on a column in an existing group? - What are the various sub events a mouse double click event involves? - By dragging the column outside the group.
10 Apr, 2007
- What are the different types of Delete details we can establish in Master-Details? - Cascade Isolate Non-isolate
- What is relation between the window and canvas views? - Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.
- 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.
10 Apr, 2007
- What are different types of images? - Boiler plate images, Image Items
- 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 to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actually associated with an image item until the item is populate at run time.
10 Apr, 2007
- What is an LOV? - An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.
- At what point of report execution is the before Report trigger fired? - After the query is executed but before the report is executed and the records are displayed.
- What are the built -ins used for Modifying a groups structure? - ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)
- What is an user exit used for? - A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.
9 Apr, 2007
- What is a physical page? What is a logical page? - A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.
- What does the term panel refer to with regarda to pages? - A panel is the number of physical pages needed to print one logical page.
- 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.
