MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The SQL-92 wildcards are ____ and ____ .
A
asterisk (*); percent sign (%)
B
percent sign (%); underscore ( ____ )
C
underscore( ____ ); question mark (?)
D
question mark (?); asterisk (*)
Explanation: 

Detailed explanation-1: -Answer. underscore, question mark.

Detailed explanation-2: -A wildcard character is used to substitute one or more characters in a string. Wildcard characters are used with the LIKE operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

Detailed explanation-3: -SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the following table. Sr.No. Matches one or more characters. Note − MS Access uses the asterisk (*) wildcard character instead of the percent sign (%) wildcard character.

Detailed explanation-4: -Answer: The % wildcard symbol is used in LIKE clause to represent any sequence of none, one or more characters.

There is 1 question to complete.
Previous
Next