Test Your Microsoft SQL Server LIKE Operator Knowledge with This Quiz

Progress

True / False

The `LIKE` operator is used to search for a specified pattern in a column.

True False

The `LIKE` operator is indeed used to search for a specified pattern in a column using wildcard characters.

True / False

The `LIKE` operator can use the wildcard character `%` to represent zero or more characters.

True False

The `%` wildcard character in the `LIKE` operator matches zero or more characters.

True / False

The `LIKE` operator is case-insensitive by default in Microsoft SQL Server.

True False

In Microsoft SQL Server, the `LIKE` operator is case-insensitive by default.

True / False

The `_` wildcard character in the `LIKE` operator represents a single character.

True False

The `_` wildcard character in the `LIKE` operator matches a single character.

True / False

You can use the `LIKE` operator to search for a pattern at the beginning of a string only.

False True

The `LIKE` operator can be used to search for patterns at the beginning, middle, or end of a string.

True / False

The `LIKE` operator can be used in combination with the `NOT` keyword to find rows that do not match a pattern.

True False

The `LIKE` operator can indeed be used with the `NOT` keyword to exclude rows that match a pattern.

True / False

The `LIKE` operator can use both `%` and `_` wildcards in the same pattern.

True False

Both `%` and `_` wildcards can be used together in the same pattern with the `LIKE` operator.

True / False

The `LIKE` operator can be used with numeric columns to search for patterns.

False True

The `LIKE` operator is generally used with string columns, not numeric columns.

True / False

Using `LIKE 'A%'` will match any string that starts with the letter 'A'.

True False

The pattern `LIKE 'A%'` matches any string that starts with 'A' followed by zero or more characters.

Q10

True / False

The `LIKE` operator can be used to match patterns that contain special characters.

True False

The `LIKE` operator can indeed match patterns that include special characters by using appropriate wildcards.

Q11

True / False

The `LIKE` operator is the best choice for exact matches in SQL Server.

False True

The `LIKE` operator is typically used for pattern matching, not exact matches.

Q12

True / False

Using `LIKE '%Smith'` will find all records that end with 'Smith'.

True False

The pattern `LIKE '%Smith'` matches any string that ends with 'Smith'.

Q13

True / False

The `LIKE` operator is case-sensitive in Microsoft SQL Server by default.

False True

The `LIKE` operator is case-insensitive by default in Microsoft SQL Server.

Q14

True / False

Using `LIKE 'John_'` will find all records that start with 'John' followed by one more character.

True False

The pattern `LIKE 'John_'` matches any string that starts with 'John' followed by exactly one more character.

Q15

True / False

The `LIKE` operator can be used with a combination of wildcards and specific characters.

True False

The `LIKE` operator can use both wildcards and specific characters in the same pattern to perform complex searches.

Q16

Single Choice

Which query would you use to find all names that start with 'A'?

SQL Code

SELECT *
FROM Employees
WHERE Name LIKE 'A%';

SELECT * FROM Employees WHERE Name LIKE 'A%'; SELECT * FROM Employees WHERE Name LIKE '%A'; SELECT * FROM Employees WHERE Name = 'A';SELECT * FROM Employees WHERE Name LIKE 'A_';

The `LIKE 'A%'` pattern matches any name that starts with 'A'.

Q17

Single Choice

How would you find all customers whose name contains 'John'?

SQL Code

SELECT CustomerID, CustomerName
FROM Customers
WHERE CustomerName LIKE '%John%';

SELECT CustomerID, CustomerName FROM Customers WHERE CustomerName LIKE '%John%'; SELECT CustomerID, CustomerName FROM Customers WHERE CustomerName LIKE 'John%'; SELECT CustomerID, CustomerName FROM Customers WHERE CustomerName LIKE '%John';SELECT CustomerID, CustomerName FROM Customers WHERE CustomerName LIKE 'John_';

The `LIKE '%John%'` pattern matches any name that contains 'John'.

Q18

Single Choice

Which query finds all products that end with 'X'?

