The wildcard in a WHERE clause is useful when?

Solution (By Examveda Team)

Option A: An exact match is necessary in a SELECT statement. - This option describes when you need to specify a precise condition for selecting data, which is not related to the use of wildcards in SQL.
Option B: An exact match is not possible in a SELECT statement. - This option incorrectly describes the use of wildcards. Wildcards are used in SELECT statements to match patterns rather than exact values.
Option C: An exact match is necessary in a CREATE statement. - The CREATE statement is used to create database objects such as tables, indexes, or views, and does not relate to the use of wildcards.
Option D: An exact match is not possible in a CREATE statement. - This option incorrectly describes the purpose of wildcards in SQL.
Conclusion:
In SQL, wildcards in a WHERE clause are useful when you need to match patterns rather than exact values in a SELECT statement. Therefore, the correct answer is Option B: An exact match is not possible in a SELECT statement.