Q: Which operator performs pattern matching ?
- 1LIKE operatortrue
- 2EXISTS operatorfalse
- 3BETWEEN operatorfalse
- 4None of thesefalse
- Show Answer
- Workspace
- Discuss
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
Similar Questions
Since Nithya and Suganya exchange places, so Rita’s new position is the same as Monika’s earlier position. This position is 17th from the right and 10th from the left. Therefore Number of girls in the row = (16 + 1 + 9) = 26.