According to the SQL-92 standard, which two wildcard characters are used with the LIKE operator?

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:

• We are working with ANSI SQL-92 standard syntax.
• We must identify the correct wildcard characters.

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 ()