What are the different default triggers created when Master Deletes Property is set to Cascade?

What are the different default triggers created when
Master Deletes Property is set to Cascade?
by

1 Answer

Answer :

Master Deletes Property Resulting Triggers
---------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete
by

Related questions

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What are the master-detail triggers?\

Description : What are the master-detail triggers?\

Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details

What are the default extensions of the files created by forms modules?

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

What are the default extensions of the files created by menu module?

Description : What are the default extensions of the files created by menu module?

Last Answer : .mmb, .mmx

What are the default extensions of the files created by library module?

Description : What are the default extensions of the files created by library module?

Last Answer : The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

Which default Database roles are created when you create a Database?

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

Cascade control is (A) The continuous adjustment of the set point index of an automatic control loop by a primary (master) controller (B) Used when changes in process conditions cause serious upsets in the controlled variable (C) Useful to control flow from temperature (D) All 'a', 'b' & 'c'

Description : Cascade control is (A) The continuous adjustment of the set point index of an automatic control loop by a primary (master) controller (B) Used when changes in process conditions cause serious upsets in the controlled variable (C) Useful to control flow from temperature (D) All 'a', 'b' & 'c'

Last Answer : (D) All 'a', 'b' & 'c'

Which trigger are created when master -detail rela?

Description : Which trigger are created when master -detail rela?

Last Answer : master delete property * NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details * ISOLATED a) on clear details b) on populate details * CASCADE a) per-delete b) on clear details c) on populate details

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What is ON DELETE CASCADE ?

Description : What is ON DELETE CASCADE ?

Last Answer : When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

Can u set default font in forms?

Description : Can u set default font in forms?

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

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What are the types of triggers and how the sequence of firing in text item

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : 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 ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

Difference between database triggers and form triggers?

Description : Difference between database triggers and form triggers?

Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

What triggers are associated with the radio group?

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

What are the triggers associated with the image item?

Description : What are the triggers associated with the image item?

Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

List the windows event triggers available in Forms 4.0?

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

What are the types of TRIGGERS ?

Description : What are the types of TRIGGERS ?

Last Answer : 1. Navigational Triggers. 2. Transaction Triggers.

State the order in which these triggers are executed ?

Description : State the order in which these triggers are executed ?

Last Answer : POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

What is the usage of an ON-INSERT,ON-DELETE and ON- UPDATE TRIGGERS ? These triggers are execu

Description : What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are execu

Last Answer : These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.

Give the sequence of execution of the various report triggers?

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

What is the use of transactional triggers?

Description : What is the use of transactional triggers?

Last Answer : Using transactional triggers we can control or modify the default functionality of the oracle forms.

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

The join defined by the default data link is an outer join yes or no?

Description : The join defined by the default data link is an outer join yes or no?

Last Answer : Yes

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Can the default values be assigned to actual parameters?

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Last Answer : Destype and Desname.

What is default tablespace ?

Description : What is default tablespace ?

Last Answer : The Tablespace to contain schema objects created without specifying a tablespace name.

Which are the default passwords of SYSTEM/SYS?

Description : Which are the default passwords of SYSTEM/SYS?

Last Answer : MANAGER / CHANGE_ON_INSTALL

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is a master detail relationship?

Description : What is a master detail relationship?

Last Answer : A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.

What are the Various Master and Detail Relation ships.

Description : What are the Various Master and Detail Relation ships.

Last Answer : The various Master and Detail Relationship are a) NonIsolated :: The Master cannot be deleted when a child is exisiting b) Isolated :: The Master can be deleted when the child is exisiting c) Cascading :: The child gets deleted when the Master is deleted.

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Description : While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?

Last Answer : True

What are the Coordination Properties in a Master-Detail relationship?

Description : What are the Coordination Properties in a Master-Detail relationship?

Last Answer : The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur

What are Most Common types of Complex master-detail relationships?

Description : What are Most Common types of Complex master-detail relationships?

Last Answer : There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

What are the different file extensions that are created by oracle reports?

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the SAP system B. The number and types of work processes C. The master password for some default users in this SAP system D. The ABAP message server port

Description : Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the ... C. The master password for some default users in this SAP system D. The ABAP message server port

Last Answer : C. The master password for some default users in this SAP system D. The ABAP message server port

Can a repeating frame be created without a data group as a base?

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

What are the roles and user accounts created automatically with the database?

Description : What are the roles and user accounts created automatically with the database?

Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.

What is a trace file and how is it created ?

Description : What is a trace file and how is it created ?

Last Answer : Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.