What is referential integrity and how is it achieved?
Answer / koteshwar rao .palleboina
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 ? | 15 Yes | 1 No |
Wht is SQL Injection Attack ?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a data source or ds? : sql server analysis services, ssas
What is difference between unique and primary key?
Can you please explain the difference between function and stored procedure?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is a field in a table?
Write a sql query to display the current date?
Explain some DBCC commands?
What does select 1 mean?
What is the difference between mysql and mysqli?
Do you know what are acid properties of transaction?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)