20 + Interview Questions in Oracle9i Forms Developer Build Internet Applications Interview Questions in Oracle9i Forms Developer Build Internet Applications Tutorial Page 1 InterviewSolution

1.	You Are Using Pluggable Java Components To Modify The Appearance And Behavior Of Certain Input Items. These Modifications Cannot Be Done In The Property Palette Of These Items. Which Built-in Can You Use To Accomplish This Task?
Answer» SET_CUSTOM_PROPERTY USE to ACCOMPLISH this TASK. SET_CUSTOM_PROPERTY use to accomplish this task.

1.

You Are Using Pluggable Java Components To Modify The Appearance And Behavior Of Certain Input Items. These Modifications Cannot Be Done In The Property Palette Of These Items. Which Built-in Can You Use To Accomplish This Task?

Answer»

SET_CUSTOM_PROPERTY USE to ACCOMPLISH this TASK.

SET_CUSTOM_PROPERTY use to accomplish this task.

Discussion

2.	A User Runs, And Then Exits, The Payroll Forms Session Over The Web. The Same User Then Starts A Sales Forms Session Over The Web. The Sales Forms Application Uses Two Form Modules And Two Custom Menu Modules. How Many Forms Applets Are Required?
Answer» One Forms APPLET is required to RUN any ORACLE Application Server Forms SERVICES application. One Forms applet is required to run any Oracle Application Server Forms Services application.

2.

A User Runs, And Then Exits, The Payroll Forms Session Over The Web. The Same User Then Starts A Sales Forms Session Over The Web. The Sales Forms Application Uses Two Form Modules And Two Custom Menu Modules. How Many Forms Applets Are Required?

Answer»

One Forms APPLET is required to RUN any ORACLE Application Server Forms SERVICES application.

One Forms applet is required to run any Oracle Application Server Forms Services application.

Discussion

3.	There Are Several Forms In Your Forms 6i Application That Perform Select Statements In Triggers And Program Units To Extract Some Information From An Archives Table. As Part Of The Upgrade To The Latest Version Of Oracle Forms, You Have Split The Archives Table By Year. The Current Table Is Now Called Archives2001, So You Want To Change All Occurrences Of Archives In Your Pl/sql Code To Archives2001. Which File Would You Modify So That The Oracle Forms Migration Assistant Performs The Substitution When You Use This Tool To Upgrade Your Application?
Answer» SEARCH_REPLACE.PROPERTIES SEARCH_REPLACE.PROPERTIES

3.

There Are Several Forms In Your Forms 6i Application That Perform Select Statements In Triggers And Program Units To Extract Some Information From An Archives Table. As Part Of The Upgrade To The Latest Version Of Oracle Forms, You Have Split The Archives Table By Year. The Current Table Is Now Called Archives2001, So You Want To Change All Occurrences Of Archives In Your Pl/sql Code To Archives2001. Which File Would You Modify So That The Oracle Forms Migration Assistant Performs The Substitution When You Use This Tool To Upgrade Your Application?

Answer»

SEARCH_REPLACE.PROPERTIES

Discussion

4.	Which Three Tasks Can Be Performed By The Xml2forms Utility?
Answer» Following THREE tasks can be performed by the XML2Forms utility: parsing of XML using ORACLE XDK SAXParser creating a Forms object for each XML ELEMENT VALIDATING XML against the Forms XML SCHEMA Following three tasks can be performed by the XML2Forms utility:

4.

Which Three Tasks Can Be Performed By The Xml2forms Utility?

Answer»

Following THREE tasks can be performed by the XML2Forms utility:

parsing of XML using ORACLE XDK SAXParser
creating a Forms object for each XML ELEMENT
VALIDATING XML against the Forms XML SCHEMA

Following three tasks can be performed by the XML2Forms utility:

Discussion

