To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) You cannot use IN operator in a condition that involves an outer join - This option is incorrect. You can use the IN operator in a condition that involves an outer join. The use of the IN operator is not restricted in the context of an outer join.
Option B) You use (+) on both sides of the WHERE condition to perform an outer join - This option is incorrect. The use of (+) on both sides of the WHERE condition is not the correct syntax to perform an outer join. The correct syntax for an outer join varies depending on the database management system being used.
Option C) You use () on both sides of the WHERE condition to perform an outer join - This option is incorrect. The use of () on both sides of the WHERE condition is not the correct syntax to perform an outer join. The correct syntax for an outer join varies depending on the database management system being used.
Option D) You use an outer join to see only the rows that do not meet the join condition - This option is correct. An outer join is used to include all rows from one table and only the matching rows from the other table(s). When there is no match, the result will contain NULL values for the columns from the table with no matching rows.
Option E) In the WHERE condition, you use (+) following the name of the column in the table - This option is correct. The use of (+) following the name of the column in the WHERE condition is the syntax used to perform an outer join in Oracle SQL. It indicates that the join is an outer join and not an inner join.
Option F) You cannot link a condition that is involved in an outer join to another condition by - This option is correct. In some cases, when using outer joins, you cannot link a condition involved in the outer join to another condition using the AND or OR operators. This restriction depends on the specific database management system and its implementation of outer joins.
The correct answer is D, E, F. These options are correct because an outer join is used to see only the rows that do not meet the join condition, (+) is used in the WHERE condition to indicate an outer join in Oracle SQL, and there can be restrictions on linking conditions involved in an outer join to other conditions.