Question

Assertion (A): We can retrieve records from more than one table in MYSQL.
Reason (R): Foreign key is used to establish a relationship between two tables.

• A. Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation for Assertion (A).
• B. Both Assertion (A) and Reason (R) are true and Reason (R) is not the correct explanation for Assertion (A).
• C. Assertion (A) is true but, Reason (R) is false.
• D. Assertion (A) is false but, Reason (R) is true.

Hint:

Use foreign keys to relate tables structurally,
and use JOIN to retrieve combined data.

Answer 1

The Correct Option is B

In MYSQL, records can be retrieved from multiple tables using operations such as JOIN, which merges rows based on matching columns. Consequently, Assertion (A) is accurate. A foreign key is a field in one table that references the primary key of another, establishing a relationship between them. Therefore, Reason (R) is also true. However, the foreign key's function is to define relationships, not to perform data retrieval directly. Actual retrieval is accomplished through queries like JOIN statements. Thus, while Reason (R) is true, it does not correctly explain Assertion (A). Option (B) is therefore the correct choice.