CBSE 2025, Set 4, Q21

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.

Choose the correct option. A). Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A). B). Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A). C). Assertion (A) is true but Reason (R) is false. D). Assertion (A) is false but Reason (R) is true.

Edvaya · Accepted Answer

The correct answer is Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).. Using SQL joins, data can be retrieved from multiple tables. Example:

```sql SELECT S.Name, M.Marks FROM Students S JOIN Marks M ON S.RollNo = M.RollNo; ```
 Foreign keys help create relationships between tables, enabling such queries. Thus both Assertion and Reason are true and Reason explains Assertion.

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Database Concepts

Keep Practicing

Current Question

Community Stats

Track Your Progress

Edvaya Target

We Value Your Privacy