ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What is the use of CASCADE CONSTRAINTS?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the use of CASCADE CONSTRAINTS?
Answer
# 1		 
to drop the constraint from child table when dropping the  
constraint from parent table.
 
Is This Answer Correct ?    3 Yes 1 No
Kunal Sain
 
  Re: What is the use of CASCADE CONSTRAINTS?
Answer
# 2		 
If you specify this option, later when you delete a row in 
the parent table, the database server also deletes any rows 
associated with that row (foreign keys) in a child table. 
The principal advantage to the cascading-deletes feature is 
that it allows you to reduce the quantity of SQL statements 
you need to perform delete actions.
 
Is This Answer Correct ?    5 Yes 0 No
Naresh
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is normalization?  6
What is difference beteen Migration and Upgrdation? Satyam4
What is a job?  3
What are the different types of joins and what does each do?  2
What do you mean by COLLATION?  4
What is the difference between UNION and UNIONALL? CTS2
what is the difference between group and having give an example with query and sample output  2
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?  2
What is a deadlock and what is a live lock? How will you go about resolving deadlocks? Microsoft1
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
In which year relase the 7.0& 2000 & 2005?  1
What is RAID and what are different types of RAID configurations? Wipro5
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance  1
Explain Active/Active and Active/Passive cluster configurations?  1
select empid empname from employee What is the result for the about query?  4
what is the purpose of creating view is sql server 2000 Wipro9
How will u find the query which is running in some other machine IBM2
Explain Active/Active and Active/Passive cluster configurations  1
What is blocking and how would you troubleshoot it?  1
What is the difference between SSAS 2000 and SSAS 2005? APX1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com