5.	You Are Upgrading An Application To The Latest Version Of Oracle Forms That Was Previously Deployed Only In Client/server. When You Test The Upgraded Application, You Notice That Icons Do Not Appear On The Buttons. When You Ran The Application In Client/server With Forms 6i, Icons Appeared On The Buttons Because There Are Many Icon Buttons, You Are Concerned About Generating Frequent Round-trips To The Application Server To Display Icons On The Buttons, So You Convert The Icons To .gif Files And Place Them In A Jar File. You Modify The Forms Servlet Configuration File To Set Imagebase To Codebase And Include The Name Of The Jar File In The Appropriate Archive Parameter. Where Should You Locate The Jar File On Your Application Server Machine So That It Is Downloaded To The Client To Reduce Subsequent Network Traffic?
Answer» Place the ICON JAR FILE in the JAVA subdirectory of the FORMS90 (or FORMS) directory under the IAS $ORACLE_HOME on the application server machine. Place the icon JAR file in the JAVA subdirectory of the FORMS90 (or FORMS) directory under the iAS $ORACLE_HOME on the application server machine.

5.

You Are Upgrading An Application To The Latest Version Of Oracle Forms That Was Previously Deployed Only In Client/server. When You Test The Upgraded Application, You Notice That Icons Do Not Appear On The Buttons. When You Ran The Application In Client/server With Forms 6i, Icons Appeared On The Buttons Because There Are Many Icon Buttons, You Are Concerned About Generating Frequent Round-trips To The Application Server To Display Icons On The Buttons, So You Convert The Icons To .gif Files And Place Them In A Jar File. You Modify The Forms Servlet Configuration File To Set Imagebase To Codebase And Include The Name Of The Jar File In The Appropriate Archive Parameter. Where Should You Locate The Jar File On Your Application Server Machine So That It Is Downloaded To The Client To Reduce Subsequent Network Traffic?

Answer»

Place the ICON JAR FILE in the JAVA subdirectory of the FORMS90 (or FORMS) directory under the IAS $ORACLE_HOME on the application server machine.

Place the icon JAR file in the JAVA subdirectory of the FORMS90 (or FORMS) directory under the iAS $ORACLE_HOME on the application server machine.

Discussion

6.	You Are Designing A Menu That Attaches To Multiple Forms In Your Application, And You Want To Add A Menu Item That Enables Remote Debugging Of The Application. Which Built-in Must You Include In The Menu Item Code?
Answer» DEBUG.SUSPEND is INCLUDE in the MENU ITEM CODE. DEBUG.SUSPEND is include in the menu item code.

6.

You Are Designing A Menu That Attaches To Multiple Forms In Your Application, And You Want To Add A Menu Item That Enables Remote Debugging Of The Application. Which Built-in Must You Include In The Menu Item Code?

Answer»

DEBUG.SUSPEND is INCLUDE in the MENU ITEM CODE.

DEBUG.SUSPEND is include in the menu item code.

Discussion

7.	How Does The Oracle Http Server Handle A Request For A Forms Application?
Answer» It ROUTES the REQUEST by the mod_oc4j COMPONENT to OC4J. It routes the request by the mod_oc4j component to OC4J.

7.

How Does The Oracle Http Server Handle A Request For A Forms Application?

Answer»

It ROUTES the REQUEST by the mod_oc4j COMPONENT to OC4J.

It routes the request by the mod_oc4j component to OC4J.

Discussion

8.	Your Oracle Http Server Is Configured For The Default Port. You Want To Ensure That Your Forms Listener Servlet Can Manage Communication Between The Forms Java Client And Oracle Application Server Forms Services. What Action Is Required?
Answer» No action is required if You want to ENSURE that your Forms LISTENER Servlet can MANAGE communication between the Forms Java Client and Oracle Application SERVER Forms Services. No action is required if You want to ensure that your Forms Listener Servlet can manage communication between the Forms Java Client and Oracle Application Server Forms Services.

8.

Your Oracle Http Server Is Configured For The Default Port. You Want To Ensure That Your Forms Listener Servlet Can Manage Communication Between The Forms Java Client And Oracle Application Server Forms Services. What Action Is Required?

Answer»

No action is required if You want to ENSURE that your Forms LISTENER Servlet can MANAGE communication between the Forms Java Client and Oracle Application SERVER Forms Services.

No action is required if You want to ensure that your Forms Listener Servlet can manage communication between the Forms Java Client and Oracle Application Server Forms Services.

Discussion

9.	Which List Contains Only Those Methods For Using Java In Forms?
Answer» JAVABEANS, PJCs, JAVA Importer, Java Stored Procedures list CONTAINS only those METHODS for USING Java in Forms. JavaBeans, PJCs, Java Importer, Java Stored Procedures list contains only those methods for using Java in Forms.

9.

