Search Interview Questions
Question: What is the use of CASCADE CONSTRAINTS?
Answer: When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
Question: What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists. Source: CoolInterview.com
For identifying the continuous constraints Source: CoolInterview.comAnswered by: sabari | Date: | Contact sabari
cascading is used for maintaining referencial integrity rules, which says that foreign key attributes values should be either subset of primary key values or null.
The cascade option of the drop clause causes any dependent constraints also to be dropped. Source: CoolInterview.comAnswered by: SHEETAL.H.KULKARNI | Date: 11/21/2007 | Contact SHEETAL.H.KULKARNI
we cant able to delete a record from the parent table if there is some corresponding record exists in the child table.
When we delete the record in parant table , the corresponding records in child table will be deleted automatically. Source: CoolInterview.comAnswered by: Ramesh | Date: 4/27/2009 | Contact Ramesh
cascade constraints describes about the parent-child relationship between tables. Source: CoolInterview.comAnswered by: pushpa g | Date: 5/30/2009 | Contact pushpa g
cascade option plays a key role in foreign and primary key table.
cascade delete means if primary key value is deleted than foreign key value is also deleted. Source: CoolInterview.comAnswered by: faran | Date: 8/16/2009 | Contact faran
assume that if we r using any foreign key,and because of any resion it is compulsary to delete the primary key value,for this firstly we will have to delete all value of forign key which is refering the value of primary key,it is vary tadious,to overcome with this problem we use On delete cascade or on delete null ,On delete cascade will directly remove aal the value of foreign key which is referin the value of primary key,and on delete null will put the null without deleting.
cascading is done in sql2 to maintain integrity rules in sql2 when we write cascade in a query it will tell to delete all the column which are dependent on that query row deletion Source: CoolInterview.comAnswered by: Naved | Date: 8/31/2009 | Contact Naved
The CASCADE CONSTRAINTS clause drops all
The cascade option of the drop clause causes any dependent constraints also to be dropped. Source: CoolInterview.comAnswered by: Mukesh | Date: 10/3/2009 | Contact Mukesh
child record gets automatically delted when parent record is delete if on delete cascase option is used whille creating table Source: CoolInterview.comAnswered by: naved khan | Date: 12/3/2009 | Contact naved khan
with the help of cascading constraint we can able to delete a record from the parent table as well as all the corresponding records from the child table.even we can set some null values.
consider there are two tables and both are inter related with their keys(foreign key ) then you cannot delete parent table, by using delete cascade you can delete constraint pertaining to parent table even with existence of child table Source: CoolInterview.comAnswered by: Manju | Date: 2/1/2010 | Contact Manju
drop is used for deleting entire table Source: CoolInterview.comAnswered by: vijay | Date: 2/17/2010 | Contact vijay
The cascade option of the drop clause causes any dependent constraints also to be dropped.
when we want to delete parent table but related with child so we cant do that so we can use the casecade
cascading constraint are used to decrease the line of code and reduce the design cost. Source: CoolInterview.comAnswered by: dinesh | Date: 5/15/2010 | Contact dinesh
Basically Cascading constraints are use to maintain the Referencial integrity i.e. when we delete some record from parent table the correspoding data in child table should be affected. Source: CoolInterview.comAnswered by: Manoj ku. Bardhan | Date: 6/16/2010 | Contact Manoj ku. Bardhan
cascade constraint is used to maintain intigrity into database.so the in future do not confilct data Source: CoolInterview.comAnswered by: Nikunj Patel | Date: 7/7/2010 | Contact Nikunj Patel
cascade option plays a key role in foreign and primary key table for maintaining the integrity
Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, then the database returns an error and does not drop the table. Source: CoolInterview.comAnswered by: prasad | Date: 9/9/2010 | Contact prasad
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:-
|Which function is used to find the largest integer less than or equal to a specific value?||
What is the output of the following query
SELECT TRUNC(1234.5678,-2) FROM DUAL;
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.
India News Network
Latest 20 Questions
Payment of time- barred debt is:
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal