Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 3 of 91

Grouping Records, Joins in SQL — Question 3

Back to all questions
3
Question

Question 3

Assertion. SQL SELECT query can also fetch rows from multiple tables.

Reason. A join is a query that combines rows from two or more tables.

Answer

(a)

Both Assertion and Reason are true and Reason is the correct explanation of Assertion.

Explanation
SQL SELECT queries can fetch rows from multiple tables using JOIN operations. This allows retrieving data from related tables simultaneously in a single query. A join in SQL is a query that combines rows from two or more tables based on a specified condition, such as matching values in a common column.