The SQL keyword(s) ________ is used with wildcards.
A. LIKE only
B. IN only
C. NOT IN only
D. IN and NOT IN
Answer: Option A
Solution (By Examveda Team)
Option A: LIKE only - The LIKE keyword in SQL is used with wildcards to search for a specified pattern in a column. This option correctly identifies the keyword used with wildcards.Option B: IN only - The IN keyword is used to specify multiple values for a column, not with wildcards.
Option C: NOT IN only - The NOT IN keyword is used to exclude specified values from a column, not with wildcards.
Option D: IN and NOT IN - Both IN and NOT IN are used to specify values or exclude values from a column, not with wildcards.
Conclusion:
In SQL, the keyword LIKE is specifically used with wildcards to perform pattern matching in a column. Therefore, the correct answer is Option A: LIKE only.
This Question Belongs to Database >> Introduction To SQL
Join The Discussion