How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
using On-Message or On-Error triggers.
How many pages you can in a single form ?
Unlimited
Unlimited
While specifying master/detail relationship between two blocks specifying the join condition is a must ?
True or False. ?
True
True or False. ?
True
EXIT_FORM is a restricted package procedure ?
a. True b. False
True
a. True b. False
True
What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.
What are the types of Pop-up window ?
the pop-up field editor
pop-up list of values
pop-up pages.
Alert :
the pop-up field editor
pop-up list of values
pop-up pages.
Alert :
What is an SQL *FORMS ?
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
How do you control the constraints in forms ?
Select the use constraint property is ON Block definition screen.
BLOCK
Select the use constraint property is ON Block definition screen.
BLOCK
What is the difference between restricted and unrestricted package procedure ?
Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.
Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
PRE-QUERY fires once.
POST-QUERY fires 10 times.
PRE-QUERY fires once.
POST-QUERY fires 10 times.
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
a. ON-INSERT b. POST-INSERT c. PRE-INSERT
a. ON-INSERT b. POST-INSERT c. PRE-INSERT
State the order in which these triggers are executed ?
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.
What the PAUSE package procedure does ?
Pause suspends processing until the operator presses a function key
Pause suspends processing until the operator presses a function key
What do you mean by a page ?
Pages are collection of display information, such as constant text and graphics
Pages are collection of display information, such as constant text and graphics
What are the type of User Exits ?
ORACLE Precompliers user exits
OCI (ORACLE Call Interface)
Non-ORACEL user exits.
Page :
ORACLE Precompliers user exits
OCI (ORACLE Call Interface)
Non-ORACEL user exits.
Page :
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.
On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
No
No
Is a Key startup trigger fires as result of a operator pressing a key explicitly ?
No
No
Can we use GO-BLOCK package in a pre-field trigger ?
No
No
Can we create two blocks with the same name in form 3.0 ?
No
No
What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
It fires just before SQL * forms the current block.
Name the two files that are created when you generate the form give the filex extension ?
INP (Source File)
FRM (Executable File)
INP (Source File)
FRM (Executable File)
What package procedure used for invoke sql *plus from sql *forms ?
Host (E.g. Host (sqlplus))
Host (E.g. Host (sqlplus))
What is the significance of PAGE 0 in forms 3.0 ?
Hide the fields for internal calculation.
Hide the fields for internal calculation.
What are the different types of key triggers ?
Function Key
Key-function
Key-others
Key-startup
Function Key
Key-function
Key-others
Key-startup
What is the difference between a Function Key Trigger and Key Function Trigger ?
Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.
Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.
Committed block sometimes refer to a BASE TABLE ?
False
False
Error_Code is a package proecdure ?
a. True b. false
False
Share This :
a. True b. false
False
Can u have OLE objects in forms?
Yes.
Yes.
Can u have VBX and OCX controls in forms ?
Yes.
Yes.
What r the types of windows (Window style)?
Specifies whether the window is a Document window or a Dialog window.
Specifies whether the window is a Document window or a Dialog window.
What is OLE Activation style property?
Specifies the event that will activate the OLE containing item.
Specifies the event that will activate the OLE containing item.
Can u change the mouse pointer ? How?
Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.
Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.
How many types of columns are there and what are they
Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable
Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable
Can u have more than one layout in report
It is possible to have more than one layout in a report by using the additional layout option in the layout editor.
It is possible to have more than one layout in a report by using the additional layout option in the layout editor.
Can u run the report with out a parameter form
Yes it is possible to run the report without parameter form by setting the PARAM value to Null
Yes it is possible to run the report without parameter form by setting the PARAM value to Null
What is the lock option in reports layout
By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .
By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .
0 comments:
Post a Comment