What is ON DELETE CASCADE ?

What is ON DELETE CASCADE ?
by

1 Answer

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.
by

Related questions

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

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

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

Compare and contrast TRUNCATE and DELETE for a table.

Description : Compare and contrast TRUNCATE and DELETE for a table.

Last Answer : Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just ... other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

What is difference between TRUNCATE & DELETE ?

Description : What is difference between TRUNCATE & DELETE ?

Last Answer : TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

How will you delete duplicating rows from a base table?

Description : How will you delete duplicating rows from a base table?

Last Answer : delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid

Differentiate between TRUNCATE and DELETE?

Description : Differentiate between TRUNCATE and DELETE?

Last Answer : TRUNCATE deletes much faster than DELETE TRUNCATE DELETE It is a DDL statement It is a DML statement It is a one way trip,cannot ROLLBACK One can Rollback Doesn't have selective features (where clause) Has Doesn't fire database triggers Does It requires disabling of referential constraints.

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.

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.

What is the difference between DELETE and TRUNCATE statements?

Description : What is the difference between DELETE and TRUNCATE statements?

Last Answer : The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation ... be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

Which one is faster: DELETE or TRUNCATE?

Description : Which one is faster: DELETE or TRUNCATE?

Last Answer : TRUNCATE

If buying cheap causes a cascade of negative effects, what to do if you're on a budget?

Description : If buying cheap causes a cascade of negative effects, what to do if you're on a budget?

Last Answer : Interesting question. It makes me happy to see people being conscientious consumers. I have a lot of hope for our generation. One option might be to try to make as much stuff yourself as ... in the landfills, and no international repercussions. Good luck. I look forward to seeing more responses.

When is the best time of year to hike in the Cascade or Olympic mountain ranges?

Description : When is the best time of year to hike in the Cascade or Olympic mountain ranges?

Last Answer : The Olympic mountain range is a rainforest, and therefore wet - and cold - for much of the year. The Cascades get snow in the winter and the whole pacific northwest is pretty chilly from Sept/Oct thru ... Cascades, and have had great times doing it. I'd definately take bugs over snow and rain :)

What is cascade method ?

Description : What is cascade method ?

Last Answer : The method of connecting the output of an amplifier stage of a multistage amplifier to the input of the next amplifier stage through a coupling device is called cascade method.

What is the advantage of cascade refrigeration?

Description : What is the advantage of cascade refrigeration?

Last Answer : Advantage of cascade refrigeration system. This system has the following advantages compared to a two stage compression system. 1.Energy is saved because the system allows use of refrigerants that have ... for each of the higher temperature side. 2. It allows stable ultra low temperature operation.

Phosphoinositide cascade is activated on binding of catecholamines to (A) α1-Adrenergic receptors (B) α2-Adrenergic receptors (C) β1-Adrenergic receptors (D) β2-Adrenergic receptors

Description : Phosphoinositide cascade is activated on binding of catecholamines to (A) α1-Adrenergic receptors (B) α2-Adrenergic receptors (C) β1-Adrenergic receptors (D) β2-Adrenergic receptors

Last Answer : Answer : A

Enzymes are required in traces because they (A) Have high turnover number (B) Remain unused at the end of reaction and are re used (C) Show cascade effect (D) All correct

Description : Enzymes are required in traces because they (A) Have high turnover number (B) Remain unused at the end of reaction and are re used (C) Show cascade effect (D) All correct

Last Answer : Answer : D

Which of the following statement(s) is/are correct concerning the immunoinflammatory response to shock? a. The anaphylactoxins, C3a and C5a, are products of activation of only the classical pathway of the compliment cascade b. Eicosanoids, such as prostaglandins are stored in platelets and endothelial cells and released in response to inflammatory stimuli c. Thromboxane and PGI2 have similar effects d. Platelet-activating factor can be released by both circulating and fixed tissue cells

Description : Which of the following statement(s) is/are correct concerning the immunoinflammatory response to shock? a. The anaphylactoxins, C3a and C5a, are products of activation of only the classical pathway ... effects d. Platelet-activating factor can be released by both circulating and fixed tissue cells

Last Answer : Answer: d Inflammatory mediators have recently been recognized as playing a significant role in the clinical manifestations and progression of shock and the development ... increased pulmonary vascular resistance, bronchoconstriction, peripheral vasodilatation, and increased vascular permeability

The neurohormonal arm of the stress response is well defined. Less is known about the inflammatory arm mediated primarily by cytokines. Which of the following statement(s) is/are true concerning this arm of the surgical stress response? a. Cytokines primarily work locally via direct cell-to-cell communication b. Cytokines are never detectable in the systemic bloodstream c. Cytokines are produced only by immune cells attracted to the site of injury d. Cytokine release may stimulate the release of other cytokines leading to an important cascade of events

Description : The neurohormonal arm of the stress response is well defined. Less is known about the inflammatory arm mediated primarily by cytokines. Which of the following statement(s) is/are true ... Cytokine release may stimulate the release of other cytokines leading to an important cascade of events

