Which term describes a wildcard placeholder for text used with LIKE or ILIKE statements?

Which term describes a wildcard placeholder for text used with LIKE or ILIKE statements?

• A. ILIKE
• B. LIKE
• C. IN
• D. Wildcard

Answer: (D)

In SQL pattern matching, you use a pattern with the LIKE or ILIKE operator, and the characters in that pattern act as placeholders for text. The term for those placeholder characters is "wildcard." These wildcards (such as % and _) stand in for unknown text: % represents any sequence of characters, while _ represents a single character. So the overall concept described by the prompt is the wildcard, which is the label for these flexible parts of a pattern. The other terms refer to the operators themselves (LIKE or ILIKE) or to a different kind of test (IN checks membership in a set), but they aren’t the name of the placeholder used in the pattern. For example, WHERE name LIKE 'A%' uses % as a wildcard to match any string beginning with A.

In SQL pattern matching, you use a pattern with the LIKE or ILIKE operator, and the characters in that pattern act as placeholders for text. The term for those placeholder characters is "wildcard." These wildcards (such as % and _) stand in for unknown text: % represents any sequence of characters, while _ represents a single character. So the overall concept described by the prompt is the wildcard, which is the label for these flexible parts of a pattern. The other terms refer to the operators themselves (LIKE or ILIKE) or to a different kind of test (IN checks membership in a set), but they aren’t the name of the placeholder used in the pattern. For example, WHERE name LIKE 'A%' uses % as a wildcard to match any string beginning with A.