Interview Questions.

Q1. Which Of The Two Views Should Objects According To Possession?

View by structure.

Q2. What Is The Difference Between Ole Server & Ole Container?

An Ole server utility creates ole Objects which might be embedded or related in ole Containers ex. Ole servers are ms_word & ms_excel. OLE boxes provide a place to keep, show and manipulate objects which might be created via ole server applications. Ex. Oracle forms is an instance of an ole Container.

Q3. What Is A Static Record Group?

A static file institution isn't always related to a query, alternatively, you outline its structure and row values at design time, and that they remain constant at runtime.

Q4. Which Of The Above Methods Is The Faster Method?

Performing the calculation inside the query is quicker.

Q5. Where Is A Procedure Return In An External Pl/square Library Executed At The Client Or At The Server?

At the customer.

Q6. What Is The User-named Editor?

A consumer named editor has the equal text editing functionality because the default editor, but, because it's miles a named object, you could specify editor attributes along with windows display length, position, and name.

Q7. What Is A Difference Between Pre-pick out And Pre-question?

Fires for the duration of the execute question and count number question processing after oracle forms constructs the select assertion to be issued, however before the announcement is truely issued. The pre-query trigger fires just before oracle bureaucracy troubles the choose declaration to the database after the operator as outline the instance statistics via coming into the query criteria in input query mode.Pre-query trigger fires before pre-pick cause.

Q8. How Do You Reference A Parameter Indirectly?

To indirectly 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')

Q9. How Do You Display Console On A Window ?

The console includes the popularity line and message line, and is displayed at the lowest of the window to which it's miles assigned.To specify that the console have to be displayed, set the console window form property to the name of any window within the shape. To consist of the console, set console window to Null.

Q10. What Are The Different Display Styles Of List Items?

Pop_listText_listCombo box

Q11. What Are The Default Extensions Of The Files Created By Library Module?

The default file extensions suggest the library module kind and storage format .Pll - pl/square library module binary

Q12. What Is Forms_ddl?

Issues dynamic Sql statements at run time, along with server aspect pl/SQl and DDL

Q13. What Is Term?

The term is terminal definition record that describes the terminal form which you are using r20run.

Q14. What Are The Built-in Used For Getting Cell Values?

Get_group_char_cell(characteristic)

Get_groupcell(feature)

Get_group_number_cell(feature)

Q15. What Are The Different Default Triggers Created When Master Deletes Property Is Set To Isolated?

Master Deletes Property Resulting Triggers

---------------------------------------------------

Isolated On-Clear-Details

On-Populate-Details

Q16. What Are The Different Types Of Record Groups?

Query Record Groups

NonQuery Record Groups

State Record Groups

Q17. What Is A Text List?

The textual content listing style listing item appears as a square field which shows the fixed range of values. When the text list consists of values that cannot be displayed, a vertical scroll bar appears, allowing the operator to view and pick out undisplayed values.

Q18. Where Is The External Query Executed At The Client Or The Server?

At the server.

Q19. What Is The Purpose Of The Product Order Option In The Column Property Sheet?

To specify the order of character organization assessment in a move products.

Q20. What Are The Vbx Controls?

Vbx manage provide a easy approach of constructing and improving person interfaces. The controls can use to achieve person inputs and show software outputs.Vbx control in which at first expand as extensions for the ms visible basic environments and include such gadgets as sliders, rides and knobs.

Q21. What Are The Master-element Triggers?

On-Check_delete_masterOn_clear_detailsOn_populate_details

Q22. Why Is It Preferable To Create A Fewer No. Of Queries In The Data Model?

Because for each query, document has to open a separate cursor and has to rebind, execute and fetch statistics

Q23. What Are The Built-ins That Are Used For Setting The Lov Properties At Runtime?

Get_lov_property

set_lov_property

Q24. Which Parameter Can Be Used To Set Read Level Consistency Across Multiple Queries?

Read simplest

Q25. State Any Three Mouse Events System Variables?

System.Mouse_button_pressedSystem.Mouse_button_shift

Q26. What Are Visual Attributes?

Visual attributes are the font, color, sample proprieties that you set for shape and menu gadgets that appear on your software interface.

Q27. What Are Built-ins Associated With Timers?

Find_timercreate_timerdelete_timer

Q28. Is It Possible To Link Two Groups Inside A Cross Products After The Cross Products Group Has Been Created?

No

Q29. What Are Difference Between Post Database Commit And Post-form Commit?

Post-form commit fires as soon as at some stage in the put up and devote tractions method, after the database commit takes place. The post-form-devote trigger fires after inserts, updates and deletes had been published to the database however before the tractions have been finalized inside the issuing the command. The publish-database-commit cause fires after oracle paperwork troubles the decide to finalized tractions.

