351. When is PRE-QUERY trigger executed ?
When Execute-query or count-query Package procedures are invoked.
352. How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
353. How many pages you can in a single form ?
Unlimited
354. While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?
True
355. EXIT_FORM is a restricted package procedure ?a. True b. False
True
356. 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.
357. What are the types of Pop-up window ?
the pop-up field editor
pop-up list of values
pop-up pages.
Alert :
358. What is an SQL *FORMS ?
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
359. How do you control the constraints in forms ?
Select the use constraint property is ON Block definition screen.BLOCK
360. 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.
361. 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.
362. 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
363. 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.
364. What the PAUSE package procedure does ?
Pause suspends processing until the operator presses a function key
365. What do you mean by a page ?
Pages are collection of display information, such as constant text and graphics
366. What are the type of User Exits ?
ORACLE Precompliers user exits
OCI (ORACLE Call Interface)
Non-ORACEL user exits.
Page :
367. 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.
368. Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
No
369. Is a Key startup trigger fires as result of a operator pressing a key explicitly ?
No
370. Can we use GO-BLOCK package in a pre-field trigger ?
No
371. Can we create two blocks with the same name in form 3.0 ?
No
372. What is Post-Block is a. ???
a. Navigational Trigger.
b. Key trigger
c. Transaction Trigger.
373. What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
374. Name the two files that are created when you generate the form give the filex extension ?
INP (Source File)
FRM (Executable File)
375. What package procedure used for invoke sql *plus from sql *forms ?
Host (E.g. Host (sqlplus))
376. What is the significance of PAGE 0 in forms 3.0 ?
Hide the fields for internal calculation.
377. What are the different types of key triggers ?
Function Key
Key-function
Key-others
Key-startup
378. 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.
379. Committed block sometimes refer to a BASE TABLE ?
False
380. Error_Code is a package proecdure ?
a. True b. false
False
381. How can you execute the user defined triggers in forms 3.0 ?
Execute Trigger (trigger-name)
382. What ERASE package procedure does ?
Erase removes an indicated global variable.
383. What Enter package procedure does ?
Enter Validate-data in the current validation unit.
384. What is the difference between NAME_IN and COPY ?
Copy is package procedure and writes values into a field.
Name in is a package function and returns the contents of the variable to which you apply.
385. What package procedure is used for calling another form ?
Call (E.g. Call(formname)
386. When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
Break.
SYSTEM VARIABLES
387. The value recorded in system.last_record variable is of type
a. Number
b. Boolean
c. Character. ?
b. Boolean.
388. What are the unrestricted procedures used to change the popup screen position during run time ?
Anchor-view
Resize -View
Move-View.
389. What is an Alert ?
An alert is window that appears in the middle of the screen overlaying a portion of the current display.
390. Deleting a page removes information about all the fields in that page ? a. True. b. False?
a. True.
391. Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ? a. True. b. False?
a. True.
392. Classify the restricted and unrestricted procedure from the following.
a. Call
b. User-Exit
c. Call-Query
d. Up
e. Execute-Query
f. Message
g. Exit-From
h. Post
i. Break?
a. Call - unrestricted
b. User Exit - Unrestricted
c. Call_query - Unrestricted
d. Up - Restricted
e. Execute Query - Restricted
f. Message - Restricted
g. Exit_form - Restricted
h. Post - Restricted
i. Break - Unrestricted.
393. 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.
394. What is a Trigger ?
A piece of logic that is executed at or triggered by a SQL *forms event.
395. What is a Package Procedure ?
A Package procedure is built in PL/SQL procedure.
398. What is the maximum size of a form ?
255 character width and 255 characters Length.
399. 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.
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.
