Question 128Asked in BPSC TRE 2.0 (2023) Computer Science Class 11-12

Which of the following SQL keywords is used to display data from a table based on certain pattern?

  1. AIN
  2. BLIKE
  3. CBETWEEN
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (B) LIKE

Explanation

LIKE matches patterns using the wildcards % (any sequence) and _ (one character). IN tests a list and BETWEEN tests a range.

From BPSC TRE 2.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 128 of BPSC TRE 2.0 (2023) Computer Science Class 11-12 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.