Which List Contains Only Those Methods For Using Java In Forms?

Answer»

JAVABEANS, PJCs, JAVA Importer, Java Stored Procedures list CONTAINS only those METHODS for USING Java in Forms.

JavaBeans, PJCs, Java Importer, Java Stored Procedures list contains only those methods for using Java in Forms.

Discussion

10.	You Are Running A Multiple-form Application. The Customers Form Invokes The Orders Form. When The Orders Form Launches, It Displays Orders For Only The Active Customer From The Customers Form. Forms Exchange Data With The:global.customer_id Variable. The Orders Form Should Query Orders For A Customer Only Once After Being Launched From The Customers Form. Which Built-in Helps You Do This By Setting The Onetime_where Property To Refer Dynamically To The Global.customer_id?
Answer» SET_BLOCK_PROPERTY PROPERTY to REFER DYNAMICALLY to the GLOBAL.CUSTOMER_ID. SET_BLOCK_PROPERTY property to refer dynamically to the GLOBAL.CUSTOMER_ID.

10.

You Are Running A Multiple-form Application. The Customers Form Invokes The Orders Form. When The Orders Form Launches, It Displays Orders For Only The Active Customer From The Customers Form. Forms Exchange Data With The:global.customer_id Variable. The Orders Form Should Query Orders For A Customer Only Once After Being Launched From The Customers Form. Which Built-in Helps You Do This By Setting The Onetime_where Property To Refer Dynamically To The Global.customer_id?

Answer»

SET_BLOCK_PROPERTY PROPERTY to REFER DYNAMICALLY to the GLOBAL.CUSTOMER_ID.

SET_BLOCK_PROPERTY property to refer dynamically to the GLOBAL.CUSTOMER_ID.

Discussion

11.	Lovs Were Not Cancel Able In Cases Where It Was Taking A Long Time To Retrieve Records Describes?
Answer» It DESCRIBES LOVs in forms that were developed in Forms 6I (or EARLIER versions). It describes LOVs in forms that were developed in Forms 6i (or earlier versions).

11.

Lovs Were Not Cancel Able In Cases Where It Was Taking A Long Time To Retrieve Records Describes?

Answer»

It DESCRIBES LOVs in forms that were developed in Forms 6I (or EARLIER versions).

It describes LOVs in forms that were developed in Forms 6i (or earlier versions).

Discussion

12.	"it Is Built On Top Of The C Forms Api" Statement About The Java Design-time Api (jdapi) Is True?
Answer» YES, In Java Design-Time API (JDAPI), BUILT on TOP of the C Forms API is true. Yes, In Java Design-Time API (JDAPI), built on top of the C Forms API is true.

12.

"it Is Built On Top Of The C Forms Api" Statement About The Java Design-time Api (jdapi) Is True?

Answer»

YES, In Java Design-Time API (JDAPI), BUILT on TOP of the C Forms API is true.

Yes, In Java Design-Time API (JDAPI), built on top of the C Forms API is true.

Discussion

13.	The Oracle Application Server Is Installed On Your Machine. In Forms Builder, You Open The Hresource Form And Connect To The Hr Database. You Also Edit Your Forms Builder Run-time Preferences And Click Set Default. To Test The Hresource Form Module, You Click Run Form And Receive The Error Message Frm-10142 (the Http Listener Is Not Running). What Action Should You Take?
Answer» Start an OC4J instance To test the HResource FORM module, you click Run Form and receive the error MESSAGE FRM-10142 (The HTTP listener is not running). Start an OC4J instance To test the HResource form module, you click Run Form and receive the error message FRM-10142 (The HTTP listener is not running).

13.

The Oracle Application Server Is Installed On Your Machine. In Forms Builder, You Open The Hresource Form And Connect To The Hr Database. You Also Edit Your Forms Builder Run-time Preferences And Click Set Default. To Test The Hresource Form Module, You Click Run Form And Receive The Error Message Frm-10142 (the Http Listener Is Not Running). What Action Should You Take?

Answer»

Start an OC4J instance To test the HResource FORM module, you click Run Form and receive the error MESSAGE FRM-10142 (The HTTP listener is not running).

Start an OC4J instance To test the HResource form module, you click Run Form and receive the error message FRM-10142 (The HTTP listener is not running).

Discussion

