Computer Science
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.
SQL Queries
1 Like
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
A foreign key is a non-key attribute whose value is derived from the primary key of another table in a database. It references the primary key in another table, thereby establishing a relationship between the two tables.
Answered By
3 Likes
Related Questions
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.
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): Order by clause is used to sort the records of a table in ascending or descending order.
Reasoning (R): For sorting in ascending or descending order, ASC and DESC keywords are used along with the Order by clause.
- 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): COUNT() function ignores distinct values.
Reasoning (R): Distinct clause ignores duplicate values.
- 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.