Interview Questions.

Question 1. What Is Adjust_tz Form?

Answer :

ADJUST_TZ shape integrated may be used to exchange the display of a unmarried DATETIME value from one time-quarter place to some other with out affecting different DATETIME items

Question 2. You Have Enabled Debug-degree 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.

Oracle 9i Interview Questions
Question 3. What Happens When You Click Run Form Debug In Forms Builder?

Answer :

The shape runs in a three-tier environment the usage of the software server URL which you specify in run-time preferences.

Question four. 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 reviews server to be used while changing RUN_PRODUCT calls.

Oracle 9i Tutorial
Question five. 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) those  packages within the BIN listing enable you to upgrade packages from Forms 6i to the latest model of Oracle Forms

Oracle 11g Interview Questions
Question 6. 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 object before it may assemble efficaciously.

Question 7. You Are Upgrading A Forms 6i Application That Was Originally Written In Forms 2.Three. It Uses Lovs Extensively, Many Of Which Are The Old-fashion 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 every vintage-style LOV through growing a document group and basing the LOV on that report organization.

Oracle 11g Tutorial Database Testing Interview Questions
Question eight. 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 check the HResource shape module, you click Run Form and receive the error message FRM-10142 (The HTTP listener isn't always strolling).

Question nine. "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 proper.

Oracle 7.3 Interview Questions
Question 10. Lovs Were Not Cancel Able In Cases Where It Was Taking A Long Time To Retrieve Records Describes?

Answer :

It describes LOVs in bureaucracy that have been advanced in Forms 6i (or in advance variations).

Database Testing Tutorial
Question eleven. You Are Running A Multiple-shape 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:international.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.

IDMS (Integrated Database Management System) Interview Questions
Question 12. Which List Contains Only Those Methods For Using Java In Forms?

Answer :

JavaBeans, PJCs, Java Importer, Java Stored Procedures listing carries best the ones strategies for using Java in Forms.

Oracle 9i Interview Questions
Question 13. 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 need to make certain that your Forms Listener Servlet can control verbal exchange between the Forms Java Client and Oracle Application Server Forms Services.

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

Answer :

It routes the request by the mod_oc4j element to OC4J.

Question 15. 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 encompass within the menu item code.

PeopleCode Interview Questions
Question sixteen. 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 record inside the JAVA subdirectory of the FORMS90 (or FORMS) listing below the iAS $ORACLE_HOME at the utility server gadget.

Question 17. Which Three Tasks Can Be Performed By The Xml2forms Utility?

Answer :

Following three responsibilities can be completed by way of the XML2Forms application:

parsing of XML the usage of Oracle XDK SAXParser
developing a Forms object for each XML element
validating XML in opposition to the Forms XML schema
Sql Server Dba Interview Questions
Question 18. 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/square 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

Oracle 11g Interview Questions
Question 19. 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 software.

Question 20. 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 perform this venture.

Oracle 11g RAC Interview Questions