Form FAQ's

1. Can you change the mouse pointer ?
A. Yes
B. No
C. None
2) Can you have VBX and OCX controls in forms ?
A. No
B. Yes
C. None

3. What is Current record attribute property?
A. Specifies the name of the .FMX file of the form currently being executed.
B. Specifies the number of the current record in the block's list of records..
C. Specifies the number of the current record in the block's list of records..
D. Specifies the name of the current form, as indicated by the form module    
      Name property.

4. Can you port applictions across the platforms? how?
A. No
B. Yes
C. Depends on Platform used
D. None

5. Following one is a Property of Call_Form.
A. opens a separate, independent form
B. replaces the current form with a different form
C. calls a modal form
D. None

6. How many types of Canvases are available in Forms?
A. Three
B. Two
C.  One
D. Four

7. Can a button have icon and lable at the same time ?
A. Yes
B. None
C. No
D. Depends on icon type

8. Which of the Following statement is Valid for static group?
A. A Record group that has an associated SELECT statement
B.  A Record group that is not associated with a query; rather, you define its
    structure and row values at design time, and they remain fixed at   runtime.

C. A Record group that is a group that does not have an associated query,    but whose structure  and values can be modified programmatically at runtime

D.  Non of the above.

9. What is the Sequence of Trigger Firing in Forms?
A. First Item, then Block and then Form Level
B. First Form Level, Block Level then Item Level
C. First Block Level, Then Form Level then Item Level
D. There is no such sequence of firing
10. What is a Secure Property?
A. Hides characters that the end user enters for the substitution parameter.
B. Displays characters that the end user enters for the substitution Parameter
C. Determines whether Form Builder hides the window automatically when the end user navigates to an item in another window
D. makes the current menu disappear
11. How many types of Window Styles are  available in Forms?
A. One
B. Two
C. Three
D. Four
12. Can you issue DDL in forms?
A. Yes
B. No
C. None
13. Say, you have created al named alert_info.
How many alert buttons will be available for alert buttons?
A. Two
B. One
C. Three
D. Can define any n numbers of buttons
14. In Record Group Total Number of Columns should not exceed..
A. 32k
B. 128 K
C. 16 K
D. 64 K
15. System variable :System.Record_status Defines
A. Represents the status of the record where the cursor is located.
B. Represents the status of a Data block where the cursor is located, or the current data block during trigger processing
C. Status of Current form
D. None
16. POST built-in  is used to
A. Writes data in the form to the database, but does not perform a database commit.  Form Builder first validates the form
B. Causes Form Builder to update data in the database to match data in the form.
C. Form Builder rolls back uncommitted changes (including posted changes) to the last save point.
D. Form Builder does not issue a rollback, and posted changes are preserved
17. Executable  Forms Menu File has an extension
A. .mmb
B. .mmx
C. .fmb
D. .fmx
18. SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels
A. 0,10,15
B. 0,10,15,20
C. 0
D. 0,10,15,20,25
19. To get the name of the Operating System on which application is running, following built-in is used.
A. GET_CUSTOM_PROPERTY
B. GET_OS_PROPERTY
C. GET_APPLICATION_PROPERTY
D. GET_FORM_PROPERTY
20. Can Forms  be connected to SQL SERVER?
A. Yes
B. No
C. None
21. Is Forms 6i is Object Oriented Tool?
A. No
B. Yes
C. None
22. Can object group have a block
A. Yes
B. No
22. Can you call WIN-SDK thruo' user exits?
A. No
B. Yes
24. Does user exits supports DLL on MSWINDOWS ?
A. YES
B. NO
25. Query System Mode Indicates
A. Indicates that the form is currently in normal processing mode.
B. Indicates that the form is currently in Enter Query mode.
C. Both A and B
D. Indicates that the form is currently in fetch processing mode, meaning that a query is currently being processed.
26. How many types of System Modes are available?
A. One
B. Four
C. Three
D. Two
27. In Release 5.0 and later, cursor mode is handled automatically by Form Builder. Is it True?
A. Yes
B. No
28. Whats the Use of Delayed Locking Mode Property?
A. Form Builder locks the row only while it posts the transaction to the database, not while the end user is editing the record.  Form Builder prevents the commit action from processing if values of the fields in the block have changed when the user causes a commit action.
B. Identical to Immediate if the datasource is an Oracle database. For other datasources, Form Builder determines the available locking facilities and behaves as much like Immediate as possible.
C. Form Builder locks the corresponding row as soon as the end user presses a key to enter or edit the value in a text item.
D. All Above
29. CREATE OR REPLACE FUNCTION set_budget
(v_studio_id IN NUMBER, v_new_budget IN NUMBER) IS
BEGIN
UPDATE emp
SET  sal = v_new_budget
WHERE empno = v_studio_id;
IF SQL%FOUND THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
COMMIT;
END;
Which code must be added to successfully compile this function?
A.Add "RETURN;" right before the "IS" keyword.
B.Add "RETURN number" right before the "IS" keyword.
C.Add "RETURN boolean" right after the "IS" keyword.
D.Add "RETURN boolean" right before the "IS" keyword.
30. The function ID_NULL that is used to test whether the object id is
       Available or not, the function returns which of the following value?
