NIELIT 2017 July Scientist B (IT) - Section B: 57

Question

If an SQL query involves NOT,AND,OR with no parenthesis

• A. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
• B. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
• C. AND will be evaluated first; OR will be evaluated second;NOT will be evaluated last.
• D. The order of occurrence determines the order of evaluation.

Answer 1

Operators having same precedence are placed in the same row.

SQL Operators:

• Parenthesis ( )
• DIVISION (/), MULTIPLICATION(*)
• ADDITION (+), SUBSTRACTION(-)
• NOT
• AND
• ALL, ANY, BETWEEN, IN, LIKE, OR

A gives the correct order of precedence.

This can be changed by using parenthesis, that is why questions clearly mentions no parenthesis is used.

Ref: http://www.sqlqueryexamples.com/sql-logical-operators-and-operator-precedence.htm

Comments

This is exactly the same in the context of C -programming language,right ??