Oracle Forms Interview Questions

Is it possible to upload or download file to server by using bfile/blob?

What does the '#' do in copy procedure

What does '#' sign do in copy function?

What is an SQL *forms ?

 sql  *forms  is  4gl  tool  for  developing  and  executing;  Oracle  based interactive application.

Committed block sometimes refer to a base table ?

 false.

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.

What  is the difference between a post-field trigger and a post-change trigger ?

 post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.

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 pre-insert,on-insert & post-insert.

Is  a  key startup trigger fires as result of a operator pressing a key explicitly ?

 no.

How can you execute the user defined triggers in forms 3.0 ?

 execute trigger (trigger-name)

When does an on-lock trigger fire ?

 it will fires whenever SQL * forms would normally attempt to lock a row.

What is the difference between key startup and pre-form ?

 key-startup trigger fires after successful navigation into a form. pre-form trigger fires before enter into the form.

What is the difference between keystartup and pre-form ?

 key-startup trigger fires after successful navigation into a form.Pre-form trigger fires before enter into the form. package procedure & function

What is a package procedure ?

 a package procedure is built in PL/SQL procedure.

What are the different types of package procedure ?

 1. Restricted package procedure.   2. Unrestricted package procedure.

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.

Classify the restricted and unrestricted procedure from the following.     a. Call     b. User-exit     c. Call-query    ...

Can we use a restricted package procedure in on-validate-field trigger ?

 no.

What synchronize procedure does ?

 it synchronizes the terminal screen with the internal state of the form.

What  are  the unrestricted procedures used to change the popup screen position during run time ?

 anchor-view  resize -view move-view.