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 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 ?    1 Yes 0 No
Koteshwar Rao .palleboina
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Explain the architecture of SQL Server?  2
What is the difference between OLEDB and ODBC CFCI2
how to delete duplicate rows from table CSC2
How can you see what type of locks used?  1
What is a join and their types? Challenger-Financial2
Hi..here i would like to know the Backup and Restore models? HCL2
What is the purpose of UPDATE STATISTICS?  1
wat is the main diff between sql server 2000and sql server 2005 Jade-Software4
How can i change the column name. HCL6
Can you explain the role of each service?  1
When do you use SQL Profiler?  2
Questions regarding Raiseerror?  1
could u plz explain about joins and views?  2
What is the use of DBCC commands?  1
What is a function? Give some example?  1
how do we find every fifth record in a table  6
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?  1
What is the use of CASCADE CONSTRAINTS?  2
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1; Patni6
What are the magic tables in SQL Server 2000? Infogain5
 
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