SQL · Question 17 · Easy
In a LIKE pattern, which wildcard matches exactly one character?
- % (percent)
- _ (underscore)
- * (asterisk)
- ? (question mark)
Answer and explanation
Answer: B. _ (underscore)
Explanation: In SQL, _ matches exactly one character and % matches any sequence of zero or more characters. * and ? are file-system globbing wildcards, not standard LIKE wildcards.
Previous: Which keyword is written after SELECT to remove duplicate rows from a query's… · Next: If ORDER BY is used without ASC or DESC, in which order are the rows sorted?
Practise sql
Try a fresh set of sql questions with an explanation after every answer, free and without signing up: SQL practice. Or sit a full placement mock test.
More sql questions
- Table A has one column x with rows: 1, 1, 2, NULL Table B has one column x…
- Table A has one column x with rows: 1, 1, 2, NULL Table B has one column x…
- Which keyword is written after SELECT to remove duplicate rows from a query's…
- If ORDER BY is used without ASC or DESC, in which order are the rows sorted?
- Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…
- Which type of join returns all rows from both tables, matching rows where…
- Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…
- Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…
- Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…
- Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…
More technical & programming practice
Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming · Java
LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge