Total Pageviews

July 26, 2017

7/26/2017 12:15:00 AM


1.       Which triggers are created when master -detail relation? master delete property
NON-ISOLATED (default): on check delete master, on clear details, on populate details
      ISOLATED: on clear details, on populate details
      CASCADE:    pre-delete, on clear details, on populate details.

2.       Which system variables can be set by users?
SYSTEM.MESSAGE_LEVEL
SYSTEM.DATE_THRESHOLD
SYSTEM.EFFECTIVE_DATE
SYSTEM.SUPPRESS_WORKING

3.       What are object group?
An object group is a container for a group of objects. You define an object group when you want to package related objects so you can copy or reference them in another module.

4.       What are referenced objects?
Referencing allows you to create objects that inherit their functionality and appearance from other objects.   Referencing an object is similar to copying an object, except that the resulting reference object maintains a link to its source object. A reference object automatically inherits any changes that have been made to the source object when you open or regenerate the module that contains the reference object.

5.       Can you store objects in library?
NO

.
6.       Can you issue DDL in forms?
Yes, but you have to use FORMS_DDL.

Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an object, except that the resulting reference object maintains a link to its source object. A reference object automatically inherits any changes that have been made to the source object when you open or regenerate the module that contains the reference object.
Any string expression up to 32K:
·    a literal
·  an expression or a variable representing the text of a block of dynamically created
          PL/SQL code
·  a DML statement or ·  a DDL statement
Restrictions:
The statement you pass to FORMS_DDL may not contain bind variable references in the string, but the values of bind variables can be concatenated into the string before passing the result to FORMS_DDL

7.       What is SECURE property?
Hides characters that the operator types into the text item.  This setting is typically used   for  password protection.



8.       What are the types of triggers and how the sequence of firing in text item
Triggers can be classified as Key Triggers, Mouse Triggers,  Navigational Triggers.
Key Triggers:  Key Triggers are fired as a result of Key action.
    e.g.  Key-next-field, Key-up, Key-Down
      Mouse Triggers:  Mouse Triggers are fired as a result of the mouse navigation.
                     e.g. When-mouse-button-pressed, when-mouse-double clicked, etc
      Navigational Triggers:  These Triggers are fired as a result of Navigation.
                                E.g. Post-Text-item, Pre-text-item.
      We also have event triggers like when–new-form-instance and when-new-block-instance.  
      We cannot call restricted procedures like go_to(‘my_block.first_item’) in the Navigational   
      triggers But can use them in the Key-next-item.

      The Difference between Key-next and Post-Text is an very important question. The key-next
      is fired as a result of the key action while the post text is fired as a result of the
      mouse movement.  Key next will not fire unless there is a key event.
The sequence of firing in a text item are as follows:
a) pre - text
b) when new item
c) key-next
d) when validate
                          e) post text

9.   What are property classes? Can property classes have trigger?
Property class inheritance is a powerful feature that allows you to quickly define objects that conform to your own interface and functionality standards. Property classes also allow you to make global changes to applications quickly.  By simply changing the definition of a property class, you can change the definition of all objects that inherit properties from that class.


Yes, all type of triggers.
 
Related Posts Plugin for WordPress, Blogger...