Multiple choice

Which predicate is used for pattern matching and to compare a string constant with a column of type character in DBMS?

  1. IN predicate

  2. LIKE predicate

  3. GROUP-BY

  4. COUNT

  5. SUM

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Pattern matching can be done using LIKE predicate. In pattern matching, string constant is compared with a column of type character.