Oracle From Questions

1) What is Data Block?

Ans) Data Block contains the Table and Columns. Will be used to INSERT/UPDATE/DELETE the records from the Form.

2) Types of Canvases?

Ans) a canvas is a surface inside a window. Where we can place the Layout objects like (Text, Radio button, Check box)

1) Content (Default)

2) Stacked

3) Vertical Tool bar

4) Horizontal Tool Bar

5) Tab

Content:  A content canvas is the "base" view that occupies the entire content pane of the window in which it is displayed.

 You must define at least one content canvas for each window you create.

Stacked Canvas: A stacked canvas is displayed on the content canvas assigned to the current window.

 It takes some part of content canvas.

We can hide this canvas programmatically   .

We can display more than one canvas at time in the window.

Tab Canvas A tab canvas made up of one or more tab pages

Allows you to group and display a large amount of related information on a single dynamic Form Builder canvas object.

Ex: we want to display Customer information, sites, tax, and bank account …..

We can use Tab canvas.

Tab canvases are displayed on top of a content canvas

Toolbar Canvas A toolbar canvas often is used to create toolbars for individual windows.

1. Horizontal toolbar canvases are displayed at the top of a window,

2. Vertical toolbars are displayed along the far left edge of a window.

Window:

A window is a container for all visual objects that make up a Form Builder application, including canvases.

A single form can include any number of windows.

Windows also can be displayed and closed programmatically.

1) Model Windows.

2) Modeless Windows.

A modal window (often a dialog) requires the end user to respond before continuing to work in the current application.

Modeless window requires no such response.

You can display multiple modeless windows at the same time

Modal property to Yes or No   No: Modeless Yes: Model

4) Types of Blocks?

1) Data block: Data blocks are associated with data (table columns) within a database.

2) Control Block: a control block is not associated with the database.

                         The items in a control block do not relate to table columns within a database.

Data blocks can also be Master Block and Detail Block

All blocks are either single-record or multi-record blocks

5) What are Master-detail Relation ship types?

1) Isolated

2) Non-Isolated (Default)

3) Cascade

Cascading          The master record can be deleted, and any associated detail records are automatically

deleted from the database at commit time. 

Isolated The master record can be deleted, but the associated detail records are not deleted from the database.

Non-Isolated      The default setting.  The master record cannot be deleted if associated detail records exist in the database.

On-Check-Delete-Master (Block Level)

On-Clear-Details              (Form Level)

On-Populate-Details        (Block Level)

 

Deferred:  (Yes) we have to execute detail block manually.

Automatic Query: No

(Deferred = Yes, Automatic Query = Yes)

Form Builder defers fetching the associated detail records until the end user navigates to the detail block.

Prevent Master less operation:  Specifies whether end users should be allowed to query or insert records in a block that is a detail block in a master-detail relation.

When set to Yes, Form Builder does not allow records to be inserted in the detail block

Record Group:

A record group is an internal Form Builder data structure that has a column/row framework similar to a database table.

2 types of record groups we have

1)      Static

2)      Query based

LOV: An LOV is a scrollable popup window that provides the end user with either a single or multi-column selection list.

5) How to set the block as Control Block?

Create Data Block

Change the property Database Data block: No