SQL Code

SELECT ProductID, ProductName
FROM Products
WHERE ProductName LIKE '%X';

SELECT ProductID, ProductName FROM Products WHERE ProductName LIKE '%X'; SELECT ProductID, ProductName FROM Products WHERE ProductName LIKE 'X%'; SELECT ProductID, ProductName FROM Products WHERE ProductName LIKE 'X_';SELECT ProductID, ProductName FROM Products WHERE ProductName LIKE '%X%';

The `LIKE '%X'` pattern matches any product name that ends with 'X'.

Q19

Single Choice

How would you find all records where the City starts with 'New'?

SQL Code

SELECT City, Country
FROM Locations
WHERE City LIKE 'New%';

SELECT City, Country FROM Locations WHERE City LIKE 'New%'; SELECT City, Country FROM Locations WHERE City LIKE '%New'; SELECT City, Country FROM Locations WHERE City LIKE '_New%';SELECT City, Country FROM Locations WHERE City = 'New';

The `LIKE 'New%'` pattern matches any city name that starts with 'New'.

Q20

Single Choice

Which query finds all email addresses that contain 'gmail'?

SQL Code

SELECT Email
FROM Users
WHERE Email LIKE '%gmail%';

SELECT Email FROM Users WHERE Email LIKE '%gmail%'; SELECT Email FROM Users WHERE Email LIKE 'gmail%'; SELECT Email FROM Users WHERE Email LIKE '%gmail';SELECT Email FROM Users WHERE Email LIKE 'gmail_';

The `LIKE '%gmail%'` pattern matches any email address that contains 'gmail'.

Q21

Single Choice

Which query would find all orders placed in February?

SQL Code

SELECT OrderID, OrderDate
FROM Orders
WHERE OrderDate LIKE '2024-02-%';

SELECT OrderID, OrderDate FROM Orders WHERE OrderDate LIKE '2024-02-%'; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate LIKE '02-2024-%'; SELECT OrderID, OrderDate FROM Orders WHERE OrderDate LIKE '%2024-02';SELECT OrderID, OrderDate FROM Orders WHERE OrderDate LIKE '2024%02%';

The `LIKE '2024-02-%'` pattern matches any date in February 2024.

Q22

Single Choice

How would you find all usernames that start with 'admin'?

SQL Code

SELECT Username
FROM Users
WHERE Username LIKE 'admin%';

SELECT Username FROM Users WHERE Username LIKE 'admin%'; SELECT Username FROM Users WHERE Username LIKE '%admin'; SELECT Username FROM Users WHERE Username LIKE '_admin%';SELECT Username FROM Users WHERE Username = 'admin';

The `LIKE 'admin%'` pattern matches any username that starts with 'admin'.

Q23

Single Choice

Which query would find all comments that contain 'error'?

SQL Code

SELECT Comment
FROM Feedback
WHERE Comment LIKE '%error%';

SELECT Comment FROM Feedback WHERE Comment LIKE '%error%'; SELECT Comment FROM Feedback WHERE Comment LIKE 'error%'; SELECT Comment FROM Feedback WHERE Comment LIKE '%error';SELECT Comment FROM Feedback WHERE Comment LIKE 'error_';

The `LIKE '%error%'` pattern matches any comment that contains the word 'error'.

Q24

Single Choice

How would you find all phone numbers that end with '1234'?

SQL Code

SELECT PhoneNumber
FROM Contacts
WHERE PhoneNumber LIKE '%1234';

SELECT PhoneNumber FROM Contacts WHERE PhoneNumber LIKE '%1234'; SELECT PhoneNumber FROM Contacts WHERE PhoneNumber LIKE '1234%'; SELECT PhoneNumber FROM Contacts WHERE PhoneNumber LIKE '_1234';SELECT PhoneNumber FROM Contacts WHERE PhoneNumber LIKE '1234_';

The `LIKE '%1234'` pattern matches any phone number that ends with '1234'.

Q25

Single Choice

Which query finds all addresses that contain the word 'Street'?

