Join Examsbook
2283 0

Q: Which operator performs pattern matching ?

  • 1
    LIKE operator
  • 2
    EXISTS operator
  • 3
    BETWEEN operator
  • 4
    None of these
  • Show AnswerHide Answer
  • Workspace

Answer : 1. "LIKE operator"
Explanation :

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

Are you sure

  Report Error

Please Enter Message
Error Reported Successfully