Multiple choice technology databases

which is an escape identifier i.e, used to avoid the meaning of wildcard characters, and hence interpret underscore and percentage literally

  1. \

  2. /

  3. ESCAPE

  4. *
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The ESCAPE keyword in SQL is used to define an escape character that allows wildcard characters like _ (underscore) and % (percent) to be treated as literal characters rather than wildcards in LIKE patterns. For example, 'LIKE '10%%' ESCAPE '' treats the first % as a literal and the second as a wildcard.

Keep practicing — related questions