When the wildcard in a WHERE clause is useful?

Category: SQLWhen the wildcard in a WHERE clause is useful?
Editor">Editor Staff asked 2 years ago

When the wildcard in a WHERE clause is useful?

  1. When an exact match is required in a SELECT statement.
  2. When an exact match is not possible in a SELECT statement.
  3. When an exact match is required in a CREATE statement.
  4. When an exact match is not possible in a CREATE statement.
1 Answers
Editor">Editor Staff answered 2 years ago

Answer:
2. When an exact match is not possible in a SELECT statement.
Explanation: The wildcard is a character used to search complex data from the database quickly. We can use it in conjunction with the LIKE or NOT LIKE comparison operators and the WHERE clause to find the result for a specified pattern. Hence, the wildcard is very useful when the exact match is not possible in the SELECT statement.