The query performance increases by using NOT operator.
True
False
If there are 3 persons with last names JOHN, J and JAMES how many of them are included in the result set of the query "SELECT LAST_NAME FROM STAFF WHERE LAST_NAME BETWEEN 'A' AND 'J'"
3
2
1
0
NULL values are ingnored for all SQ: 2008 aggregate functions.
Which operators can be used to produce summary totals in the result sets of SQL 2008.
GROUPING
WITH ROLL UP
WITH CUBE
WITH SUMMARY
UNION ALL is faster than a UNION
NULL values are ingnored for all SQL: 2008 aggregate functions.
Which one is single-row function
STDDEV
VARIANCE
ROUND
COUNT
which of this Operator Precedence is correct??
+, - , || (Addition, subtraction, concatenation)
NONE of these
Which of these is NOT a inequality symbol ??
!=
<>
=^
^=