Maria writes a query that uses outer join between two tables. Which of the following operators are not allowed in the query?
Each correct answer represents a complete solution. Choose two.
[2910,2912]
Correct:
--> OR
--> IN
Explanation:
Answer options A and C are correct.
The operators OR and IN are not allowed in outer join operations. However, the operators AND and = can be used.
OR is a logical operator and contains two operands. It evaluates to TRUE if either operand is TRUE and evaluates to FALSE if both operands are FALSE. Otherwise, it returns NULL.
The IN operator replaces a condition that uses equality comparison operators and OR logical operators.
Answer option B is incorrect. AND is also a logical operator and contains two operands. It evaluates to TRUE if both operands are TRUE and evaluates to FALSE if either operand is FALSE. Otherwise, it returns NULL.
Answer option D is incorrect. The = operator tests for equality.