Which two statements are true about outer Joins?

Regarding the usage and rules of outer joins in SQL, specifically Oracle SQL:

D . A condition representing an outer join cannot be linked to another condition using the OR logical

operator: In SQL, when using the Oracle-specific (+) notation for outer joins, it is not permitted to

combine this condition with another using the OR operator. The use of (+) imposes restrictions to

ensure the join logic is correctly interpreted.

E . The outer join operator (+) is used next to the column of the table without the matching rows: The

(+) symbol in Oracle's SQL syntax denotes the table that should include "null" where data does not

exist to satisfy the join condition, effectively including rows that do not have a match in the joined

table.

Incorrect options:

A: The (+) operator cannot be used on both sides of a condition within the same join; it can only

appear on one side to define which side of the join is the outer part.

B: An outer join is used to retrieve all rows from one table and the matched rows from the other

table; it does not solely retrieve rows that do not meet the join condition.

C: The IN operator can be used in conditions involving an outer join, although specific rules and

behaviors need to be considered depending on the SQL version and implementation.