We refer to a join as a self-join when?we are joining more than 2 tableswe are joining two tables onlywe are joining table to itselfwe are using left and right join together

In a self-join query, a table is joined to itself  by using -Non-Equijoins to treat the tables as two separate tables.Equijoins to treat the tables as two separate tables.Table aliases to treat the tables as two separate tables.None of these

Joining a table to itself is called as ______.Select one:a.Self Joinb.Equi Joinc.Non Equi Joind.Outer Join

Which of the following is true? I. Implementation of self-join is possible in SQL with table alias.II. Outer-join operation is the basic operation in relational algebra. III. Natural join and outer join operations are equivalent.

Which of the following keyword is equivalent to INNER JOIN?Select one:a.JOINb.LEFT JOINc.None of the answers are correctd.RIGHT JOINe.FULL JOIN

What is the primary purpose of a self join in SQL?Answer choicesSelect an optionTo join a table with itself to simulate a recursive relationship.To join two tables based on a primary key-foreign key relationship.To merge the contents of two entirely different tables into one.To update records in a table based on values in another table.