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 |
if no size is defined while creating the database, what size will the database have? : Sql server administration
Is mysql better than sql server?
How to delete duplicate rows?
what is integrated security (SSPI). why we use in the connection string?
What is a job?
what is nonclustered index
What according to you is the difference between mysql and sql server performance?
What are three major types of constraints?
What is difference beteen Migration and Upgrdation?
what is raid? : Sql server database administration
What is the query optimization statistics?
About Indexed Views? with example? plz reply...
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)