Last Answer : Answer: a, d Cytokines, which are produced at the site of injury by endothelial cells and by diverse immune cells throughout the body, also occupy a pivotal position in the stress response ... act as hormones and spill over into the systemic circulation and become detectable in the bloodstream

Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. B. The intrinsic pathway beginning with the activation of factor XII is the predominant in vivo mechanism for activation of the coagulation cascade. C. Deficiencies of factor VIII and IX cause highly significant coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Description : Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. ... coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Last Answer : Answer: AC DISCUSSION: Although it was previously held that two somewhat distinct pathways existed for the activation of the coagulation cascade, it is now recognized that the predominant ... bleeding. This further emphasizes the secondary role that the intrinsic pathway plays in coagulation

Hemostasis and the cessation of bleeding require which of the following processes? A. Adherence of platelets to exposed subendothelial glycoproteins and collagen with subsequent aggregation of platelets and formation of a hemostatic plug. B. Interaction of tissue factor with factor VII circulating in the plasma. C. The production of thrombin via the coagulation cascade with conversion of fibrinogen to fibrin. D. Cross-linking of fibrin by factor XIII.

Description : Hemostasis and the cessation of bleeding require which of the following processes? A. Adherence of platelets to exposed subendothelial glycoproteins and collagen with subsequent aggregation of platelets and ... conversion of fibrinogen to fibrin. D. Cross-linking of fibrin by factor XIII.

Last Answer : Answer: ABCD DISCUSSION: Hemostasis requires the interaction of platelets with the exposed subendothelial structures at the site of injury followed by aggregation of more platelets in that area. ... form a stable clot that incorporates the platelet plug and fibrin thrombus into a stable clot

If you have available number of power amplifiers with a gain of 100 each, how many such amplifiers do you need to cascade to give an overall gain of 60 dB? A. 3 B. 4 C. 5 D. 2

Description : If you have available number of power amplifiers with a gain of 100 each, how many such amplifiers do you need to cascade to give an overall gain of 60 dB? A. 3 B. 4 C. 5 D. 2

Last Answer : A. 3

Pick out the wrong statement. (A) Cellulose acetate membranes are used in dialysis process (B) Elutriation process refers to when the soluble material is largely concentrated on the surface of an insoluble solid and is simply washed off by the solvent (C) 'Cascade' means a group of stages interconnected so that various streamflow from one to another(D) Zirconia probe is used for the humidity measurement

Description : Pick out the wrong statement. (A) Cellulose acetate membranes are used in dialysis process (B) Elutriation process refers to when the soluble material is largely concentrated on the surface of an ... that various streamflow from one to another (D) Zirconia probe is used for the humidity measurement

Last Answer : (D) Zirconia probe is used for the humidity measurement

The prothrombin time a. assess the extrinsic pathway of the blood coagulation cascade b. is prolonged in patients with fat absorption c. is increased by warfarin d. all above

Description : The prothrombin time a. assess the extrinsic pathway of the blood coagulation cascade b. is prolonged in patients with fat absorption c. is increased by warfarin d. all above

Last Answer : all above

The prothrombin time a. assess the extrinsic pathway of the blood coagulation cascade b. is prolonged in patients with fat absorption c. is increased by warfarin d. is increased by heparin

Description : The prothrombin time a. assess the extrinsic pathway of the blood coagulation cascade b. is prolonged in patients with fat absorption c. is increased by warfarin d. is increased by heparin

Last Answer : assess the extrinsic pathway of the blood coagulation cascade

The following are true about the Fc regions of an immunoglobulins: a. they can be cleaved from the Fab regions by papain b. they are involved in mast cell binding c. they are involved in the activation of the complement cascade d. all above

Description : The following are true about the Fc regions of an immunoglobulins: a. they can be cleaved from the Fab regions by papain b. they are involved in mast cell binding c. they are involved in the activation of the complement cascade d. all above

Last Answer : all above

The performance of a cascade of CSTR's can be improved by adding (A) A P.F. reactor in series (B) A P.F. reactor in parallel (C) More CSTR's in series (D) More CSTR's in parallel

Description : The performance of a cascade of CSTR's can be improved by adding (A) A P.F. reactor in series (B) A P.F. reactor in parallel (C) More CSTR's in series (D) More CSTR's in parallel

Last Answer : (C) More CSTR's in series

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 amplifier will be preferred for highest gain? A) Darlington's pair B) Cascade amplifier C) Cascode amplifier D) Depends on the circuitry

Description : Which amplifier will be preferred for highest gain? A) Darlington's pair B) Cascade amplifier C) Cascode amplifier D) Depends on the circuitry

Last Answer : C) Cascode amplifier

__ bit in ICW1 indicates whether the 8259A is cascade mode or not? a) LTIM=0 b) LTIM=1 c) SNGL=0 d) SNGL=1

Description : __ bit in ICW1 indicates whether the 8259A is cascade mode or not? a) LTIM=0 b) LTIM=1 c) SNGL=0 d) SNGL=1

