Oracle
1Z0-074 · Question #50
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 expression E. The + binary operator has the highest precedence in an expression in a SQL statement. Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
New Features for Manageability
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 expression
- BMultiple parentheses can be used to override the default precedence of operators in an expression
- 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
(33 responses)- A3% (1)
- B73% (24)
- C6% (2)
- D18% (6)
Explanation
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
Topics
#operator precedence#SQL expressions#parentheses#arithmetic operators
Community Discussion
No community discussion yet for this question.