Oracle Database Administration I — Question 15

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

Answer options

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

Correct answer: D, E

Explanation

Option D is correct because arithmetic operators with equal precedence are indeed evaluated from left to right. Option E is also correct as multiple parentheses can be utilized to modify the default precedence. Options A, B, and C are incorrect because they misstate the rules regarding operator precedence.