Last Answer : c) SNGL=0

What is the cascade of events that follows a stress or trauma to produce adrenal reaction? A) hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)-adrenal cortex mineralocorticoids and glucocorticoids (regulate metabolism and sugar level) B) hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)-adrenal cortex epinephrine and norepinephrine (regulate metabolism and sugar level) C) anterior pituitary (ACTH)-hypothalamus (ACTH-releasing hormone)-adrenal cortex hormones D) adrenal cortex (hormones)-anterior pituitary (ACTH)-hypothalamus (ACTH-releasing hormone) E) adrenal cortex (hormones)-hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)

Description : What is the cascade of events that follows a stress or trauma to produce adrenal reaction? A) hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)-adrenal cortex mineralocorticoids and ... ) E) adrenal cortex (hormones)-hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)

Last Answer : A) hypothalamus (ACTH-releasing hormone)-anterior pituitary (ACTH)-adrenal cortex mineralocorticoids and glucocorticoids (regulate metabolism and sugar level)

Which statement is NOT true about non-steroid (peptide) hormones? A) They are derived from peptides, proteins, polypeptides, and derivatives of amino acids. B) They bind to receptors on the cell surface. C) They form cyclic AMP inside the cell. D) They create an enzyme cascade effect. E) They enter the cell in order to have an effect.

Description : Which statement is NOT true about non-steroid (peptide) hormones? A) They are derived from peptides, proteins, polypeptides, and derivatives of amino acids. B) They bind to receptors on the cell surface. ... They create an enzyme cascade effect. E) They enter the cell in order to have an effect.

Last Answer : E) They enter the cell in order to have an effect.

Which statement about hormone types is correct? A) Non-steroid hormones activate an enzyme cascade. B) Steroid hormones regulate the production of a particular protein. C) Non-steroid hormones are either amino acids, peptides, or proteins. D) Steroid hormones all have four carbon rings with different side chains. E) All of the choices are correct.

Description : Which statement about hormone types is correct? A) Non-steroid hormones activate an enzyme cascade. B) Steroid hormones regulate the production of a particular protein. C) Non-steroid hormones are ... all have four carbon rings with different side chains. E) All of the choices are correct.

Last Answer : E) All of the choices are correct.

If the input to T-flipflop is 100 Hz signal, the final output of the three T-flipflops in cascade is (A) 1000 Hz (B) 500 Hz (C) 333 Hz (D) 12.5 Hz.

Description : If the input to T-flipflop is 100 Hz signal, the final output of the three T-flipflops in cascade is (A) 1000 Hz (B) 500 Hz (C) 333 Hz (D) 12.5 Hz.

Last Answer : (D) 12.5 Hz.

How To Make Cascade Generator

Description : How To Make Cascade Generator

Last Answer : This cascade engine was invented in the 1930's by a 17-year old amateur experimenter who was simply trying to make a new version of the old Fizeau's condenser. Instead, he discovered a ... a gravitic pressure wave in the surrounding space. Higher voltage and pulse rate generates greater thrust.

Which of the following mountain ranges were formed as a result of volcanic action? w) Appalachians x) Teton Range y) Front Range z) Cascade Range

Description : Which of the following mountain ranges were formed as a result of volcanic action? w) Appalachians x) Teton Range y) Front Range z) Cascade Range

Last Answer : ANSWER: Z -- CASCADE RANGE

State the need of cascade amplifier and draw circuit diagram of 2-stage direct coupled amplifier.

Description : State the need of cascade amplifier and draw circuit diagram of 2-stage direct coupled amplifier.

Last Answer : Need:- The voltage (or power) gain, obtained from a single stage small signal amplifier, is limited. Therefore, it is not sufficient for all practical applications. Therefore, in order to obtain greater voltage and power gain, cascade amplifiers are used.

State the need of cascade amplifier.

Description : State the need of cascade amplifier.

Last Answer : Most systems a single transistor amplifier does not provide sufficient gain or bandwidth or will not have the correct input or output impedance matching. Hence cascade amplifier is use which consist more than one stages of amplification.

Two two-port networks are connected in cascade. The combination is to be represented as a single two-port

Description : Two two-port networks are connected in cascade. The combination is to be represented as a single two-port network. The parameters of the network are obtained by multiplying the individual a. z-parameter matrix b. h-parameter matrix c. y-parameter matrix d. ABCD-parameter matrix

Last Answer : A

In an R-C phase shift oscillator, the minimum no. of R-C networks to be connected in cascade will be -

Description : In an R-C phase shift oscillator, the minimum no. of R-C networks to be connected in cascade will be -

Last Answer : In an R-C phase shift oscillator, the minimum no. of R-C networks to be connected in cascade will be 3

Two port networks are connected in cascade. The parameters of the network are obtained by multiplying in individual

Description : Two port networks are connected in cascade. The parameters of the network are obtained by multiplying in individual

Last Answer : Two port networks are connected in cascade. The parameters of the network are obtained by multiplying in individual ABCD parameter matrix

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.