ExamVeda
Login
Home
This question belongs to Database Introduction To SQL
Introduction to SQL
?

The SQL -92 wildcards are ____ and ____ .

Answer & Solution
Correct Answer: Option B
Option A: asterisk (); percent sign (%) - This option is incorrect. While the percent sign (%) is a wildcard character in SQL-92 for matching zero or more characters, the asterisk () is not a wildcard character in SQL.
Option B: percent sign (%); underscore () - This option is correct. In SQL-92, the percent sign (%) is used as a wildcard for matching zero or more characters, and the underscore () is used as a wildcard for matching a single character.
Option C: underscore (); question mark (?) - The underscore () is a wildcard character in SQL-92, but the question mark (?) is not a wildcard character in SQL. This option is incorrect.
Option D: question mark (?); asterisk () - The question mark (?) is not a wildcard character in SQL-92, and the asterisk () is not a wildcard character in SQL. This option is incorrect.
Conclusion:
In SQL-92, the wildcards are Option B: percent sign (%) and underscore (_).
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.