WorksheetsSQL WILDCARDS
Total questions: 9
Worksheet time: 4mins
Which of following SQL Wildcard represents zero or more characters in MS Access?
_
?
%
*
Which of following SQL Wildcard represents a single character in MS Access?
*
?
!
_
Which of following SQL Wildcard represents a single character in MS Access?
[ ]
*
_
$
Which of following SQL Wildcard represents a single numeric character in MS Access?
*
_
#
&
Which of following SQL Wildcard represents zero or more characters in SQL Server?
%
*
( )
\
Which of following SQL Wildcard represents a single character in SQL Server?
#
$
[ ]
_
Which of following SQL Wildcard represents a single character in SQL Server?
%
_
&
#
Which operator allows you to specify multiple values in a WHILE clause?
SELECT
FROM
IN
SELECT DISTINCT
Which operator selects values within a given range?
AND
LIKE
SELECT
BETWEEN