SQL Code

SELECT Address
FROM Locations
WHERE Address LIKE '%Street%';

SELECT Address FROM Locations WHERE Address LIKE '%Street%'; SELECT Address FROM Locations WHERE Address LIKE 'Street%'; SELECT Address FROM Locations WHERE Address LIKE '%Street';SELECT Address FROM Locations WHERE Address LIKE 'Street_';

The `LIKE '%Street%'` pattern matches any address that contains the word 'Street'.

Q26

Single Choice

How would you find all product codes that start with 'AB'?

SQL Code

SELECT ProductCode
FROM Products
WHERE ProductCode LIKE 'AB%';

SELECT ProductCode FROM Products WHERE ProductCode LIKE 'AB%'; SELECT ProductCode FROM Products WHERE ProductCode LIKE '%AB'; SELECT ProductCode FROM Products WHERE ProductCode LIKE '_AB%';SELECT ProductCode FROM Products WHERE ProductCode LIKE 'AB_';

The `LIKE 'AB%'` pattern matches any product code that starts with 'AB'.

Q27

Single Choice

Which query finds all email addresses that end with 'yahoo.com'?

SQL Code

SELECT Email
FROM Users
WHERE Email LIKE '%@yahoo.com';

SELECT Email FROM Users WHERE Email LIKE '%@yahoo.com'; SELECT Email FROM Users WHERE Email LIKE 'yahoo.com%'; SELECT Email FROM Users WHERE Email LIKE '%yahoo.com';SELECT Email FROM Users WHERE Email LIKE 'yahoo.com_';

The `LIKE '%@yahoo.com'` pattern matches any email address that ends with 'yahoo.com'.

Q28

Single Choice

How would you find all records where the Company name contains 'Tech'?

SQL Code

SELECT CompanyName
FROM Companies
WHERE CompanyName LIKE '%Tech%';

SELECT CompanyName FROM Companies WHERE CompanyName LIKE '%Tech%'; SELECT CompanyName FROM Companies WHERE CompanyName LIKE 'Tech%'; SELECT CompanyName FROM Companies WHERE CompanyName LIKE '%Tech';SELECT CompanyName FROM Companies WHERE CompanyName LIKE 'Tech_';

The `LIKE '%Tech%'` pattern matches any company name that contains the word 'Tech'.

Q29

Single Choice

Which query would find all last names that start with 'S' and end with 'n'?

SQL Code

SELECT LastName
FROM Employees
WHERE LastName LIKE 'S%n';

SELECT LastName FROM Employees WHERE LastName LIKE 'S%n'; SELECT LastName FROM Employees WHERE LastName LIKE 'S_n'; SELECT LastName FROM Employees WHERE LastName LIKE 'S%_n';SELECT LastName FROM Employees WHERE LastName LIKE 'S%';

The `LIKE 'S%n'` pattern matches any last name that starts with 'S' and ends with 'n'.

Q30

Single Choice

How would you find all records where the state starts with 'CA'?

SQL Code

SELECT State
FROM Locations
WHERE State LIKE 'CA%';

SELECT State FROM Locations WHERE State LIKE 'CA%'; SELECT State FROM Locations WHERE State LIKE '%CA'; SELECT State FROM Locations WHERE State LIKE '_CA%';SELECT State FROM Locations WHERE State LIKE 'CA_';

The `LIKE 'CA%'` pattern matches any state code that starts with 'CA'.

Q31

Multiple Choice

Which queries find all first names that contain 'Ann'?

SQL Code

SELECT FirstName
FROM People
WHERE FirstName LIKE '%Ann%';

SELECT FirstName FROM People WHERE FirstName LIKE '%Ann%'; SELECT FirstName FROM People WHERE FirstName LIKE 'Ann%'; SELECT FirstName FROM People WHERE FirstName LIKE '%Ann';SELECT FirstName FROM People WHERE FirstName LIKE '_Ann%';

The `LIKE '%Ann%'` pattern matches any first name that contains 'Ann'.

Q32

