What is true about joining tables through an equijoin?
A.
You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
B.
You can join a maximum of two tables through an equijoin.
C.
To join two tables through an equijoin, the columns in the join condition must be primary key
and foreign key columns.
D.
You can join n tables (all having single column primary keys) in a SQL statement by specifying
a minimum of n-1 join conditions.
E.
You can join a maximum of two columns through an equijoin.
Explanation:
For N joined tables using Oracle or ANSI/ISO syntax for table joins, you need at least N-1 equijoin
conditions in the WHERE clause of your SELECT statement or N-1 JOIN table_name ON
join_condition clauses in order to avoid a Cartesian product, respectively.