Oracle Apps Forms Question with Answer

1. what are the architecture used in oracle forms?
Ans. Client tier - middle tier - database tier


2. what are the parameter available in form configuration files ?
 Ans : System parameter, user parameter, custom application

3. what are the main component in oracle forms?
Ans : Forms servlet, Form listener servlet, form runtime engine


4.How many blocks are available in oracle forms?
    Ans : Three blocks.

5.What are the blocks are in oracle forms?
Ans:    1. Control
    2. Master
    3. Detail


6. What is control block?
 Ans. It does not depend on database table.

7. what is master block>
 Ans. It does depend on database table.


8. What is detail block?
 Ans. It does depend on master block.


9.What is canvas?
Ans : Display area called as canvas



10. How many type of canvases are available in oracle forms?
 Ans : 5


11. What are the types of canvases in oracle forms?
   Ans:
    1.Content
    2.Stacked
    3.Horizandal
    4.Vertical
    5.Tab


12. which is the correct format when store the forms application?
Ans : .fmb


13. which format is After compile the forms application ?
 Ans : .fmx

14. what is the use of forms servlet?
 Ans: when a user sends an request the forms servlet reads the base html files.

15. what is the process of Forms listener?
 Ans: Forms listener then interact with the client and send the client request to forms runtime engine.


16. what is the use of runtime engine?
Ans : forms runtime engine gets the request from the listener and query the database.


17. what is expansion of OC4J?
Ans : Oracle container for J2EE.


18.what is fmb?
Ans : form binary

19. what is fmx?
 Ans : form Executable

20. what is fmt?
Ans : form text


21. which is the normal canvas?
 Ans : Content


22. what are the delete record behaviours?
Ans : Isolated, Non Isolated, Cascade

23. when prevent the master detail records?
Ans : If delete record behaviour is Non isolated


24.What is enter query ?
Ans : Entering criteria using bind variable in forms.


25.which column want to enter hint message in the property pallet?
Ans : Tooltip column


26.can convert from form binary into form executable?
Ans : NO

27. Could convert from form text into form binary?
Ans : Yes


28. Could convert from form binary into form text?
ANs : Yes


29. what did you do want to hide the any one column after create the data block?
Ans : Canvas column is 'null'


30. what did you done if the cursor skip the column?
Ans Keboard navigable is 'No'


31. what did you done if you want to set scrollbar after create the datablock?
Ans : show scrollbar is Yes and set scrollbar canvas is that particular canvasname.


32.what did you done if you want to set some range of space between the records?
Ans: set distance between records is 20


33.How will be stored after create the plsql liabrary?
Ans : .PLL


34.How will you used in the module after create the plsql liabrary?
Ans : using Attached liabrary


35. How will you reset number of display record after create a datablock?
Ans : set Records displayed is what ever it is.


36. when used in alert?
Ans: to advise operators of unusual situations.



37.which build_in are used if want to display the alert?
Ans : show_alert()


38.How many buttons are available in alert?
Ans : Three buttons


39. what is alert buttons datatype?
ANs : Number


40. which exception wants to raise after giving cancel in alert?
Ans: form_trigger_failure


41.  How to display the result after run the module?
Ans : Execute query


42. How to insert a new record after run the module?
Ans : click insert record and Enter the data


43. What will be display the oracle message after saving the record?
Ans FRM-40400:Transaction completed: 1 records applied and saved


44.what will be happened when deferred is True and Auto query is true?
Ans : Details are fetched only when the operator navigates to detail block


45. what will be happened when deferred is True and auto query is false?
Ans : Details are fetched only when the oprator navigates to detail block and executes a query.


46. what will be happened when deferred is False and auto query is false?
Ans : Details are fetched as soon as the master records are fetched


47.what is object group?
Ans : It is a container for a group of objects.you define an object group when you want to
package related object so you can copy or reference them in another module.


49. what is editor?
Ans : This object enables the operator to edit text.


50. what is record group?
Ans : it has an unlimited number of column of datatype