COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of following SQL Wildcard represents zero or more characters in MS Access?
|
|
____
|
|
|
?
|
|
|
%
|
|
|
*
|
Explanation:
Detailed explanation-1: -Here, % (means zero or more characters) is a wildcard character.
Detailed explanation-2: -MySQL Wildcards A wildcard character is used to substitute one or more characters in a string. Wildcard characters are used with the LIKE operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
Detailed explanation-3: -Wildcard characters in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access you need to know. The asterisk represents multiple unknown characters.
There is 1 question to complete.