__When three or more AND and OR conditions are combined, it is easier – McqOptions

MCQOPTIONS

1.	__When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):__
A.	LIKE only.
B.	IN only.
C.	NOT IN only.
D.	Both IN and NOT IN.
Answer» E.

Discussion

No Comment Found

Related MCQs

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.~!
To establish a range of values, < and > can be used.~!
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.~!
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.~!
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.~!
Indexes can usually be created for both primary and secondary keys.~!
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.%!
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.%!
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.%!
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.%!