ISRO Computer Science (CSE) 2023 - Question 31

All ISRO Computer Science (CSE) papers | ISRO Computer Science (CSE) 2023

Topic: Database Management Systems

In SQL the statement select * from R, S is equivalent to

  • A. Select * from R natural join S
  • B. Select * from R cross join S
  • C. Select * from R outer join S
  • D. Select * from R inner join S

Answer: B. Select * from R cross join S

Explanation: In SQL, selecting from multiple tables separated by a comma (e.g., `FROM R, S`) without specifying a `WHERE` clause for join conditions evaluates to a Cartesian product, which is functionally equivalent to a cross join.

| | All questions of ISRO Computer Science (CSE) 2023