Database Fundamentals — Question 57

You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?

Answer options

• A. FIND
• B. BETWEEN
• C. INCLUDES
• D. LIKE

Correct answer: D

Explanation

The correct answer is D, LIKE, because it allows for pattern matching in SQL queries, which is necessary to find products with names containing specific characters. Options A (FIND), B (BETWEEN), and C (INCLUDES) are not valid SQL keywords for this purpose.