SYSTEM VARIABLES

SYSTEM VARIABLES

47. List the system variables related in Block and Field?

1. System.block_status
2. System.current_block
3. System.current_field
4. System.current_value
5. System.cursor_block
6. System.cursor_field
7. System.field_status.

48. What is the difference between system.current_field and system.cursor_field ?

1. System.current_field gives name of the field.
2. System.cursor_field gives name of the field with block name.

49. The value recorded in system.last_record variable is of type
a. Number
b. Boolean
c. Character.
b. Boolean.

User Exits :

50. What is an User Exits ?

A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.

51. What are the type of User Exits ?

ORACLE Precompliers user exits
OCI (ORACLE Call Interface)
Non-ORACEL user exits.

Page :

52. What do you mean by a page ?

Pages are collection of display information, such as constant text and graphics.

53. How many pages you can in a single form ?

Unlimited.

54. Two popup pages can appear on the screen at a time ?
a. True b. False

a. True.

55.What is the significance of PAGE 0 in forms 3.0 ?

Hide the fields for internal calculation.

56. Deleting a page removes information about all the fields in that page ?
a. True. b. False

a. True.

Popup Window :

57. What do you mean by a pop-up window ?

Pop-up windows are screen areas that overlay all or a portion of the
display screen when a form is running.

58. What are the types of Pop-up window ?

the pop-up field editor
pop-up list of values
pop-up pages.

Alert :

59. What is an Alert ?

An alert is window that appears in the middle of the screen overlaying a portion of the current display.


FORMS 4.0

01. Give the Types of modules in a form?

Form
Menu
Library

02. Write the Abbreviation for the following File Extension
1. FMB 2. MMB 3. PLL

FMB ----- Form Module Binary.
MMB ----- Menu Module Binary.
PLL ------ PL/SQL Library Module Binary.

03. What are the design facilities available in forms 4.0?

Default Block facility.
Layout Editor.
Menu Editor.
Object Lists.
Property Sheets.
PL/SQL Editor.
Tables Columns Browser.
Built-ins Browser.

04. What is a Layout Editor?

The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.

05. BLOCK

05. What do you mean by a block in forms4.0?

Block is a single mechanism for grouping related items into a functional unit for storing,displaying and manipulating records.

06. Explain types of Block in forms4.0?

Base table Blocks.
Control Blocks.
1. A base table block is one that is associated with a specific database table or view.
2. A control block is a block that is not associated with a database table.

ITEMS

07. List the Types of Items?

Text item.
Chart item.
Check box.
Display item.
Image item.
List item.
Radio Group.
User Area item.

08. What is a Navigable item?

A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing a navigational
built-in procedure.

09. Can you change the color of the push button in design time?

No.

10. What is a Check Box?

A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".

11. What are the triggers associated with a check box?

Only When-checkbox-activated Trigger associated with a Check box.

PL/SQL

Basiscs of PL/SQL

1. What is PL/SQL ?
PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.

2. What is the basic structure of PL/SQL ?

PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

3. What are the components of a PL/SQL block ?

A set of related declarations and procedural statements is called block.

4. What are the components of a PL/SQL Block ?

Declarative part, Executable part and Execption part.

Datatypes PL/SQL

5. What are the datatypes a available in PL/SQL ?

Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN.
Some composite data types such as RECORD & TABLE.

6. What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

% TYPE provides the data type of a variable or a database column to that variable.

% ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor.

The advantages are : I. Need not know about variable's data type
ii. If the database definition of a column in a table changes, the data type of a variable changes accordingly.

7. What is difference between % ROWTYPE and TYPE RECORD ?

% ROWTYPE is to be used whenever query returns a entire row of a table or view.

TYPE rec RECORD is to be used whenever query returns columns of different
table or views and variables.

E.g. TYPE r_emp is RECORD (eno emp.empno% type,ename emp ename %type
);
e_rec emp% ROWTYPE
cursor c1 is select empno,deptno from emp;
e_rec c1 %ROWTYPE.

8. What is PL/SQL table ?

Objects of type TABLE are called "PL/SQL tables", which are modelled as (but not the same as) database tables, PL/SQL tables use a primary PL/SQL tables can have one column and a primary key.

Cursors

9. What is a cursor ? Why Cursor is required ?

Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

10. Explain the two type of Cursors ?

There are two types of cursors, Implict Cursor and Explicit Cursor.
PL/SQL uses Implict Cursors for queries.
User defined cursors are called Explicit Cursors. They can be declared and used.