COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
?
|
|
|
&
|
|
|
%
|
|
|
$
|
Detailed explanation-1: -Note − MS Access uses the asterisk (*) wildcard character instead of the percent sign (%) wildcard character. Matches one character.
Detailed explanation-2: -To locate a specific item when you can’t remember exactly how it is spelled, try using a wildcard character in a query. Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data.
Detailed explanation-3: -A wildcard is a symbol that takes the place of an unknown character or set of characters. Commonly used wildcards are the asterisk ( * ) and the question mark ( ? ). Depending on the software or the search engine you are using, other wildcard characters may be defined.