Q30. What Is The Use Of Tractional Triggers?

Using tractional triggers we are able to manage or modify the default functionality of the oracle bureaucracy.

Q31. Name Of The Functions Used To Get/set Canvas Properties?

Get_view_property, Set_view_property

Q32. What Is The Advantage Of The Library?

Libraries provide a convenient me of storing customer-side software units and sharing them amongst more than one programs. Once you create a library, you can connect it to another shape, menu, or library modules. When you may call library software units from triggers menu objects commands and user named ordinary, you write in the modules to which you have connect the library. When a library attaches some other library, application units inside the first library can reference program units in the connected library. Library aid dynamic loading-this is library software gadgets are loaded into an software only when wished. This can notably lessen the run-time memory requirements of applications.

Q33. What Is The Maximum No Of Chars The Parameter Can Store?

The maximum no of chars the parameter can store is only valid for char parameters, which may be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

Q34. What Are The Built-ins Used For Finding Object Id Functions?

Find_group(characteristic)

Find_column(characteristic)

Q35. When Do You Use Data Parameter Type?

When the fee of a statistics parameter being surpassed to a referred to as product is usually the call of the document organization defined in the present day form. Data parameters are used to skip facts to products invoked with the run_product built-in subprogram.

 

Q36. What Are Parameters?

Parameters provide a simple mechanism for outlining and placing the valuesof inputs which might be required by means of a shape at startup. Form parameters are variables of kind char,quantity,date which you define at layout time.

Q37. What Is Coordination Event?

Any occasion that makes a one-of-a-kind document in the master block the modern-day report is a coordination causing event.

Q38. What Is Strip Sources Generate Options?

Removes the supply code from the library report and generates a library files that consists of only pcode. The ensuing report can be used for final deployment, however can not be subsequently edited inside the clothier.Ex. F45gen module=old_lib.Pll userid=scott/tiger strip_source YES output_file

Q39. What Are The Built-ins That Are Used To Attach An Lov Programmatically To An Item?

Set_item_property

get_item_property

(by way of setting the LOV_NAME assets)

Q40. To Execute Row From Being Displayed That Still Use Column In The Row Which Property Can Be Used?

Format trigger.

Q41. What Is A Property Clause?

A assets clause is a named object that consists of a list of houses and their settings. Once you create a property clause you can base different item on it. An item based totally on a belongings can inherit the setting of any property in the clause that makes experience for that item.

Q42. What Are Built-ins Used For Processing Rows?

GET_GROUP_ROW_COUNT(function)

GET_GROUP_SELECTION_COUNT(function)

GET_GROUP_SELECTION(characteristic)

RESET_GROUP_SELECTION(technique)

SET_GROUP_SELECTION(manner)

UNSET_GROUP_SELECTION(method)

Q43. What Are The Trigger Associated With Image Items?

When-picture-activated fires when the operators double clicks on an photograph itemwhen-photo-pressed fires when an operator clicks or double clicks on an image item

Q44. What Are The Built -ins Used For Modifying A Groups Structure?

ADD-GROUP_COLUMN (feature)

ADD_GROUP_ROW (technique)

DELETE_GROUP_ROW(technique)

Q45. At What Point Of Report Execution Is The Before Report Trigger Fired?

After the query is completed however earlier than the report is executed and the records are displayed.

Q46. What Are The Two Phases Of Block Coordination?

There are two levels of block coordination: the clear segment and the populace phase. During, the clear section, Oracle Forms navigates internally to the detail block and flushes the out of date detail information. During the populace phase, Oracle Forms troubles a SELECT declaration to repopulate the detail block with element statistics related to the new grasp report. These operations are completed thru the execution of triggers.

Q47. What Is An User Exit Used For?

A way in which to skip control (and possibly arguments ) form Oracle document to any other Oracle merchandise of 3 GL and then go back manage ( and ) returned to Oracle reports.

Q48. What Is New_form Built-in?

When one shape invokes every other form with the aid of executing new_form oracle form exits the first form and releases its reminiscence earlier than loading the new form calling new shape completely replace the primary with the second. If there are adjustments pending in the first form, the operator might be caused to save them earlier than the new form is loaded.

Q49. What Is The Maximum Allowed Length Of Record Group Column?

Record group column names can't exceed 30 characters.

Q50. What Is A Record Group?

A file organization is an internal Oracle Forms that shape that has a column/row framework much like a database desk. However, not like database tables, report corporations are separate objects that belong to the shape module which they're described.