Examveda

The Microsoft Access wildcards are ____ and ____ .

A. asterisk (*); percent sign (%)

B. percent sign (%); underscore (_)

C. underscore(_); question mark (?)

D. question mark (?); asterisk (*)

Answer: Option B

Solution (By Examveda Team)

Option A: asterisk (); percent sign (%) - This option is incorrect. While the asterisk () is a wildcard character in Microsoft Access (and SQL generally for SELECT statements), the percent sign (%) is used in SQL for pattern matching, not specifically as a wildcard in Microsoft Access.
Option B: percent sign (%); underscore () - This option is correct. In Microsoft Access, 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 () and question mark (?) are not commonly used as wildcards in Microsoft Access. This option is incorrect.
Option D: question mark (?); asterisk () - The question mark (?) and asterisk () are not typically used as wildcards in Microsoft Access. This option is incorrect.
Conclusion:
In Microsoft Access, the wildcards are Option B: percent sign (%) and underscore (_). These characters are used for pattern matching in queries to match specific text patterns within data fields. Therefore, the correct answer is Option B.

This Question Belongs to Database >> Introduction To SQL

Join The Discussion

Related Questions on Introduction to SQL

The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.