Oracle Database SQL — Question 268

Which two are true about the precedence of operators and conditions? (Choose two.)

Answer options

• A. || has a higher order of precedence than + (addition).
• B. + (addition) has a higher order of precedence than * (multiplication).
• C. NOT has a higher order of precedence than AND and OR in a condition.
• D. AND and OR have the same order of precedence in a condition.
• E. Operators are evaluated before conditions.

Correct answer: C, E

Explanation

The correct answers are C and E because the NOT operator indeed has a higher precedence than both AND and OR, which affects the order of evaluation in conditions. Additionally, operators are evaluated before conditions, which is a fundamental rule in programming logic. The other options are incorrect as they misrepresent the order of precedence among the operators.