Multiple Choice

Which queries find all usernames that end with '123'?

SQL Code

SELECT Username
FROM Accounts
WHERE Username LIKE '%123';

SELECT Username FROM Accounts WHERE Username LIKE '%123'; SELECT Username FROM Accounts WHERE Username LIKE '123%'; SELECT Username FROM Accounts WHERE Username LIKE '_123';SELECT Username FROM Accounts WHERE Username LIKE '%_123';

The `LIKE '%123'` pattern matches any username that ends with '123'.

Q33

Multiple Choice

How would you find all email addresses that contain 'example'?

SQL Code

SELECT Email
FROM Users
WHERE Email LIKE '%example%';

SELECT Email FROM Users WHERE Email LIKE '%example%'; SELECT Email FROM Users WHERE Email LIKE 'example%'; SELECT Email FROM Users WHERE Email LIKE '%example';SELECT Email FROM Users WHERE Email LIKE '_example%';

The `LIKE '%example%'` pattern matches any email address that contains 'example'.

Q34

Multiple Choice

Which queries find all product names that start with 'Pro'?

SQL Code

SELECT ProductName
FROM Inventory
WHERE ProductName LIKE 'Pro%';

SELECT ProductName FROM Inventory WHERE ProductName LIKE 'Pro%'; SELECT ProductName FROM Inventory WHERE ProductName LIKE '%Pro'; SELECT ProductName FROM Inventory WHERE ProductName LIKE '_Pro%';SELECT ProductName FROM Inventory WHERE ProductName LIKE 'Pro_';

The `LIKE 'Pro%'` pattern matches any product name that starts with 'Pro'.

Q35

Multiple Choice

How would you find all comments that contain 'urgent'?

SQL Code

SELECT Comment
FROM Notes
WHERE Comment LIKE '%urgent%';

SELECT Comment FROM Notes WHERE Comment LIKE '%urgent%'; SELECT Comment FROM Notes WHERE Comment LIKE 'urgent%'; SELECT Comment FROM Notes WHERE Comment LIKE '%urgent';SELECT Comment FROM Notes WHERE Comment LIKE '_urgent%';

The `LIKE '%urgent%'` pattern matches any comment that contains the word 'urgent'.

Q36

Multiple Choice

Which queries find all order numbers that start with 'ORD'?

SQL Code

SELECT OrderNumber
FROM Orders
WHERE OrderNumber LIKE 'ORD%';

SELECT OrderNumber FROM Orders WHERE OrderNumber LIKE 'ORD%'; SELECT OrderNumber FROM Orders WHERE OrderNumber LIKE '%ORD'; SELECT OrderNumber FROM Orders WHERE OrderNumber LIKE '_ORD%';SELECT OrderNumber FROM Orders WHERE OrderNumber LIKE 'ORD_';

The `LIKE 'ORD%'` pattern matches any order number that starts with 'ORD'.

Q37

Multiple Choice

How would you find all records where the country name contains 'United'?

SQL Code

SELECT Country
FROM Locations
WHERE Country LIKE '%United%';

SELECT Country FROM Locations WHERE Country LIKE '%United%'; SELECT Country FROM Locations WHERE Country LIKE 'United%'; SELECT Country FROM Locations WHERE Country LIKE '%United';SELECT Country FROM Locations WHERE Country LIKE '_United%';

The `LIKE '%United%'` pattern matches any country name that contains the word 'United'.

Q38

Multiple Choice

Which queries find all department names that end with 'Dept'?

SQL Code

SELECT DepartmentName
FROM Departments
WHERE DepartmentName LIKE '%Dept';

SELECT DepartmentName FROM Departments WHERE DepartmentName LIKE '%Dept'; SELECT DepartmentName FROM Departments WHERE DepartmentName LIKE 'Dept%'; SELECT DepartmentName FROM Departments WHERE DepartmentName LIKE '_Dept';SELECT DepartmentName FROM Departments WHERE DepartmentName LIKE '%Dept%';

