Multiple choice technology databases

Which wildcard character is used for a single character replacement

  1. %

  2. &

  3. _

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The underscore (_) is the SQL wildcard character that represents exactly one character in a LIKE pattern. This differs from % which matches zero or more characters.

AI explanation

In SQL LIKE pattern matching, the underscore (_) wildcard matches exactly one arbitrary character, whereas % matches zero or more characters (any length). Since the question asks specifically about single-character replacement, _ is the correct wildcard, not the multi-character %.

Keep practicing — related questions