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.3) By 7402 users
Added on	8/7/2011
Views	69132
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

deletes the dependent rows in the child table when a row in the parent table is deleted. Source: CoolInterview.com

Answered by: Amit | Date: 9/1/2009 |

Contact Amit

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?	View Answer
	What is the maximum SIZE allowed for each type	View Answer
	How many LONG columns are allowed in a table	View Answer
	Is it possible to use LONG columns in WHERE clause or ORDER BY	View Answer
	What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint	View Answer
	Where the integrity constraints are stored in data dictionary	View Answer
	How will you activate/deactivate integrity constraints	View Answer
	If 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	View Answer
	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	View Answer
	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
	How do I eliminate the duplicate rows?	View Answer
	How do I display row number with records	View Answer
	Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query	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