Difficulty: Easy
Correct Answer: percent sign (%); underscore (_)
Explanation:
Introduction / Context:
SQL-92 standardized wildcard characters for pattern matching in the LIKE operator. These differ from the wildcards in Microsoft Access.
Given Data / Assumptions:
Concept / Approach:
In SQL-92, % matches any sequence of characters and _ matches exactly one character. These are the only wildcards defined for LIKE.
Step-by-Step Solution:
Verification / Alternative check:
Database documentation (Oracle, SQL Server, PostgreSQL, MySQL) confirms % and .
Why Other Options Are Wrong:
, ?: Access syntax, not SQL-92.
with %: Mixed set, incorrect.
Common Pitfalls:
Confusing Access and SQL-92 wildcards.
Final Answer:
percent sign (%); underscore ()
Discussion & Comments