What is ON DELETE CASCADE ? - 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.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

SQL PLUS

DETAILS

Question: What is ON DELETE CASCADE ?

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.

Category	SQL Plus Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9784 users
Added on	10/27/2009
Views	70583
Rate it!

Question: What is ON DELETE CASCADE ?

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. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What are the data types allowed in a table ?	View Answer
	What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?	View Answer
	How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?	View Answer
	What are the pre requisites ?	View Answer
	Where the integrity constraints are stored in Data Dictionary ?	View Answer
	How will you a activate/deactivate integrity constraints ?	View Answer
	If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?	View Answer
	What is a database link ?	View Answer
	How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?	View Answer
	What is CYCLE/NO CYCLE in a Sequence ?	View Answer
	What are the advantages of VIEW ?	View Answer
	Can a view be updated/inserted/deleted? If Yes under what conditions ?	View Answer
	If a View on a single base table is manipulated will the changes be reflected on the base table ?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Plus Interview Questions & Answers - Exam Mode / Learning Mode