Multiple choice technology databases

Select the correct order of evaluation for following operators: I.LIKE II.NOT III.AND IV.OR

  1. I,III,IV,II

  2. I,II,III,IV

  3. IV,III,II,I

  4. IV,II,I,III
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL operator precedence follows a specific order: NOT has the highest precedence (negation), then AND (conjunction), then OR (disjunction). LIKE is a comparison operator that evaluates before logical operators. The correct order is: LIKE (I) evaluates first, then NOT (II), then AND (III), then OR (IV).

Keep practicing — related questions