Top 34 Oracle9i Forms Interview Questions
Q1. What Is The Difference Between The Forms Servlet And The Forms Listener Servlet?
The Forms Servlet is in rate of dynamically producing the HTML page containing the vital Forms Client information.
The Forms Listener Servlet is the architecture for Internet deployment. The Forms Listener Servlet manages the communique between the Forms Java Client and Oracle9i AS Forms Services in Oracle9i AS.
Q2. How Can I Attach To A Remote Form In Debug Mode?
First of all, the Form which you wish to debug wishes to make a call to Debug.Attach in PL/SQL (You might associate this with a menu choice inside the module.) Calling Debug.Attach; will pop up a dialog on the far flung machine containing the call of the server and a port number.
In the Forms Builder, use the Debug->Attach Debug menu choice to show the "Attach Debug to" dialog. Enter the provided machine and port variety into this dialog. You will then be able to debug the remote session.
Q3. Can I Use Ldap To Authenticate Oracle9i As Forms Services?
Not directly. However, Oracle Login Server is capable of authenticate towards a LDAP directory and as a result a Forms software can take benefit of this in a SSO surroundings. But you can't use get admission to manage information saved in a LDAP listing with Forms.
Q4. When Will The Forms Listener Servlet Use Http 1.1 Requests To The Web Server, And When Will It Use Http 1.Zero Requests?
The Forms Listener Servlet will constantly make HTTP 1.1 requests if the Web server and any intervening proxies, guide this protocol degree. The Servlet will drop down to the usage of HTTP 1.Zero if Web server or one of the proxies can handiest guide that level of the protocol.
Q5. When Running A Form On The Web Where Do Commands Such As Host And Text_io Execute?
In Web-deployed Forms those commands and constructed-ins execute at the center tier. To execute the instructions at the consumer browser device, use a JavaBean.
In a comparable manner User Exits and ORA_FFI code all act on the middle tier and now not on the browser consumer.
Q6. Do I Have To Write A Wrapper To Interface The Forms Java Client With A Pre-existing Java Bean?
This is an option in Oracle9i Forms and nevertheless works. However, we've got delivered better aid for JavaBe in Oracle9i Forms, which lets in Forms to introspect the JavaBean at runtime and eliminates the want to jot down any Java code to handle the integration. Enhanced JavaBean support is blanketed in the on line assist.
Q7. Is There An Easy Way To Find Out If My Modules Use Obsolete Features?
Yes. Oracle supply a separate utility with the Oracle9i Forms distribution "f90plsqlconv". This is a utility a good way to scan your files for obsolete usages and correct them where relevant. It will also provide you with a warning to any modifications you could need to make manually.
Q8. When I Press The Run Button How Can I Define Which Browser Is Used?
Use the Edit->Preferences dialog and set the place of your preferred web browser inside the "Web Browser Location" field at the Runtime tab..
Q9. Do I Still Need To Download Jinitiator On The Client To Run A Forms Application?
JInitiator is a Java Virtual Machine (JVM) that plugs into both Netscape Communicator or Microsoft Internet Explorer to offer an alternative JVM to that which those browsers provide.
Depending on the consumer platform the browser is strolling, we are assisting the following JVMs:
Windows32
Oracle JInitiator (with Netscape and Internet Explorer)
Internet Explorer 5.X native JVM
Macintosh
Apple MRJ 2.2.Three (with Internet Explorer 5.0)
Solaris
Sun JDK and Java plug-in
Q10. Can I Run Client Server Or Character Mode Applications In Oracle9i Forms?
No. Oracle9i Forms only supports Web deployment. Applications that want to be run in Client Server or Character Mode need to remain in Forms 6i . Forms 6i will be supported till December 31st, 2004, or December 31st, 2007 with Extended Support for customers who want to keep such applications.
Q11. Is Forms Supported On Windows Xp?
Windows XP is currently present process certification. Refer to the "Client Platform Support" statement of route to be had on OTN () for the modern day reputation.
Q12. How Can I Use A Particular Profile From My Formsweb.Cfg When Running From The Builder?
In the Edit->Preferences conversation Runtime tab, you can input an software server URL. This URL is the only that the builder will append to whilst building the URL to run. Thus, in case you specify a selected configuration at the quit of this URL
(e.G. Http://myserver/forms90/f90servlet?Config=improvement ), that base configuration might be used, and additional runtime information appended to it.
Q13. How Can I Create A Link In Oracle9i As Portal Pointing To An Oracle9i As Forms Services Application?
There are methods to do that. First, you may use the Oracle9i AS Portal MyFavorites portlet, that is a sort of bookmark portlet, allowing you to submit custom hyperlinks.
Second, you can outline specific hyperlinks as folders in a Content vicinity and submit them to the portal. The second alternative may be extra appropriate because it prevents users from customizing the hyperlinks.
Q14. What Changes Will I Have To Make To My Application Before Upgrading?
Many Client Server and Character Mode functions were removed from the Forms product for 9i . The removed capabilities especially relate to capabilities that where simplest maintained in Forms 6i for the motive of backwards compatibility. A certain list of all of the out of date capabilities may be located on OTN ( /products/bureaucracy/pdf/featuresobsolescence.Pdf)
Q15. What Versions Of Forms Can I Upgrade To Oracle9i Forms?
Only Forms 6.Zero and Forms 6i are supported for direct improve to Oracle9i Forms. Older versions of Forms have to be upgraded to Forms 6i first.
Q16. I Currently Have A Client-server Application That Uses An Embedded Activex Control To Communicate With An External Device. How Can I Maintain This Functionality When I Deploy The Application On The W
Assuming that the tool in question (as an example, a Scanner) is attached to each client device, in preference to the server, you will use a Pluggable Java Component (PJC) to extend the talents of the Forms Java Client and permit it to talk to the hardware in query. Oracle9i JDeveloper gives a Wizard that will help you construct such Puggable Java Components.
Q17. What Win32 Platforms Can Oracle9i As Forms Services Be Deployed On?
Only Windows NT 4.Zero and Windows 2000 are supported as systems for website hosting the Oracle9i AS Forms Services.
Browser customers that get right of entry to Forms packages using JInitiator or local Internet Explorer may be primarily based on any supported Win32 version:
Windows 95 (while supported by using Microsoft)
Windows 98
Windows ME (with patch 6)
Windows NT 4.Zero
Windows 2000
Q18. I Find The Colour Scheme Of The Oracle9i Forms Builder Hard To Work With, Is There A Way Of Changing This?
Set the surroundings variable FORMS90_CLAF=authentic, earlier than beginning the builder, to enable the "conventional" Forms look and feel.
Q19. Can I Debug A Remote Form Through A Firewall?
No. The far flung debugging inside Forms makes use of a sockets connection to address the debug site visitors. Generally firewalls do now not permit traffic thru unregulated sockets so the debug connection will not be made.
In 6i on Windows I used to use the F4 key to show the Property Palette for an object within the builder. This now not appears to work.
In Oracle9i Forms use the F8 key to invoke the Property Palette.
Q20. Is It Possible To Call Java Classes From The Forms Application On The Application Server Side?
Yes. The Oracle9i Forms Developer offers you the ability to generate the PL/SQL code important to name any Java class from a Forms software, the usage of the Java Importer facility.
With the code generated by means of this feature, you are able to call compiled Java instructions, directly from PL/SQL, in the Oracle9i AS Forms Services on the middle tier.
Q21. In Oracle9 I Forms Can I Run Forms Using A Separate Forms Listener Process?
No. In later patches to Forms 6i , we added a new way of walking Forms on the internet, with out the need for a separate Forms Listener procedure. This is a Java Servlet known as the Forms Listener Servlet. In Oracle9i AS Forms Services (the version of Forms in Oracle9i AS v2) the Forms Listener Servlet is the best supported way of deploying Forms.
Q22. Can I Deploy My Forms Application Over The Internet Through Firewalls And Proxies?
Yes. Oracle9i AS Forms Services supports a wide variety of firewalls and proxy servers.
Q23. Can I Integrate My Oracle9i As Forms Services Application As A Portlet In Oracle9i As Portal?
Yes. You have to edit the relevant static or base .Html document (if the usage of the CGI or servlet). In both instances you need to get rid of the <HTML>,<BODY>, </HTML>, and </BODY> tags. Using the Portal Developer's Kit (PDK) downloaded from OTN (), you could installation the URL portlet.
This URL portlet takes an application, referenced by a URL, and brings it as a portlet right into a portal page.
Q24. Can I Use Single Sign-on With Oracle9i As Forms Services?
Yes. Oracle9i AS Forms Services programs can be configured as an outside utility to the Oracle Login Server. The Login Server is the Oracle unified Single Sign-On (SSO) solution, mapping the Oracle9i Forms application person to a Single Sign-On consumer account.
Q25. Can I Base A Forms Block On An Ejb Or Bc4j Component?
The Java importer facility offers you the potential to use an Enterprise Java Bean (EJB) or Business Components for Java (BC4J) aspect as the idea of a Forms Block. However, we advocate which you do no longer do this for the following reasons:
Calling out to Java from Forms has a small however big overall performance implication. The Java Native Interface (JNI) that is used to name out from the Forms C code to Java does impose a bottleneck on the operation as values and approach calls are trferred. Although this overhead isn't always substantial in a simple characteristic name, it will become evident if a Form Block is based totally on Java in this way. The ordinary capability of the block calls for many calls to and fro to the datasource and in this example the delay imposed via the JNI bridge, on every name, will result in pretty slower performance than that for a block primarily based without delay on a table, view or PL/SQL saved method.
Whenever a Forms procedure calls out to Java, it ought to have a Java Virtual Machine loaded into reminiscence. This will growth the reminiscence footprint of your software.
Using a foreign statistics source in this way is a complex assignment in terms of hooking the Java Code up to the Forms tractional triggers. The maintenance burden is likewise excessive if changes have to be made, as each the PL/SQL interfaces and the Java code itself might also want to be changed.
An EJB or BC4J factor will create it is very own JDBC connection to the database and no longer re-use the prevailing Forms connection, doubling the person load at the database.
Q26. How Can I Upload A File From A Browser Client To My Middle Tier?
You can either use a conventional Web upload to do this, or you could use a JavaBean plugged into the Forms Java Client. An example of this is to be had on OTN ()
Q27. Can I Use The Functions In The D2kwutil Library When My Oracle9i As Forms Services Are Running On Nt?
No. We don't guide the usage of D2KWUTIL within the center tier. Many of the capabilities within the library require access to Window Handles, so one can not paintings in the Web deployment situation. While a few functions, such as WIN_API_ENVIRONMENT.GET_COMPUTER_NAME(), do paintings, they go back facts approximately the application server machine, not the patron. Some capabilities, consisting of the bitwise operations, retain to function without a hassle.
Q28. How Can I Manage And Monitor Oracle9i As Forms Services Activity Remotely?
Oracle9i AS Forms Services is integrated with Oracle Enterprise Manager (EM) to permit the administration and the tracking of the Oracle9i AS Forms Services. From the browser based EM console, you could reveal the patron classes jogging within a Forms Service, viewing how tons memory and CPU each is the usage of. Individual classes may even be killed from the EM console.
Q29. When I Try To Use The Java Importer Feature I Get A Pde Error Why Is This?
In order to apply the Java Importer, The route used by the Form Builder ought to consist of the Java binclassic listing and the classpath should encompass each the training that you need to import as well as the provided importer.Jar report.
Q30. When Running A Form On The Web, Can I Use Ole To Talk To Programs Such As Ms Word Or Excel?
Yes. OLE integration works for external OLE servers invoked the use of OLE2.CREATE_OBJ. The OLE server you are invoking have to be to be had on the center tier system in which the Oracle9i AS Forms Services is living. Consequently the center tier system ought to be a Windows NT or Windows 2000 gadget. Embedded OLE packing containers and ActiveX (OCX) controls are not supported while jogging on the Web.
Q31. In Oracle9 I Forms Can I Call A Forms Application Using The Forms Cgi?
No. In later patches to Forms 6i , we added a brand new way of building the start web page for a Forms application, the Forms Servlet. This Java Servlet does the same task as the Forms CGI, specifically the development of an HTML web page primarily based on configuration records provided at the URL in combination with the formsweb.Cfg document. In Oracle9i Forms, this Servlet have to be used rather than the CGI.
Q32. I Want To Write A Javabean For Use As A Pluggable Component For The Forms Java Client. What Version Of The Java Development Kit (jdk) Should I Use?
Pluggable Java additives for Oracle9i Forms may be build with 1.3 of the JDK.
Q33. How Do I Run My Oracle9i As Forms Services Applications In Several Different Languages On The Same Machine?
Multiple entries for a specific application may be described in the formsweb.Cfg file, with each utility name suffixed with the u . S . A . Code, as an example HR, HR.DE, HR.FR and so forth. When a URL is submitted with the price CONFIG=HR, the Forms Servlet will discover for the submitting browsers language code and look for a suitable model of HR with that code appended.
Thus a person strolling a browser in French could pick up the HR.FR version of the configuration. If a selected configuration and language code aggregate is not found in the formsweb,cfg, then the bottom configuration (in this example HR) may be used. Each of the country particular variations of the HR utility can define settings including the surroundings report accordingly.
Q34. Can I Run Oracle9i As Forms Services On Linux?
Yes, Oracle9i AS Forms Services are to be had as a part of the Oracle9i AS v2 Enterprise Edition on Linux.