The `LIKE '%Dept'` pattern matches any department name that ends with 'Dept'.

Q39

Multiple Choice

How would you find all student IDs that start with 'S' and end with '5'?

SQL Code

SELECT StudentID
FROM Students
WHERE StudentID LIKE 'S%5';

SELECT StudentID FROM Students WHERE StudentID LIKE 'S%5'; SELECT StudentID FROM Students WHERE StudentID LIKE 'S5%'; SELECT StudentID FROM Students WHERE StudentID LIKE '_S%5';SELECT StudentID FROM Students WHERE StudentID LIKE 'S%';

The `LIKE 'S%5'` pattern matches any student ID that starts with 'S' and ends with '5'.

Q40

Multiple Choice

Which queries find all book titles that contain the word 'Guide'?

SQL Code

SELECT Title
FROM Books
WHERE Title LIKE '%Guide%';

SELECT Title FROM Books WHERE Title LIKE '%Guide%'; SELECT Title FROM Books WHERE Title LIKE 'Guide%'; SELECT Title FROM Books WHERE Title LIKE '%Guide';SELECT Title FROM Books WHERE Title LIKE '_Guide%';

The `LIKE '%Guide%'` pattern matches any book title that contains the word 'Guide'.

Q41

Multiple Choice

How would you find all records where the first name ends with 'n'?

SQL Code

SELECT FirstName
FROM Contacts
WHERE FirstName LIKE '%n';

SELECT FirstName FROM Contacts WHERE FirstName LIKE '%n'; SELECT FirstName FROM Contacts WHERE FirstName LIKE 'n%'; SELECT FirstName FROM Contacts WHERE FirstName LIKE '_n%';SELECT FirstName FROM Contacts WHERE FirstName LIKE '%_n';

The `LIKE '%n'` pattern matches any first name that ends with 'n'.

Q42

Multiple Choice

Which queries find all cities that start with 'San'?

SQL Code

SELECT City
FROM Locations
WHERE City LIKE 'San%';

SELECT City FROM Locations WHERE City LIKE 'San%'; SELECT City FROM Locations WHERE City LIKE '%San'; SELECT City FROM Locations WHERE City LIKE '_San%';SELECT City FROM Locations WHERE City LIKE 'San_';

The `LIKE 'San%'` pattern matches any city name that starts with 'San'.

Q43

Multiple Choice

How would you find all employees where the last name contains 'son'?

SQL Code

SELECT LastName
FROM Employees
WHERE LastName LIKE '%son%';

SELECT LastName FROM Employees WHERE LastName LIKE '%son%'; SELECT LastName FROM Employees WHERE LastName LIKE 'son%'; SELECT LastName FROM Employees WHERE LastName LIKE '%son';SELECT LastName FROM Employees WHERE LastName LIKE '_son%';

The `LIKE '%son%'` pattern matches any last name that contains the substring 'son'.

Q44

Multiple Choice

Which queries find all countries where the name starts with 'Can'?

SQL Code

SELECT CountryName
FROM Countries
WHERE CountryName LIKE 'Can%';

SELECT CountryName FROM Countries WHERE CountryName LIKE 'Can%'; SELECT CountryName FROM Countries WHERE CountryName LIKE '%Can'; SELECT CountryName FROM Countries WHERE CountryName LIKE '_Can%';SELECT CountryName FROM Countries WHERE CountryName LIKE 'Can_';

The `LIKE 'Can%'` pattern matches any country name that starts with 'Can'.

Q45

Multiple Choice

How would you find all phone numbers that contain '555'?

SQL Code

SELECT PhoneNumber
FROM Directory
WHERE PhoneNumber LIKE '%555%';

SELECT PhoneNumber FROM Directory WHERE PhoneNumber LIKE '%555%'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber LIKE '555%'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber LIKE '%555';SELECT PhoneNumber FROM Directory WHERE PhoneNumber LIKE '_555%';

The `LIKE '%555%'` pattern matches any phone number that contains '555'.

Microsoft SQL Server Database Quiz Questions