FUNDAMENTALS OF COMPUTER

COMPUTER PROGRAMMING FUNDAMENTALS

WHAT IS PROGRAMMING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following wildcard character represents zero or more characters in SQL?
A
Ampersand(&)
B
Underscore ( ____ )
C
Percentage (%)
D
None of the above
Explanation: 

Detailed explanation-1: -Asterisk ( * ) in a wildcard The asterisk in a wildcard matches any character zero or more times.

Detailed explanation-2: -There are two wildcards often used in conjunction with the LIKE operator: The percent sign (%) represents zero, one, or multiple characters. The underscore sign ( ) represents one, single character.

Detailed explanation-3: -Wildcard characters allow you to enter pieces of information and narrow your search criteria. You can use characters such as the percent sign (%), which represents any number of characters, or an underscore ( ), which represents a single character.

Detailed explanation-4: -The percent sign is analogous to the asterisk (*) wildcard character used with MS-DOS. The percent sign allows for the substitution of one or more characters in a field. The underscore is similar to the MS-DOS wildcard question mark character.

There is 1 question to complete.