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

The correct answer is C. The + binary operator has the highest precedence in an expression in a SQL statement E. Multiple parentheses can be used to override the default precedence of operators in an. https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm

SQL and PL/SQL

Question

Options

AThe concatenation operator | | is always evaluated before addition and subtraction in an
BNULLS influence the precedence of operators in an expression
CThe + binary operator has the highest precedence in an expression in a SQL statement
DArithmetic operators with equal precedence are evaluated from left to right within an expression
EMultiple parentheses can be used to override the default precedence of operators in an

How the community answered

(31 responses)

A
6% (2)
B
10% (3)
C
81% (25)
D
3% (1)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm

Topics

#operator precedence#arithmetic operators#parentheses#SQL expressions

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice