Practice Like – Pattern Matching (12.2.6) - SQL for QA Analysts - Quality Analysis

Practice: LIKE – Pattern Matching

Lesson 12.2.6SQL for QA Analysts

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
Write a SQL query to find users with emails that end with '@yahoo.com'.
Show hintHide hint
Use the wildcard '%' before '@yahoo.com'.
Question 2.
How would you find all products that start with 'Electro'?
Show hintHide hint
Remember to use the wildcard '%' at the end.
3Question 3.
What does the LIKE operator do in SQL?
- A. Deletes records
- B. Searches for a specified pattern
- C. Updates records
Show hintHide hint
Think about what type of operation you perform with `LIKE`.
4Question 4.
True or False: The percent sign (%) in a LIKE clause can only appear at the end of the pattern.
- True
- False
Show hintHide hint
Consider how wildcards can be used in different placements.
Question 5.
You are tasked with writing a SQL query that catches all email addresses beginning with 'info' and ending with a domain, ensuring both conditions are met.
Show hintHide hint
Consider how to just capture valid domain emails.
Question 6.
Design a query to fetch all phone numbers that contain the digit '5' anywhere in them and end with '7'.
Show hintHide hint
Utilize the '%' wildcard effectively before '5' and place '7' at the end.

5 more questions in this section. Enroll free to practise them all.