Computer Science
Assertion (A): Referential integrity is a constraint that defines rules of holding data in parent and child table.
Reasoning (R): Referential integrity ensures that users don't accidently delete or change related data.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
1 Like
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
Referential integrity is a constraint that defines rules for maintaining data relationships between parent and child tables in a database. The referential integrity constraint requires that values in a foreign key column must either be present in the primary key that is referenced by the foreign key or they must be null. It ensures the preservation of related data by preventing accidental deletion or modification.
Answered By
3 Likes
Related Questions
Assertion (A): RDBMS stands for Relational Database Management System.
Reasoning (R): RDBMS does not allow relating or associating two tables in a database.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion (A): A database is the largest component for holding and storing data and may contain several tables.
Reasoning (R): Each table comprises multiple rows and records.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion (A): The number of attributes or columns in a relation is called the degree of the relation.
Reasoning (R): The number of tuples or records in a relation is called the cardinality of the relation.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Assertion (A): A foreign key is an attribute whose value is derived from the primary key of another relation.
Reasoning (R): A foreign key is used to represent the relationship between tables or relations.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.