Multiple Choice
All of the following are true about the use of AND and OR operators in an SQL SELECT command, except ____.
A) AND has higher precedence than OR
B) AND and OR can be used together with any of the comparison operators
C) OR means one condition or the other or both
D) enclosing an AND or an OR operation in parentheses ensures that it will be performed before those outside of parentheses
E) either the AND or the OR operator may be used in a given SQL SELECT command, but not both
Correct Answer:

Verified
Correct Answer:
Verified
Q29: Only two tables can be joined in
Q30: Once a GROUP BY clause in an
Q31: SQL has commands that are capable of
Q32: The LIKE operator in the SQL SELECT
Q33: Typing SQL SELECT commands in at a
Q35: A relational query optimizer optimizes _.<br>A) the
Q36: The SQL SELECT command is capable of
Q37: In the SQL SELECT command embedded mode,
Q38: A data definition language (DDL) _.<br>A) is
Q39: In a relational database, a logical view