The operator that performs pattern matching in SQL is option B) LIKE operator.
The BETWEEN operator is used to check if a value lies within a specified range, rather than performing pattern matching.
The EXISTS operator is used to check for the existence of rows in a subquery, and it does not perform pattern matching.
In contrast, the LIKE operator is specifically designed for pattern matching in SQL.
It allows you to search for values that match a specified pattern using wildcard characters such as "%" and "_".
The "%" wildcard represents zero or more characters, while the "_" wildcard represents a single character.
For example, you can use the LIKE operator to find all names starting with "J" by using the pattern "J%".
Similarly, you can use it to find all names with exactly five characters by using the pattern "_____".
Therefore, the LIKE operator is the correct choice for performing pattern matching in SQL.