Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 5 of 79

Database Query using SQL — Question 5

Back to all questions
5
Question

Question 5

Assertion (A): A Join is a query that combines rows from two or more tables.

Reasoning (R): Equi-joins are joins based on equality conditions.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true but R is not the correct explanation of A.

Explanation
An SQL JOIN clause is used to combine rows from two or more tables based on a common field between them. An Equi join is a simple SQL join condition that uses the equal sign (=) as a comparison operator to define a relationship between two tables based on a common field.