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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 referential integrity and how is it achieved?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is referential integrity and how is it achieved?
Answer
# 1
when foreign  key constraint is created on a column 
referential integrity is achieved .
when foreign key constraint is created on a column,that 
column reference other column in the different table or 
even in the same table but the reference column must be 
primary key or unique key.
when a new value is added in a column referenced with 
foreign key ,then the foreign key relation checks whether 
the new value matches with the reference column or not.
If value matches then they  are allowed into the table
 
Is This Answer Correct ?    4 Yes 0 No
Koteshwar Rao .palleboina
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
logshipping is Any difference 2000 and 2005?  1
How will u find the query which is running in some other machine IBM2
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  5
what is maximum size of temp db? iSoft4
how to generate XML out of QUERY? McAfee1
how to find nth highest salary NexGen30
What is a NOLOCK?  3
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
What is a Join in SQL Server?  2
what is web server? Satyam3
How can we write or define DDL statements in Sql server and DML statements?  2
Display a roll having miminum marks in two subjects? Patni7
What is user stored procedure & it purpose? Wipro3
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?  3
what purpose does OPENXML clause have in sql server stored procedure?  1
what is diffence between replicaion and logshipping?  1
Explain some DBCC commands?  4
What is normalization?  6
What are the two types of concurrency?  2
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1
 
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