Which operator performs pattern matching ?
A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these
Which operator performs pattern matching
Answer: A) LIKE operator
Explanation:
LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).
The syntax is as follows:
SELECT “column_name”
FROM “table_name”
WHERE “column_name” LIKE {PATTERN}
{PATTERN} often consists of wildcards.
In SQL, there are two wildcards:
% (percent sign) represents zero, one, or more characters.
_ (underscore) represents exactly one character.
More :: Certification Questions on SQL
Subject: SQL – Technology
Job Role: Software Architect , IT Trainer , Database Administration , Analyst