Which SQL wildcard character is used to match exactly one single character when using the LIKE operator?
A. Question mark (?)
B. Underscore (*)
C. Asterisk (*)
D. Percentage sign (%)
Answer: Option B
Solution (By JKExamLibrary)
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.
No comments yet. Be the first to start the discussion!