Quiz for LIKE Operator

Q1: Which operator is used to search for a pattern in SQL?

A. IN B. BETWEEN C. LIKE D. EXISTS

Q2: Which SQL keyword is used to search for a specified pattern in a column?

A. FIND B. SEARCH C. LIKE D. MATCH

Q3: What does the % symbol represent in the LIKE pattern?

A. A single character B. Any number of characters C. An exact match D. Only uppercase letters

Q4: Which pattern matches any value that starts with "A"?

A. "A%" B. "%A" C. "_A%" D. "%A%"

Q5: Which operator is used to find names ending with "son"?

A. "LIKE '%son'" B. "LIKE 'son%'" C. "LIKE '%son%'" D. "LIKE 'son'"

Q6: Which of the following matches exactly four-character strings starting with "A"?

A. "A___" B. "A%" C. "LIKE A%%%" D. "LIKE 'A????'"

Q7: What will LIKE '%a%' return?

A. All values without letter a B. All values starting with a C. All values ending with a D. All values containing a

Q8: Which symbol is used to match a single character?

A. % B. * C. _ D. #

Q9: How would you match any string that has "at" as the second and third characters?

A. "_at%" B. "%at_" C. "at%" D. "%_at%"

Q10: Which clause is commonly used with LIKE?

A. WHERE B. GROUP BY C. ORDER BY D. HAVING

Q11: What does the pattern "%data%" return?

A. Records with exact "data" B. Records starting with "data" C. Records ending with "data" D. Records containing "data"

Q12: Which pattern matches any string with "abc" at any position?

A. "abc%" B. "%abc%" C. "%abc" D. "_abc%"

Q13: How many characters does the underscore "_" match?

A. 0 B. 1 C. Multiple D. It depends

Q14: What does the LIKE pattern "t__t" match?

A. Any 4-letter string starting and ending with t B. Any 4-letter string C. Any string with two ts D. Any string containing t only

Q15: Which pattern matches the exact word "test"?

A. "LIKE 'test'" B. "LIKE '%test'" C. "LIKE 'test%'" D. "LIKE '%test%'"

Q16: Which of the following will match "sql123"?

A. "LIKE 'sql%'" B. "LIKE '%123'" C. "LIKE '%sql%'" D. All of the above

Q17: Which LIKE clause matches "java" but not "javascript"?

A. "LIKE 'java'" B. "LIKE 'java%'" C. "LIKE '%java%'" D. "LIKE '%java'"

Q18: LIKE is case sensitive in which database by default?

A. MySQL B. PostgreSQL C. Oracle D. SQL Server

Q19: Which symbol can be used to escape wildcards in LIKE?

A. \ B. / C. $ D. #

Q20: Which of the following queries returns names that do not contain "a"?

A. "WHERE name NOT LIKE '%a%'" B. "WHERE name LIKE '%a%'" C. "WHERE name = '%a%'" D. "WHERE name IS NOT 'a%'"