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.

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

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

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

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.

What is the purpose of the SQL JOIN operation?OptionsTo combine rows from two or more tables based on a related column between themTo filter rows based on a specified conditionTo group rows based on a common attributeTo sort the result set in ascending order