Multiple choice

The type of join in relation algebra used to join a table to itself if the table were two tables and temporarily renaming at least one table in the SQL statement is called

  1. inner join

  2. left join

  3. full join

  4. self join

  5. cartesian join

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This type of join in relation algebra is used to join a table to itself if the table were two tables and temporarily renaming at least one table in the SQL statement.