Describe Referential Integrity ?
Answer / orawhiz
A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to be
performed on dependent data as a result of any action on
referenced data.
| Is This Answer Correct ? | 4 Yes | 0 No |
How can we find the size of a database?
How to define a variable to match a table column data type?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
How to use subqueries with the exists operator in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Which environment variables are absolutely critical in order to run the OUI?
What is bulk collect in oracle?
What is the difference between sharding and replication?
What is dual table oracle?
What is the difference between online and offline backups?
What is a snapshot in oracle database?