Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 64 of 78

Simple Queries in SQL — Question 18

Back to all questions
18
Question

Question 18

The pattern '_ _ _' matches any string of ............... three characters. '_ _ _%' matches any string of ............... three characters.

  1. Atleast, Exactly
  2. Exactly, Atleast
  3. Atleast, All
  4. All, Exactly
Answer

Exactly, Atleast

Reason — '_ _ _' matches any string of exactly 3 characters. Each dash represents one character, so there must be three characters in total. '_ _ _%' matches any string of at least 3 characters. The first three dashes represent exactly three characters, and the '%' symbol matches any substring. So, it matches any string with three or more characters.