Vidyalelo
Database · Q18

Introduction to SQL

Programming · Database · question 18

Q18

The SQL -92 wildcards are ____ and ____ .

A.
asterisk (*); percent sign (%)
B.
percent sign (%); underscore (_)
Answer
C.
underscore(_); question mark (?)
D.
question mark (?); asterisk (*)

Answer: Option B

Solution

Answer: Option B
Solution:
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 (_).