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? What are the advantages of it?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is referential integrity? What are the advantages of it?
Answer
# 1
refrential nothing but forgein key
 
Is This Answer Correct ?    3 Yes 3 No
Ramakrishna
 
  Re: What is referential integrity? What are the advantages of it?
Answer
# 2
it show referance to another location with accuracy.
 
Is This Answer Correct ?    1 Yes 2 No
Rajdeo Kumar
 
 
 
  Re: What is referential integrity? What are the advantages of it?
Answer
# 3
Referential integrity
Referential integrity in a relational database is 
consistency between coupled tables. Referential integrity 
is usually enforced by the combination of a primary key or 
candidate key (alternate key) and a foreign key. For 
referential integrity to hold, any field in a table that is 
declared a foreign key can contain only values from a 
parent table's primary key or a candidate key. For 
instance, deleting a record that contains a value referred 
to by a foreign key in another table would break 
referential integrity. A relational database management 
system (RDBMS) enforces referential integrity, normally 
either by deleting the foreign key rows as well to maintain 
integrity, or by returning an error and not performing the 
delete. Which method is used would be determined by the 
referential integrity constraint, as defined in the data 
dictionary.
 
Is This Answer Correct ?    3 Yes 1 No
Anand
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  4
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
Explain different isolation levels?  3
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"  6
Can you explain the types of Joins that we can have with Sql Server?  2
How to write stored procedure to update the data in 10 tables  4
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
how to rest identity columns in sql server Matrix3
What is an extended Stored Procedure?  1
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?  3
What are the differences between stored procedure and functions in SQL Server 2000? TCS12
Wht is the difference between stored procedure and trigger TCS4
Explain Trigger with an example?  1
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz... Value-Labs5
How the data stores in a page?  1
any one can explain Self mapping Delegation Remote Credentials  1
what is the output for this query select * from employee where 1=1;  4
when inserting to a table how many rows will be effected using triggers  1
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  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