Multiple choice sql

The Microsoft Access wildcards are ____ and ____

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

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

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

  4. question mark (?); asterisk (*)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Microsoft Access, the wildcard characters are ? (matches any single character) and * (matches any number of characters). This differs from SQL standard where % and _ are used for pattern matching.

AI explanation

To answer this question, you need to understand the concept of wildcards in Microsoft Access.

Wildcards are special characters that are used to represent unknown or variable values in a search pattern. They are used in queries to search for data that matches a specific pattern.

The correct answer is D) question mark (?); asterisk (*).

Option A) asterisk (); percent sign (%) - This option is incorrect because the asterisk () is used to represent any number of characters, while the percent sign (%) is used as a wildcard in SQL, but not in Microsoft Access. Option B) percent sign (%); underscore () - This option is incorrect because the percent sign (%) is used as a wildcard in SQL, but not in Microsoft Access. The underscore () is used as a wildcard in Microsoft Access, but it is not one of the wildcards mentioned in the correct answer. Option C) underscore (); question mark (?) - This option is incorrect because the underscore () is used as a wildcard in Microsoft Access, but it is not one of the wildcards mentioned in the correct answer. The question mark (?) is not a wildcard in Microsoft Access. Option D) question mark (?); asterisk () - This option is correct because the question mark (?) is used to represent a single character, and the asterisk () is used to represent any number of characters in a search pattern in Microsoft Access.

Therefore, the correct answer is D) question mark (?); asterisk (*).

Keep practicing — related questions