Answer Posted / suriyaraj
Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is pl sql in dbms?
What is cursor and why it is required?
State few characteristics of pl/sql?
How many row comparison operators are used while working with a subquery?
What are different types of keys?
Why select is used in sql?
What does plv msg allows you to do?
how to convert numeric values to character strings? : Sql dba
How do you remove duplicate records from a table?
How do you get column names only for a table (sql server)?
How to return multiple rows from the stored procedure?
Is sql a scripting language?
Are stored procedures faster than dynamic sql?
