Question

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 1

______✨ HEY MATE ✨______

➡️ Option (C) An exact match is not possible in a SELECT statement is the right answer ✔️

$<marquee>✌️ I THINK IT HELPED YOU ✌️$

Answer 2

Answer:

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

Explanation:

Only when an accurate model in a SELECT statement is impossible is the wildcard useful.

To replace one or more characters in a string, use a wildcard character. The LIKE operator uses wildcard symbols. To look for a particular pattern in a field, use the LIKE operator in a WHERE clause.

The exact match may not be achievable for char constants. In such circumstances, we employ percent wildcard. Any substring can be replaced using wildcard characters. for instance, select * from employee where name LIKE "s percent " and - substitute single letter can be used to build a question to get the identities that begin with s.

The wildcard could be used as the category of a parameter, field, local variable, or occasionally as a return value.

#SPJ2