Multiple choice technology databases

Which of the following shows the wildcards for a single character and multiple characters, respectively?

  1. ?, *

  2. _, %

  3. ?, _

  4. *, %
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL uses underscore (_) as the single-character wildcard and percent (%) as the multiple-character wildcard in LIKE patterns. This is standard SQL syntax. The other options use file system wildcards (?, *) which are not used in SQL.

Keep practicing — related questions