Database Administrator (DBA) Interview Preparation Guide

Download PDF

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

An object group is a container for a group of objects; you define an object group when you want to package related objects, so that you copy or reference them in other modules.

An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

Any event that makes a different record in the master block the current record is a coordination causing event.

At the client.

At the server.

Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

Because in a where clause the condition is applied during data retrieval, then after retrieving the data.

Before form , After form , Before report, Between page, After report.

Before report, Before form, After form , Between page, After report.

Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

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.

Boiler plate images, Image Items

By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

By setting the action associated with button to Execute pl/SQL option and using the SRW.Run_report function.

By setting the Restrict To List property to true in the parameter property sheet.

By using SRW.MESSAGE function.

By using the link file property in the layout boiler plate property sheet.

By using the rectangle tool while pressing the (Constraint) key.

By using the statement EXECIAFGET & EXECIAFPUT.

By using the tables/columns button and then specifying the table and the column names.

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.

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.

Cascade Isolate Non-isolate

Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.