COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LIKE
|
|
|
SELECT
|
|
|
FIND
|
|
|
UPDATE
|
Detailed explanation-1: -The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
Detailed explanation-2: -LIKE operator is used for pattern matching, and it can be used as-. % – It matches zero or more characters.
Detailed explanation-3: -The pattern is a general description of the format of the string. It can consist of text or the special characters X, A, and N preceded by an integer used as a repeating factor. X stands for any characters, A stands for any alphabetic characters, and N stands for any numeric characters.
Detailed explanation-4: -The correct answer to the question “Which operator performs pattern matching in SQL” is option (b). LIKE operator.
Detailed explanation-5: -You can use the Like operator to find values in a field that match the pattern you specify.