Oracle
1Z0-071 · Question #344
Which two statements are true about the rules of precedence for operators? (Choose two.)
The correct answer is B. Multiple parentheses can be used to override the default precedence of operators in an E. The + binary operator has the highest precedence in an expression in a SQL statement. https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
Retrieving Data Using the SQL SELECT Statement
Question
Which two statements are true about the rules of precedence for operators? (Choose two.)
Options
- AThe concatenation operator | | is always evaluated before addition and subtraction in an
- BMultiple parentheses can be used to override the default precedence of operators in an
- CArithmetic operators with equal precedence area evaluated from left to right within an expression
- DNULLS influence the precedence of operators in an expression
- EThe + binary operator has the highest precedence in an expression in a SQL statement
How the community answered
(46 responses)- A4% (2)
- B72% (33)
- C15% (7)
- D9% (4)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
Topics
#operator precedence#arithmetic operators#parentheses#concatenation
Community Discussion
No community discussion yet for this question.