Quiz for LIKE

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

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

Q2: What does the SQL LIKE operator do?

A. Matches a specific pattern in a column B. Deletes duplicate records C. Creates a new table D. Joins two tables

Q3: Which wildcard character matches any number of characters?

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

Q4: Which wildcard character matches exactly one character?

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

Q5: Which SQL statement returns names starting with "A"?

A. SELECT * FROM students WHERE name LIKE "A%" B. SELECT * FROM students WHERE name LIKE "%A" C. SELECT * FROM students WHERE name = "A%" D. SELECT * FROM students WHERE name = "%A%"

Q6: Which query finds all emails ending with "@gmail.com"?

A. SELECT * FROM users WHERE email LIKE "%@gmail.com" B. SELECT * FROM users WHERE email LIKE "gmail%" C. SELECT * FROM users WHERE email LIKE "%gmail%" D. SELECT * FROM users WHERE email = "@gmail.com%"

Q7: LIKE is case-sensitive in which databases by default?

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

Q8: What does this pattern match: "_at"?

A. "cat", "bat", "rat" B. "cat", "catalog", "bat" C. "rat", "rate", "ratty" D. "batman", "rattle", "hat"

Q9: Which of the following patterns finds names containing "son"?

A. %son% B. son% C. %son D. _son

Q10: Which clause uses LIKE correctly?

A. WHERE name LIKE "J_n%" B. WHERE name LIKE "J%_n" C. WHERE name LIKE "%J%"n D. WHERE LIKE name = "J_n%"

Q11: How do you find phone numbers starting with "98"?

A. SELECT * FROM contacts WHERE phone LIKE "98%" B. SELECT * FROM contacts WHERE phone LIKE "%98" C. SELECT * FROM contacts WHERE phone = "98%" D. SELECT * FROM contacts WHERE phone IN ("98%")

Q12: Can LIKE be used with numeric columns?

A. Yes, but they are converted to strings B. No, it’s only for VARCHAR C. Only in Oracle D. Only if indexed

Q13: Which query finds products that contain "box"?

A. SELECT * FROM products WHERE name LIKE "%box%" B. SELECT * FROM products WHERE name LIKE "box%" C. SELECT * FROM products WHERE name = "box%" D. SELECT * FROM products WHERE name == "box%"

Q14: To find values ending with "ing", use:

A. LIKE "%ing" B. LIKE "ing%" C. LIKE "ing" D. LIKE "%ing%"

Q15: LIKE with ESCAPE is used when pattern includes:

A. Literal % or _ characters B. Nulls C. Joins D. Subqueries

Q16: Which query finds 4-letter words ending in "at"?

A. LIKE "__at" B. LIKE "%at" C. LIKE "_at%" D. LIKE "___at"

Q17: Which is correct for pattern: 3-letter strings?

A. LIKE "___" B. LIKE "%_%" C. LIKE "_3_" D. LIKE "__%"

Q18: What does "%book%" match?

A. Any string containing "book" B. Only strings ending with book C. Only "book" D. Strings starting with "book"

Q19: LIKE is often used with which clause?

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

Q20: What is the result of LIKE "J%S"?

A. Matches strings starting with J and ending with S B. Matches strings containing J or S C. Matches only "JS" D. Matches strings not containing J or S

Q21: Which of the following is invalid in LIKE?

A. LIKE "%test" ORDER BY name B. LIKE "%test" C. LIKE "_test" D. LIKE "test%"