14.	You Are Upgrading A Forms 6i Application That Was Originally Written In Forms 2.3. It Uses Lovs Extensively, Many Of Which Are The Old-style Lovs That Are Not Supported In The Latest Version Of Oracle Forms. Which Statement About This Upgrade Is True?
Answer» The UPGRADE process AUTOMATICALLY CONVERTS each old-style LOV by creating a RECORD GROUP and basing the LOV on that record group. The upgrade process automatically converts each old-style LOV by creating a record group and basing the LOV on that record group.

14.

You Are Upgrading A Forms 6i Application That Was Originally Written In Forms 2.3. It Uses Lovs Extensively, Many Of Which Are The Old-style Lovs That Are Not Supported In The Latest Version Of Oracle Forms. Which Statement About This Upgrade Is True?

Answer»

The UPGRADE process AUTOMATICALLY CONVERTS each old-style LOV by creating a RECORD GROUP and basing the LOV on that record group.

The upgrade process automatically converts each old-style LOV by creating a record group and basing the LOV on that record group.

Discussion

15.	You Are Upgrading A Form That Was Written In Forms 6i. You Open The Form In The Latest Version Of Oracle Forms Builder. What Must You Do To This Form Before It Can Compile Successfully?
Answer» DELETE the SOUND ITEM before it can COMPILE SUCCESSFULLY. Delete the sound item before it can compile successfully.

15.

You Are Upgrading A Form That Was Written In Forms 6i. You Open The Form In The Latest Version Of Oracle Forms Builder. What Must You Do To This Form Before It Can Compile Successfully?

Answer»

DELETE the SOUND ITEM before it can COMPILE SUCCESSFULLY.

Delete the sound item before it can compile successfully.

Discussion

16.	On Windows Platforms, Which Two Programs In The Bin Directory Enable You To Upgrade Applications From Forms 6i To The Latest Version Of Oracle Forms?
Answer» IFCMP90.EXE (or FRMCMP.EXE), IFPLSQLCONV90.BAT (or FRMPLSQLCONV.BAT) these two programs in the BIN DIRECTORY ENABLE you to UPGRADE applications from Forms 6i to the latest version of Oracle Forms IFCMP90.EXE (or FRMCMP.EXE), IFPLSQLCONV90.BAT (or FRMPLSQLCONV.BAT) these two programs in the BIN directory enable you to upgrade applications from Forms 6i to the latest version of Oracle Forms

16.

On Windows Platforms, Which Two Programs In The Bin Directory Enable You To Upgrade Applications From Forms 6i To The Latest Version Of Oracle Forms?

Answer»

IFCMP90.EXE (or FRMCMP.EXE), IFPLSQLCONV90.BAT (or FRMPLSQLCONV.BAT) these two programs in the BIN DIRECTORY ENABLE you to UPGRADE applications from Forms 6i to the latest version of Oracle Forms

IFCMP90.EXE (or FRMCMP.EXE), IFPLSQLCONV90.BAT (or FRMPLSQLCONV.BAT) these two programs in the BIN directory enable you to upgrade applications from Forms 6i to the latest version of Oracle Forms

Discussion

17.	The Orders Form Was Developed Using Forms 6i And Uses Run_product To Call An Invoice Report. You Used The Oracle Forms Migration Assistant To Upgrade The Orders Form, Which Changed The Run_product Call To Use Run_report_object. You Run The Upgraded Form And Click The Invoice Button, Which Invokes The Report. However, You Receive The Error Message. What Should You Do To Avoid This Problem?
Answer» Set the DEFAULT REPORTS_SERVERNAME Migration ASSISTANT PROPERTY to specify the name of the reports SERVER to be used when CONVERTING RUN_PRODUCT calls. Set the default REPORTS_SERVERNAME Migration Assistant property to specify the name of the reports server to be used when converting RUN_PRODUCT calls.

17.

The Orders Form Was Developed Using Forms 6i And Uses Run_product To Call An Invoice Report. You Used The Oracle Forms Migration Assistant To Upgrade The Orders Form, Which Changed The Run_product Call To Use Run_report_object. You Run The Upgraded Form And Click The Invoice Button, Which Invokes The Report. However, You Receive The Error Message. What Should You Do To Avoid This Problem?

Answer»

Set the DEFAULT REPORTS_SERVERNAME Migration ASSISTANT PROPERTY to specify the name of the reports SERVER to be used when CONVERTING RUN_PRODUCT calls.

