Which SQL wildcard character is used to match exactly one single character when using the LIKE operator?
A. Percentage sign (%)
B. Question mark (?)
C. Underscore (*)
D. Asterisk (*)
Answer: Option C
Solution (By JKSSB Mock Tests)
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.
Explanation:
Data Control Language (DCL) includes commands like GRANT and REVOKE, which manage privileges and security configurations for database users.
No comments yet. Be the first to start the discussion!