A. Varchar2
B. Number
C. Boolean
D. Char

1. How many types of Canvas are there in a form?
2. Can you have a form without a Canvas?
3. Does a stacked canvas require a content canvas?
4. What is a property class?
5. What is a Visual attribute? How can you set the visual attribute of an item?
6. How is a property class different from a visual attribute?
7. What are form triggers?
8. What is the difference between caLl form, new form and open form?
9. If there are two text items in a block, say text1 and text2. If the focus is on text2 and user moves the cursor to text1 by doing shift tab, then which triggers will fire? In what order?
10. What are Bind variables?]
11. What is a cursor?
12. What are the attributes of a cursor?
13. Which triggers are associated with a text item?
14. What is the structure of a PL/SQL block?
15. Explain what are stored procedures and functions.
16. Explain the types of Triggers in detail.
17. What is Call by Reference and Call by Value?




Some Questions on Forms 4.5
1.What are different components in form 4.5 designer ?
2.What is canvas ?
3.Is it possible to move an object from one form to another ?
4.What is block_menu ? Describe its usage.
5.Give usage of following runform options - array = value , block_menu = value , buffer_records,debug,debug_messages,help,interactive,keyin,keyout,logon_screen,optimizeSQL,optimizetp,options_screen,pecs, query_only, quiet,session, statistics, term, window_state
6.What runform option should be used if screen input is to be suppressed and output is to be sent to a file?
7.What is the usage of following forms generate options ? - add_triggers, batch, crt_file, debug, delete, extract, generate_on_upgrate, help, insert, logon, module_access, module_type, nofail, options_screen, output_file, parse, script, statistics, upgrade, upgrade_roles, version, widen_files
8.What is the usage of following forms designer options ? -  color mode,color palette, generate before run,module access, help, module_type,run asysnchronously,print,save before generate, suppress hints,term,use system editor
9.What is user preferences file ?
10.What are various types of  an item ?
11.What functions are used to display an lov programmatically ?
12.Differentiate between content & stacked canvases.
13.What are different type of items in forms 4.5 ? List atlas 5 types. E.g. Text_item
14.List down the file extensions used in forms 4.5 ? E.g. .fmb etc
15.How do you reuse an item across different form modules ?
16.How do you define public & private variables in forms 4.5 ?
17.Can you define a master-detail relationship between two blocks without a foreign key constraint at table level ?
18.How do you define a mandatory column in forms 4.5 ?
19.How can i check for a duplicate key in a block ?
20.What is a trigger ?
21.What are the levels at which triggers can be defined ?
22.Why triggers are used ?
23.What are various trigger groups ? Describe functionality of each group.
24.How you attach a form to menu?
25.How can you give parameters?
26.Can we have formula columns without return value?
27.What are visual attributes?
28.Can you change property class and visual attribute at run time?
29.What are the system variables, which can be modified by the user?
30.What can be the value of record status?
31.What is the difference between when_new_item_instance and pre_text_item?
32.How do i populate a poplist with a record group at runtime ?
33.If the first field of a form is required, and i want to tab out without entering any value, how do i do it ?
34.How do i call a backend stored procedure from forms ?
35.How do i handle stored procedure errors from forms ?
37.What is control block
38.What is default form
39.Here the questions like 'what are when-triggers used for ? Give examples for when-triggers'  can be asked.
40.Questions depending upon functionality of triggers
41.Function
42.Purpose
43.Example
44.Block processing
45.Fires in response to record management in a block
46.When-create-record, when-clear-block
47.GUI events
48.Fires in response to event happening in form interface
49.When-button-pressed, when-timer-expired
50.Master-detail
51.Fires during master-detail processing
52.On-check-delete-master
53.Message handling
54.Fires when an error occurs or message is needed
55.On-error,  on-message
56.Navigational
57.Fires as oracle forms navigates internally through the object hierarchy
58.Fires at the end of a navigational sequence
59.Pre-block, pre-form, post-block,  post-form, when-new-block-instance
60.Query time
61.Fires just before and after an operator executes a query
62.Pre-query, post-query
63.Here questions like when 'block processing triggers' are fired or which are navigational triggers etc. Can be asked.
64.What is the difference between pre-text-item trigger and on-new-item-instance trigger
65.What are types of triggers ?
66.Which legal command can be used in user-defined triggers ?
67.What are restricted built-ins ? In which type of triggers are these disallowed ?
68.While passing parameters to user defined procedures, what is meant by positional parameter notation
69. What are the attributes which are given to a field
70.What is next_set ?
71.List down atlas 5 system variables. E.g. System.last_record etc
72.How can you assign current date, current time, current date and time to an item ?
73.What are valid values for system.mode ?
74.How can you display only most severe messages while running a form ? I.e. How message severity level can be set in a form
75.How can i suppress input of a text item ?
76.How can i add elements to a list item dynamically ?
77.How can i make the width or height of all items on a canvas uniform in forms designer
78.How can i align all items vertically on a canvas at the same time ?
79.What is locking_mode property for a block ? What are different values for it ?
80.How to attach lov to a text item programmatically ?
81.Can record group for a lov changed programmatically ?
82.What are various commit modes used in clear_block ?
83.If i am calling a report from forms & if the report query is 'select * from emp' and dynamically at runtime i want to change it to 'select * from dept' can i do it ? How ?
84.If we have same triggers at multiple levels i.e. Form, block & item then what is the default order of firing of the triggers ?
85.Which trigger gets fired first : when new form instance or when new item instance ?
86.What will cause the entire contents of a stacked canvas view to be visible ?
87.How can i change the title of my runform window ?
88.How does a display item differ from a normal text item ?
89.Why do a get a null entry in my poplists at startup ?
90.How can i dynamically prevent the user from entering a new record ?
91.How can i dynamically make an entire block query-only at runtime ?
92.How can i change the color and font of an item dynamically at runtime ?
93.How can i have an item which acts like a disabled item , but is not grayed out ?
94.What exactly does 'query hits' and 'query options' mean in  the context of a block ?
95.What is the difference between the block properties of array size and records buffered
96.What should i be using record groups for ?
97.When should i use globals vs parameters ?
98.How do i pass a record group from forms to reports or graphics ?
99.Can i access the contents of a record group within a user exit ?
100.If i want to create a procedure should i use a library, a database stored procedure or a local form procedure ?
101.How does the use of libraries affect the size of the .fmx file ?
102.How should i make a reference to a block in my library program units ?
103.How is SQL within PL/SQL dealt with by forms ?
104.How are the constants like insert_allowed and property_on dealt with by PL/SQL?
105.If a timer expires during a long running query when is it handled ?
106.If a repeat timer expires between a long query, does it repeat prior to being serviced by a when-timer-expired at the end of the query or does it wait for servicing before repeating ?
107.What is the difference between the following triggers :
108.Post-fetch vs. Post_query
109.Post-forms-commit vs. Post-database-commit
110.Pre-query vs. Pre-select
111.Is it possible to defer locking of a record until commit time ?
112.How can i get an image from a file to be stored in my database ?
113.Sometimes when i issue a call_form (.., No_hide) my first form is still hidden.  Why
114.How can i determine which user interface i am using at runtime ?
115.How are menu roles handled in forms 4.5 ?
116.How can i specify my menu items so that they assume up the appropriate position for the GUI ?
117.What is the cause of the message :
118.Frm-10249: no authorization to run application <name>
119.How do i upgrade application form which has referenced objects from library form   forma ?
120.If i have a format mask of dd/mm/yy and type in a date without the slashes, why does this no longer show the correct date ?
121.After upgrading from SQL*forms 3.0 to forms 4.5, why do some of my fields truncate data ?
122.What does the forms45_defaultfont parameter control ?
123.If i upgrade from SQL*forms 2.3 to forms 4.5, what becomes of my v2 style triggers
124.Is the host() command under forms synchronous or asynchronous on windows
125.What gets loaded into memory when you run a form under windows ?
126.Why am i having problems changing the color of a button under windows ?
127.Can forms 4.5 call dll's on ms windows ?
128.Can i improve performance with any motif settings ?
129.How can i disable the blinking cursor to reduce network traffic ?
130.How can i change the look and feel of buttons under motif ?
131.How can i change the font in the trigger text window ?
132.How can you call one form from another?
133.What is the difference between call form, open form and new form?
134.What is the usage of global variables?
135.What is the difference between key_nextitem and post_nextitem?
136.What is validate source?
137.What is populate group query? What it will return?
138.How do you call reports through form?
139.What is reference object?
140.Whether you can change the path of a library?
141.What is new_item_instance?
142.Can you use global variables in record group?
143.What is autoconfirm property of lov?
144.How the errors are shown in forms?
145.What is savepoint?
146.What are property classes?
Forms  2.3
1. What are the differences between SQL forms 2.3 , 3.0 & 4.5
2. What are the events with which triggers can be associated
3. What are user exits
4. What was the most complicated form that you worked on
5. What are the different levels in form
6. What are the triggers which are written at form level