Top 100+ Oracle Forms And Reports Interview Questions And Answers
Question 1. What Is Trigger Associated With The Timer?
Answer :
When-timer-expired.
Question 2. What Are The Trigger Associated With Image Items?
Answer :
When-photograph-activated fires when the operators double clicks on an image itemwhen-image-pressed fires whilst an operator clicks or double clicks on an image object
Oracle 10g Interview Questions
Question three. What Are The Different Windows Events Activated At Runtimes?
Answer :
When_window_activated
When_window_closed
When_window_deactivated
When_window_resized
Within this triggers, you could have a look at the built in machine variable gadget. Event_window to decide the name of the window for which the cause fired.
Question 4. When Do You Use Data Parameter Type?
Answer :
When the price of a facts parameter being passed to a called product is constantly the call of the record institution defined within the present day shape. Data parameters are used to bypass data to merchandise invoked with the run_product built-in subprogram.
Oracle 10g Tutorial
Question five. What Is New_form Built-in?
Answer :
When one shape invokes any other form through executing new_form oracle form exits the first form and releases its memory earlier than loading the new form calling new shape completely update the first with the second. If there are adjustments pending in the first shape, the operator can be precipitated to save them earlier than the new form is loaded.
Oracle 9i Interview Questions
Question 6. What Is The "lov Of Validation" Property Of An Item? What Is The Use Of It?
Answer :
When LOV for Validation is about to True, Oracle Forms compares the current price of the text object to the values within the first column displayed inside the LOV. Whenever the validation occasion happens. If the cost in the text object fits one of the values within the first column of the LOV, validation succeeds, the LOV is not displayed, and processing maintains generally. If the cost within the textual content item does not suit one of the values within the first column of the LOV, Oracle Forms shows the LOV and makes use of the textual content item cost as the search criteria to automatically reduce the list.
Question 7. What Is The Diff. When Flex Mode Is Mode On And When It Is Off?
Answer :
When flex mode is on, reviews routinely resizes the figure while the child is resized.
Oracle 9i Tutorial Oracle 8i Interview Questions
Question eight. What Is The Diff. When Confine Mode Is On And When It Is Off?
Answer :
When confine mode is on, an item cannot be moved out of doors its parent in the format.
Question nine. What Are Visual Attributes?
Answer :
Visual attributes are the font, color, sample proprieties which you set for shape and menu items that appear to your application interface.
Informatica Interview Questions
Question 10. Which Of The Two Views Should Objects According To Possession?
Answer :
view through shape.
Oracle 8i Tutorial
Question 11. What Are The Vbx Controls?
Answer :
Vbx control provide a simple technique of building and improving person interfaces. The controls can use to gain consumer inputs and show application outputs.Vbx manage in which at the start broaden as extensions for the ms visual basic environments and consist of such objects as sliders, rides and knobs.
PL/SQL Interview Questions
Question 12. What Is The Use Of Transactional Triggers?
Answer :
Using transactional triggers we are able to manage or regulate the default capability of the oracle bureaucracy.
Oracle 10g Interview Questions
Question 13. How Do You Create A New Session While Open A New Form?
Answer :
Using open_form built-in putting the session alternative Ex. Open_form('Stocks ',energetic, session). When invoke the multiple bureaucracy with open shape and call_form inside the identical utility, country whether the following are genuine/False
Informatica Tutorial
Question 14. What Are The Ways To Monitor The Performance Of The Report?
Answer :
Use reviews profile executable announcement. Use SQL trace facility.
Question 15. An Open Form Can Not Be Execute The Call_form Procedure If You Chain Of Called Forms Has Been Initiated By Another Open Form?
Answer :
True
Oracle 11g Interview Questions
Question sixteen. Explain About Horizontal, Vertical Tool Bar Canvas Views?
Answer :
Tool bar canvas views are used to create device bars for character home windows. Horizontal tool bars are display on the pinnacle of a window, simply under its menu bar. Vertical Tool bars are displayed alongside the left aspect of a window
Oracle 11g Tutorial
Question 17. What Is The Purpose Of The Product Order Option In The Column Property Sheet?
Answer :
To specify the order of person group evaluation in a pass merchandise.
SQL Interview Questions
Question 18. What Is The Use Of Image_zoom Built-in?
Answer :
To manipulate pix in picture gadgets.
Oracle 9i Interview Questions
Question 19. How Do You Reference A Parameter Indirectly?
Answer :
To in a roundabout way reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters fee' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')
Question 20. What Is A Timer?
Answer :
Timer is an "inner time clock" that you may programmatically create to carry out an action each time the times.
Oracle apps Interview Questions
Question 21. What Are The Two Phases Of Block Coordination?
Answer :
There are levels of block coordination: the clean segment and the population section. During, the clear section, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records. During the population section, Oracle Forms issues a SELECT announcement to repopulate the element block with element information related to the brand new grasp file. These operations are performed via the execution of triggers.
Question 22. What Are Most Common Types Of Complex Master-element Relationships?
Answer :
There are three maximum not unusual sorts of complex master-detail relationships:
master with structured information
grasp with unbiased info
element with two masters
Question 23. What Is A Text List?
Answer :
The textual content listing style list object appears as a square container which presentations the constant variety of values. When the textual content list incorporates values that can not be displayed, a vertical scroll bar seems, allowing the operator to view and select undisplayed values.
Sybase Interview Questions
Question 24. What Is Term?
Answer :
The time period is terminal definition document that describes the terminal form that you are the use of r20run.
Oracle 8i Interview Questions
Question 25. What Is Use Of Term?
Answer :
The term file which key's correspond to which oracle report features.
Question 26. What Is Pop List?
Answer :
The pop listing fashion list object seems to begin with as a unmarried subject (just like a textual content object subject). When the operator selects the listing icon, a listing of available choices seems.
Oracle Apps ERP Interview Questions
Question 27. What Is The Maximum No Of Chars The Parameter Can Store?
Answer :
The maximum no of chars the parameter can keep is only legitimate for char parameters, which may be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.
Informatica Interview Questions
Question 28. What Are The Default Extensions Of The Files Created By Library Module?
Answer :
The default document extensions indicate the library module type and storage format .Pll - pl/square library module binary
Question 29. What Are The Coordination Properties In A Master-detail Relationship?
Answer :
The coordination houses are
Deferred
Auto-Query
These Properties decide while the populace section of block coordination should occur.
Oracle 7.3 Interview Questions
Question 30. How Do You Display Console On A Window ?
Answer :
The console consists of the reputation line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console ought to be displayed, set the console window shape assets to the call of any window inside the shape. To consist of the console, set console window to Null.
Question 31. What Are The Different Parameter Types?
Answer :
Text ParametersData Parameters
Question 32. State Any Three Mouse Events System Variables?
Answer :
System.Mouse_button_pressedSystem.Mouse_button_shift
Oracle Access Manager Interview Questions
Question 33. What Are The Types Of Calculated Columns Available?
Answer :
Summary, Formula, Placeholder column.
PL/SQL Interview Questions
Question 34. Explain About Stacked Canvas Views?
Answer :
Stacked canvas view is displayed in a window on top of, or "stacked" on the content material canvas view assigned to that same window. Stacked canvas perspectives obscure a few part of the underlying content canvas view, and or frequently shown and hidden programmatically.
Question 35. What Is The Difference Between Show_editor And Edit_textitem?
Answer :
Show editor is the regularly occurring built-in which accepts any editor call and takes some input string and returns changed output string. Whereas the edit_textitem integrated desires the enter awareness to be inside the textual content item before the built-in is finished.
Question 36. What Are The Built-ins That Are Used To Attach An Lov Programmatically To An Item?
Answer :
set_item_property
get_item_property
(by placing the LOV_NAME assets)
Oracle 11g Interview Questions
Question 37. What Are The Different File Extensions That Are Created By Oracle Reports?
Answer :
Rep document and Rdf record.
Question 38. What Is Strip Sources Generate Options?
Answer :
Removes the supply code from the library file and generates a library files that includes only pcode. The resulting record can be used for very last deployment, however cannot be in the end edited inside the designer.Ex. F45gen module=old_lib.Pll userid=scott/tiger strip_source YES output_file
Question 39. What Is The Maximum Allowed Length Of Record Group Column?
Answer :
Record institution column names cannot exceed 30 characters.
Question 40. Which Parameter Can Be Used To Set Read Level Consistency Across Multiple Queries?
Answer :
Read simplest
SQL Interview Questions
Question 41. What Are The Different Types Of Record Groups?
Answer :
Query Record Groups
NonQuery Record Groups
State Record Groups
Question 42. From Which Designation Is It Preferred To Send The Output To The Printed?
Answer :
Previewer
Oracle apps Interview Questions
Question forty three. What Are Difference Between Post Database Commit And Post-form Commit?
Answer :
Post-form commit fires once at some point of the put up and commit transactions manner, after the database dedicate occurs. The submit-form-commit trigger fires after inserts, updates and deletes were published to the database however before the transactions had been finalized inside the issuing the command. The put up-database-commit cause fires after oracle paperwork issues the decide to finalized transactions.
Question forty four. What Are The Different Display Styles Of List Items?
Answer :
Pop_listText_listCombo field
Question 45. Which Of The Above Methods Is The Faster Method?
Answer :
acting the calculation within the question is faster.
Question forty six. With Which Function Of Summary Item Is The Compute At Options Required?
Answer :
percent of general functions.
Question forty seven. What Are Parameters?
Answer :
Parameters provide a simple mechanism for outlining and putting the valuesof inputs which are required by a form at startup. Form parameters are variables of kind char,wide variety,date that you outline at design time.
Question 48. What Are The Three Types Of User Exits Available ?
Answer :
Oracle Precompiler exits, Oracle name interface, NonOracle user exits.
Question 49. How Many Windows In A Form Can Have Console?
Answer :
Only one window in a shape can show the console, and you can not change the console venture at runtime.
Question 50. What Are The Two Repeating Frame Always Associated With Matrix Object?
Answer :
One down repeating frame below one throughout repeating body.
Question fifty one. What Are The Master-detail Triggers?
Answer :
On-Check_delete_masterOn_clear_detailsOn_populate_details
Question fifty two. Can You Pass Data Parameters To Forms?
Answer :
No
Question 53. Is It Possible To Link Two Groups Inside A Cross Products After The Cross Products Group Has Been Created?
Answer :
no
Question fifty four. What Are The Different Modals Of Windows?
Answer :
Modalless windows
Modal home windows
Question 55. What Are Modal Windows?
Answer :
Modal windows are commonly used as dialogs, and have constrained functionality as compared to modelless home windows. On a few systems as an instance operators can not resize, scroll or iconify a modal window.
Question fifty six. What Are The Different Default Triggers Created When Master Deletes Property Is Set To Non-isolated?
Answer :
Master Deletes Property Resulting Triggers
----------------------------------------------------
Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details
Question 57. What Are The Different Default Triggers Created When Master Deletes Property Is Set To Isolated?
Answer :
Master Deletes Property Resulting Triggers
---------------------------------------------------
Isolated On-Clear-Details
On-Populate-Details
Question 58. What Are The Different Default Triggers Created When Master Deletes Property Is Set To Cascade?
Answer :
Master Deletes Property Resulting Triggers
---------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete
Question fifty nine. What Are The Difference Between Lov & List Item?
Answer :
Lov is a belongings where as list object is an object. A list object may have best one column, lov will have one or more columns.
Question 60. What Is The Advantage Of The Library?
Answer :
Libraries provide a convenient manner of storing patron-facet application devices and sharing them among multiple programs. Once you create a library, you may attach it to some other form, menu, or library modules. When you may call library application gadgets from triggers menu items instructions and user named routine, you write within the modules to which you have attach the library. When a library attaches some other library, program devices in the first library can reference application gadgets inside the attached library. Library guide dynamic loading-this is library application units are loaded into an software only while wished. This can appreciably lessen the run-time reminiscence necessities of programs.
Question sixty one. What Is Lexical Reference? How Can It Be Created?
Answer :
Lexical reference is place_holder for text that may be embedded in a sq. Statements. A lexical reference may be created the usage of & earlier than the column or parameter call.
Question 62. What Is System.Coordination_operation?
Answer :
It represents the coordination causing event that arise on the master block in grasp-element relation.
Question 63. What Is Synchronize?
Answer :
It is a terminal screen with the inner state of the shape. It updates the display display to reflect the facts that oracle forms has in its internal illustration of the display.
Question sixty four. What Use Of Command Line Parameter Cmd File?
Answer :
It is a command line argument that lets in you to specify a report that include a fixed of arguments for r20run.
Question 65. What Is A Text_io Package?
Answer :
It allows you to read and write statistics to a file within the record gadget.
Question sixty six. What Is Forms_ddl?
Answer :
Issues dynamic Sql statements at run time, such as server side pl/SQl and DDL
Question sixty seven. What Are The Different Styles Of Activation Of Ole Objects?
Answer :
In location activationExternal activation
Question sixty eight. How Do You Reference A Parameter?
Answer :
In Pl/Sql, You can reference and set the values of form parameters the usage of bind variables syntax. Ex. PARAMETER call = '' or :block.Object = PARAMETER Parameter name
Question 69. What Is The Difference Between Object Embedding & Linking In Oracle Forms?
Answer :
In Oracle bureaucracy, Embedded objects end up a part of the shape module, and related items are references from a shape module to a related source file.
Question 70. Name Of The Functions Used To Get/set Canvas Properties?
Answer :
Get_view_property, Set_view_property
Question 71. What Are The Built-ins That Are Used For Setting The Lov Properties At Runtime?
Answer :
get_lov_property
set_lov_property
Question seventy two. What Are The Built-ins Used For Processing Rows?
Answer :
Get_group_row_count(characteristic)
Get_group_selection_count(characteristic)
Get_group_selection(characteristic)
Reset_group_selection(method)
Set_group_selection(system)
Unset_group_selection(procedure)
Question 73. What Are Built-ins Used For Processing Rows?
Answer :
GET_GROUP_ROW_COUNT(feature)
GET_GROUP_SELECTION_COUNT(feature)
GET_GROUP_SELECTION(feature)
RESET_GROUP_SELECTION(method)
SET_GROUP_SELECTION(process)
UNSET_GROUP_SELECTION(method)
Question seventy four. What Are The Built-in Used For Getting Cell Values?
Answer :
Get_group_char_cell(characteristic)
Get_groupcell(feature)
Get_group_number_cell(function)
Question seventy five. What Are The Built-ins Used For Getting Cell Values?
Answer :
GET_GROUP_CHAR_CELL (function)
GET_GROUPCELL(function)
GET_GROUP_NUMBET_CELL(characteristic)
Question seventy six. At Least How Many Set Of Data Must A Data Model Have Before A Data Model Can Be Base On It?
Answer :
Four
Question 77. To Execute Row From Being Displayed That Still Use Column In The Row Which Property Can Be Used?
Answer :
Format trigger.
Question 78. What Are Different Types Of Modules Available In Oracle Form?
Answer :
Form module - a set of items and code workouts Menu modules - a collection of menus and menu item instructions that collectively make up an utility menu library module - a group of user named techniques, capabilities and packages that can be called from other modules within the utility
Question seventy nine. What Is The Remove On Exit Property?
Answer :
For a modelless window, it determines whether oracle forms hides the window routinely when the operators navigates to an object within the every other window.
Question 80. What Is When-database-report Trigger?
Answer :
Fires while oracle bureaucracy first marks a report as an insert or an replace. The trigger fires as quickly as oracle paperwork determines thru validation that the file have to be processed by the subsequent submit or dedicate as an insert or replace. C commonly occurs handiest while the operators modifies the primary item within the report, and after the operator tries to navigate out of the object.
Question eighty one. What Is A Difference Between Pre-pick out And Pre-query?
Answer :
Fires during the execute question and be counted question processing after oracle paperwork constructs the select announcement to be issued, but before the announcement is definitely issued. The pre-query cause fires simply earlier than oracle paperwork problems the select statement to the database after the operator as define the example statistics by way of entering the query criteria in enter question mode.Pre-query cause fires earlier than pre-select trigger.
Question eighty two. What Are Built-ins Associated With Timers?
Answer :
find_timercreate_timerdelete_timer
Question eighty three. What Are The Built-ins Used For Finding Object Id Functions?
Answer :
Find_group(function)
Find_column(characteristic)
Question 84. Any Attempt To Navigate Programmatically To Disabled Form In A Call_form Stack Is Allowed?
Answer :
False
Question eighty five. Use The Add_group_row Procedure To Add A Row To A Static Record Group ?
Answer :
False
Question 86. Why Is It Preferable To Create A Fewer No. Of Queries In The Data Model?
Answer :
Because for every question, report has to open a separate cursor and has to rebind, execute and fetch information
Question 87. Where Is The External Query Executed At The Client Or The Server?
Answer :
At the server.
Question 88. Where Is A Procedure Return In An External Pl/sq. Library Executed At The Client Or At The Server?
Answer :
At the client.
Question 89. What Is Coordination Event?
Answer :
Any event that makes a one of a kind document inside the master block the modern report is a coordination causing event.
Question 90. What Is The Difference Between Ole Server & Ole Container?
Answer :
An Ole server application creates ole Objects which are embedded or connected in ole Containers ex. Ole servers are ms_word & ms_excel. OLE bins offer an area to store, show and manage gadgets which might be created by way of ole server packages. Ex. Oracle paperwork is an example of an ole Container.
Question ninety one. What Is An Object Group?
Answer :
An item institution is a box for a set of items; you define an item institution while you need to package deal related objects, so that you reproduction or reference them in other modules.
Question ninety two. What Is An Lov?
Answer :
An LOV is a scrollable popup window that gives the operator with either a unmarried or multi column selection listing.
Question ninety three. At What Point Of Report Execution Is The Before Report Trigger Fired?
Answer :
After the query is accomplished however before the record is accomplished and the statistics are displayed.
Question ninety four. What Are The Built -ins Used For Modifying A Groups Structure?
Answer :
ADD-GROUP_COLUMN (function)
ADD_GROUP_ROW (manner)
DELETE_GROUP_ROW(technique)
Question 95. What Is An User Exit Used For?
Answer :
A way in which to pass control (and possibly arguments ) form Oracle document to every other Oracle merchandise of three GL and then go back manage ( and ) back to Oracle reports.
Question 96. What Is The User-named Editor?
Answer :
A user named editor has the equal text enhancing capability as the default editor, but, because it is a named item, you may specify editor attributes together with windows show size, function, and name.
Question 97. What Is A Static Record Group?
Answer :
A static file institution isn't associated with a question, alternatively, you define its structure and row values at design time, and that they remain constant at runtime.
Question 98. What Is A Record Group?
Answer :
A record group is an internal Oracle Forms that shape that has a column/row framework just like a database table. However, not like database tables, document corporations are separate items that belong to the shape module which they may be defined.
Question 99. What Is A Property Clause?
Answer :
A property clause is a named item that incorporates a listing of houses and their settings. Once you create a assets clause you could base different object on it. An item based totally on a property can inherit the placing of any property inside the clause that makes sense for that object.
Question 100. What Is A Physical Page ? & What Is A Logical Page ?
Answer :
A bodily page is a length of a web page. That is output by way of the printer. The logical web page is the size of 1 web page of the actual document as seen within the Previewer.
