Multiple choice technology databases

Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2–5) FROM dual;

  1. +

  2. *

  3. /

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In the expression (2+3*4/2-5), operator precedence follows standard mathematical rules: multiplication () and division (/) are evaluated before addition (+) and subtraction (-). When operators have equal precedence ( and /), they're evaluated left to right. Therefore, 3*4=12 is computed first, then 12/2=6, then 2+6=8, then 8-5=3. The multiplication operator is evaluated first.