The wildcard in a WHERE clause is useful when?

A. An exact match is necessary in a CREATE statement.

B. An exact match is necessary in a SELECT statement.

C. An exact match is not possible in a SELECT statement.

D. An exact match is not possible in a CREATE statement.

Answer: Option C

Solution(By Examveda Team)

The wildcard in a WHERE clause, often represented by the '%' symbol, is useful when an exact match is not possible in a SELECT statement. It allows for pattern matching and retrieval of rows that meet specific criteria, even when the exact values are not known. Options A and D are not correct because wildcards are not typically used in CREATE statements, and Option B does not accurately represent the primary use of wildcards in SQL, which is for pattern matching in SELECT statements.