Set the default REPORTS_SERVERNAME Migration Assistant property to specify the name of the reports server to be used when converting RUN_PRODUCT calls.

Discussion

18.	What Happens When You Click Run Form Debug In Forms Builder?
Answer» The FORM RUNS in a three-tier environment using the application server URL that you SPECIFY in run-time PREFERENCES. The form runs in a three-tier environment using the application server URL that you specify in run-time preferences.

18.

What Happens When You Click Run Form Debug In Forms Builder?

Answer»

The FORM RUNS in a three-tier environment using the application server URL that you SPECIFY in run-time PREFERENCES.

The form runs in a three-tier environment using the application server URL that you specify in run-time preferences.

Discussion

19.	You Have Enabled Debug-level Servlet Logging For The Forms Servlet For All Users Of An Application. At The End Of The Work Day, You Want To Analyze The Log File. Which File Do You Examine?
Answer» You NEED to EXAMINE APPLICATION.LOG. You need to Examine APPLICATION.LOG.

19.

You Have Enabled Debug-level Servlet Logging For The Forms Servlet For All Users Of An Application. At The End Of The Work Day, You Want To Analyze The Log File. Which File Do You Examine?

Answer»

You NEED to EXAMINE APPLICATION.LOG.

You need to Examine APPLICATION.LOG.

Discussion

20.	What Is Adjust_tz Form?
Answer» ADJUST_TZ form built-in can be USED to change the display of a single DATETIME value from one time-zone REGION to ANOTHER without affecting other DATETIME ITEMS ADJUST_TZ form built-in can be used to change the display of a single DATETIME value from one time-zone region to another without affecting other DATETIME items

20.

What Is Adjust_tz Form?

Answer»

ADJUST_TZ form built-in can be USED to change the display of a single DATETIME value from one time-zone REGION to ANOTHER without affecting other DATETIME ITEMS

ADJUST_TZ form built-in can be used to change the display of a single DATETIME value from one time-zone region to another without affecting other DATETIME items

Discussion

Explore topic-wise InterviewSolutions in .

You Are Using Pluggable Java Components To Modify The Appearance And Behavior Of Certain Input Items. These Modifications Cannot Be Done In The Property Palette Of These Items. Which Built-in Can You Use To Accomplish This Task?

A User Runs, And Then Exits, The Payroll Forms Session Over The Web. The Same User Then Starts A Sales Forms Session Over The Web. The Sales Forms Application Uses Two Form Modules And Two Custom Menu Modules. How Many Forms Applets Are Required?

Which Three Tasks Can Be Performed By The Xml2forms Utility?

You Are Designing A Menu That Attaches To Multiple Forms In Your Application, And You Want To Add A Menu Item That Enables Remote Debugging Of The Application. Which Built-in Must You Include In The Menu Item Code?

How Does The Oracle Http Server Handle A Request For A Forms Application?

Your Oracle Http Server Is Configured For The Default Port. You Want To Ensure That Your Forms Listener Servlet Can Manage Communication Between The Forms Java Client And Oracle Application Server Forms Services. What Action Is Required?

Which List Contains Only Those Methods For Using Java In Forms?

Lovs Were Not Cancel Able In Cases Where It Was Taking A Long Time To Retrieve Records Describes?

"it Is Built On Top Of The C Forms Api" Statement About The Java Design-time Api (jdapi) Is True?

You Are Upgrading A Forms 6i Application That Was Originally Written In Forms 2.3. It Uses Lovs Extensively, Many Of Which Are The Old-style Lovs That Are Not Supported In The Latest Version Of Oracle Forms. Which Statement About This Upgrade Is True?

You Are Upgrading A Form That Was Written In Forms 6i. You Open The Form In The Latest Version Of Oracle Forms Builder. What Must You Do To This Form Before It Can Compile Successfully?

On Windows Platforms, Which Two Programs In The Bin Directory Enable You To Upgrade Applications From Forms 6i To The Latest Version Of Oracle Forms?

What Happens When You Click Run Form Debug In Forms Builder?

You Have Enabled Debug-level Servlet Logging For The Forms Servlet For All Users Of An Application. At The End Of The Work Day, You Want To Analyze The Log File. Which File Do You Examine?

What Is Adjust_tz Form?