Oracle Database SQL — Question 213

Which two statements are true about the rules of precedence for operators? (Choose two.)

Answer options

• A. The + binary operator has the highest precedence in an expression in a SQL statement.
• B. The concatenation operator || is always evaluated before addition and subtraction in an expression.
• C. Multiple parentheses can be used to override the default precedence of operators in an expression.
• D. NULLS influence the precedence of operators in an expression.
• E. Arithmetic operators with equal precedence are evaluated from left to right within an expression.

Correct answer: C, E

Explanation

Option C is correct because parentheses can indeed alter the standard order of operations. Option E is also correct as operators with the same precedence are processed from left to right. Options A, B, and D are incorrect because they misstate the rules of operator precedence in SQL.