Oracle Technical

Oracle Forms Development (Developer 2000): Part 2

Question: What are ALERT?

Answer: An ALERT is a modal window that displays a message notifiying operator of some application condition.

Question: Can a button have icon and label at the same time?

Answer: NO

Question: What is mouse navigate property of button?

Answer: When Mouse Navigate is True (the default), Oracle Forms performs standard navigation to move the focus to the item when the operator activates the item with the mouse.
When Mouse Navigate is set to False, Oracle Forms does not perform navigation (and the resulting validation) to move to the item when an operator activates the item with the mouse.

Question: What is FORMS_MDI_WINDOW?

Answer: forms run inside the MDI application window. This property is useful for calling a form from another one.

Question: What are timers? When when-timer-expired does not fire?

Answer: The When-Timer-Expired trigger can not fire during trigger, navigation, or transaction processing.

Question: Can object group have a block?

Answer: Yes , object group can have block as well as program units.

Question:  How many types of canvases are there?
Answer: There are 2 types of canvases called as Content and Stack Canvas. Content canvas is the default and the one that is used mostly for giving the base effect. Its like a plate on which we add items and stacked canvas is used for giving 3 dimensional effect.

Question: What is a visual attribute?
Answer: Visual attributes are the font, color, and pattern properties that you set for form and menu objects that appear in your application’s interface.

Question: Diff. between VAT and Property Class?
Answer: Named visual attributes define only font, color, and pattern attributes; property classes can contain these and  any other properties. You can change the appearance of objects at runtime by changing the named visual attribute
programmatically; property class assignment cannot be changed programmatically. When an object is inheriting from both a property class and a named visual attribute, the named visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

Question: Which trigger related to mouse?

Answer: When-Mouse-Click

Question: What is Current record attribute property?

Answer: Specifies the named visual attribute used when an item is part of the current record.
Current Record Attribute is frequently used at the block level to display the current row in a multi-record If you define an item-level Current Record Attribute, you can display a pre-determined item in a special color when it is part of the current record, but you cannot dynamically highlight the current item, as the input focus  changes.

Question: Can u change VAT at run time?

Answer: Yes. You can programmatically change an object’s named visual attribute setting to change the font, color, and pattern of the object at runtime.

Question: Can u set default font in forms?

Answer: Yes. Change windows registry (regedit). Set form45_font to the desired font.

Question: Can u have OLE objects in forms?

Answer: Yes.

Question: Can u have VBX and OCX controls in forms?

Answers: Yes.

Question: What r the types of windows (Window style)?

Answer:  Specifies whether the window is a Document window or a Dialog window.
10) What is OLE Activation style property?
10) Specifies the event that will activate the OLE containing item.

Question: Can u change the mouse pointer? How?

Answer: Yes. Specifies the mouse cursor style.  Use this property to dynamically change the shape of the cursor.

Question: What are savepoint mode and cursor mode properties? Level?

Answer: Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily  for applications that will run against non-ORACLE data sources.   For applications that will run against ORACLE, use the default setting.
Cursor mode – define cursur state across transaction Open/close.

Question: What are OPEN_FORM, CALL_FORM,NEW_FORM? Diff?

Answer: CALL_FORM : It calls the other form. but parent remains active, when called form completes the operation ,  it releases lock and control goes back to the calling form.
When you call a form, Oracle Forms issues a savepoint for the called form.  If the CLEAR_FORM function causes a rollback when the called form is current, Oracle Forms rolls back uncommitted changes to this savepoint.
OPEN_FORM: When you call a form, Oracle Forms issues a savepoint for the called form.  If the CLEAR_FORM function causes a rollback when the called form is current, Oracle Forms rolls back uncommitted changes to this savepoint.
NEW_FORM: Exits the current form and enters the indicated form.  The calling form is terminated as the parent form.  If the calling form had been called by a higher form, Oracle Forms keeps the higher call active and treats it as a call to the new form.  Oracle Forms releases memory (such as database cursors) that the terminated form was using.
Oracle Forms runs the new form with the same Runform options as the parent form.  If the parent form was a called form.

Question: What is call form stack?

Answer: When successive forms are loaded via the CALL_FORM procedure, the resulting module hierarchy is known as the call form stack.

Question: Can u port applictions across the platforms? how?
Answer: Yes, we can port applications across platforms.Consider the form developed in windows system.The form would be generated in unix system by using f60gen my_form.fmb scott/tiger

Oracle Reports (Report 6i) – Technical – Interview – Question Answers

Receive the latest blog updates

Facebook Twitter Instagram Youtube Linkedin