Test Your Microsoft SQL Server NOT LIKE Operator Knowledge with This Quiz

Progress

True / False

The NOT LIKE operator can be used to exclude patterns in a column.

True False

The NOT LIKE operator is used to exclude patterns defined with the LIKE operator in SQL queries.

True / False

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

True False

By default, the NOT LIKE operator in Microsoft SQL Server is case-insensitive unless a binary collation is used.

True / False

Using NOT LIKE '%a%' will exclude all rows where the column contains the letter 'a'.

True False

The pattern '%a%' matches any string containing the letter 'a'. Using NOT LIKE '%a%' excludes all rows where the column contains the letter 'a'.

True / False

The NOT LIKE operator can be used with wildcards such as '%' and '_'.

True False

The NOT LIKE operator can be used with wildcards like '%' to match any sequence of characters and '_' to match a single character.

True / False

NOT LIKE can be used in combination with other operators like AND and OR.

True False

The NOT LIKE operator can be combined with other logical operators like AND and OR to form more complex queries.

True / False

The NOT LIKE operator cannot be used with numeric columns.

True False

The NOT LIKE operator is generally used with string columns, but can be applied to numeric columns if they are cast to strings.

True / False

The NOT LIKE operator will include rows where the column is NULL.

True False

The NOT LIKE operator does not match NULL values. Rows where the column is NULL are not included in the result set.

True / False

Using NOT LIKE 'A%' will exclude rows starting with the letter 'A'.

True False

The pattern 'A%' matches any string starting with 'A'. Using NOT LIKE 'A%' excludes all rows where the column starts with 'A'.

True / False

The NOT LIKE operator is faster than the LIKE operator.

True False

Performance of NOT LIKE and LIKE operators depends on the context and data. There is no inherent speed advantage for NOT LIKE over LIKE.

Q10

True / False

Using NOT LIKE '%test%' will exclude all rows where the column contains 'test' anywhere in the string.

True False

The pattern '%test%' matches any string containing 'test' anywhere. Using NOT LIKE '%test%' excludes all rows where the column contains 'test' anywhere in the string.

Q11

True / False

The NOT LIKE operator can be used to exclude multiple patterns using the OR operator.

True False

The NOT LIKE operator can be combined with the OR operator to exclude multiple patterns in a single query.

Q12

True / False

Using NOT LIKE '_a%' will exclude rows where the second character is 'a'.

True False

The pattern '_a%' matches any string where the second character is 'a'. Using NOT LIKE '_a%' excludes all rows where the second character is 'a'.

Q13

True / False

NOT LIKE can be used in the WHERE clause of an UPDATE statement.

True False

The NOT LIKE operator can be used in the WHERE clause of an UPDATE statement to filter rows that should not be updated based on a pattern.

Q14

True / False

The NOT LIKE operator can be used with the ESCAPE keyword to exclude patterns with special characters.

True False

The NOT LIKE operator can be combined with the ESCAPE keyword to exclude patterns containing special characters like '%', '_', etc.

Q15

True / False

Using NOT LIKE '%%' will exclude all rows.

True False

The pattern '%%' matches any string of any length. Using NOT LIKE '%%' effectively excludes all rows.

Q16

Single Choice

Which query excludes all rows where the name contains 'John'?

SQL Code

SELECT Name
FROM Users
WHERE Name NOT LIKE '%John%';

SELECT Name FROM Users WHERE Name NOT LIKE '%John%'; SELECT Name FROM Users WHERE Name NOT LIKE 'John%'; SELECT Name FROM Users WHERE Name NOT LIKE '_John%';SELECT Name FROM Users WHERE Name NOT LIKE '%J%hn';

The pattern '%John%' matches any string containing 'John'. Using NOT LIKE '%John%' excludes all rows where the name contains 'John'.

Q17

Single Choice

How would you exclude all products starting with 'Pro'?

SQL Code

SELECT ProductName
FROM Products
WHERE ProductName NOT LIKE 'Pro%';

SELECT ProductName FROM Products WHERE ProductName NOT LIKE 'Pro%'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE '%Pro'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE '_Pro%';SELECT ProductName FROM Products WHERE ProductName NOT LIKE 'P%ro';

The pattern 'Pro%' matches any string starting with 'Pro'. Using NOT LIKE 'Pro%' excludes all rows where the product name starts with 'Pro'.

Q18

Single Choice

Which query excludes all email addresses containing 'gmail'?

SQL Code

SELECT Email
FROM Contacts
WHERE Email NOT LIKE '%gmail%';

SELECT Email FROM Contacts WHERE Email NOT LIKE '%gmail%'; SELECT Email FROM Contacts WHERE Email NOT LIKE 'gmail%'; SELECT Email FROM Contacts WHERE Email NOT LIKE '_gmail%';SELECT Email FROM Contacts WHERE Email NOT LIKE '%g%mail';

The pattern '%gmail%' matches any string containing 'gmail'. Using NOT LIKE '%gmail%' excludes all rows where the email contains 'gmail'.

Q19

Single Choice

How would you exclude all cities ending with 'ville'?

SQL Code

SELECT City
FROM Locations
WHERE City NOT LIKE '%ville';

SELECT City FROM Locations WHERE City NOT LIKE '%ville'; SELECT City FROM Locations WHERE City NOT LIKE 'ville%'; SELECT City FROM Locations WHERE City NOT LIKE '_ville%';SELECT City FROM Locations WHERE City NOT LIKE 'v%lle';

The pattern '%ville' matches any string ending with 'ville'. Using NOT LIKE '%ville' excludes all rows where the city ends with 'ville'.

Q20

Single Choice

Which query excludes all phone numbers starting with '123'?

SQL Code

SELECT PhoneNumber
FROM Directory
WHERE PhoneNumber NOT LIKE '123%';

SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '123%'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '%123'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '_123%';SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '1%23';

The pattern '123%' matches any string starting with '123'. Using NOT LIKE '123%' excludes all rows where the phone number starts with '123'.

Q21

Single Choice

How would you exclude all rows where the first name starts with 'A'?

SQL Code

SELECT FirstName
FROM Employees
WHERE FirstName NOT LIKE 'A%';

SELECT FirstName FROM Employees WHERE FirstName NOT LIKE 'A%'; SELECT FirstName FROM Employees WHERE FirstName NOT LIKE '%A'; SELECT FirstName FROM Employees WHERE FirstName NOT LIKE '_A%';SELECT FirstName FROM Employees WHERE FirstName NOT LIKE 'A_';

The pattern 'A%' matches any string starting with 'A'. Using NOT LIKE 'A%' excludes all rows where the first name starts with 'A'.

Q22

Single Choice

Which query excludes all last names containing 'Smith'?

SQL Code

SELECT LastName
FROM Employees
WHERE LastName NOT LIKE '%Smith%';

SELECT LastName FROM Employees WHERE LastName NOT LIKE '%Smith%'; SELECT LastName FROM Employees WHERE LastName NOT LIKE 'Smith%'; SELECT LastName FROM Employees WHERE LastName NOT LIKE '_Smith%';SELECT LastName FROM Employees WHERE LastName NOT LIKE '%S%ith';

The pattern '%Smith%' matches any string containing 'Smith'. Using NOT LIKE '%Smith%' excludes all rows where the last name contains 'Smith'.

Q23

Single Choice

How would you exclude all countries starting with 'A'?

SQL Code

SELECT CountryName
FROM Countries
WHERE CountryName NOT LIKE 'A%';

SELECT CountryName FROM Countries WHERE CountryName NOT LIKE 'A%'; SELECT CountryName FROM Countries WHERE CountryName NOT LIKE '%A'; SELECT CountryName FROM Countries WHERE CountryName NOT LIKE '_A%';SELECT CountryName FROM Countries WHERE CountryName NOT LIKE 'A_';

The pattern 'A%' matches any string starting with 'A'. Using NOT LIKE 'A%' excludes all rows where the country name starts with 'A'.

Q24

Single Choice

Which query excludes all book titles containing 'Guide'?

SQL Code

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

SELECT Title FROM Books WHERE Title NOT LIKE '%Guide%'; SELECT Title FROM Books WHERE Title NOT LIKE 'Guide%'; SELECT Title FROM Books WHERE Title NOT LIKE '_Guide%';SELECT Title FROM Books WHERE Title NOT LIKE '%G%ide';

The pattern '%Guide%' matches any string containing 'Guide'. Using NOT LIKE '%Guide%' excludes all rows where the book title contains 'Guide'.

Q25

Single Choice

How would you exclude all cities ending with 'ville'?

SQL Code

SELECT City
FROM Locations
WHERE City NOT LIKE '%ville';

The pattern '%ville' matches any string ending with 'ville'. Using NOT LIKE '%ville' excludes all rows where the city ends with 'ville'.

Q26

Single Choice

Which query excludes all email addresses containing 'yahoo'?

SQL Code

SELECT Email
FROM Contacts
WHERE Email NOT LIKE '%yahoo%';

SELECT Email FROM Contacts WHERE Email NOT LIKE '%yahoo%'; SELECT Email FROM Contacts WHERE Email NOT LIKE 'yahoo%'; SELECT Email FROM Contacts WHERE Email NOT LIKE '_yahoo%';SELECT Email FROM Contacts WHERE Email NOT LIKE '%y%hoo';

The pattern '%yahoo%' matches any string containing 'yahoo'. Using NOT LIKE '%yahoo%' excludes all rows where the email contains 'yahoo'.

Q27

Single Choice

How would you exclude all phone numbers ending with '789'?

SQL Code

SELECT PhoneNumber
FROM Directory
WHERE PhoneNumber NOT LIKE '%789';

SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '%789'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '789%'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '_789%';SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '%7%89';

The pattern '%789' matches any string ending with '789'. Using NOT LIKE '%789' excludes all rows where the phone number ends with '789'.

Q28

Single Choice

Which query excludes all product names containing 'Ultra'?

SQL Code

SELECT ProductName
FROM Products
WHERE ProductName NOT LIKE '%Ultra%';

SELECT ProductName FROM Products WHERE ProductName NOT LIKE '%Ultra%'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE 'Ultra%'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE '_Ultra%';SELECT ProductName FROM Products WHERE ProductName NOT LIKE '%U%ltra';

The pattern '%Ultra%' matches any string containing 'Ultra'. Using NOT LIKE '%Ultra%' excludes all rows where the product name contains 'Ultra'.

Q29

Single Choice

How would you exclude all usernames starting with 'admin'?

SQL Code

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

SELECT Username FROM Users WHERE Username NOT LIKE 'admin%'; SELECT Username FROM Users WHERE Username NOT LIKE '%admin'; SELECT Username FROM Users WHERE Username NOT LIKE '_admin%';SELECT Username FROM Users WHERE Username NOT LIKE 'a%min';

The pattern 'admin%' matches any string starting with 'admin'. Using NOT LIKE 'admin%' excludes all rows where the username starts with 'admin'.

Q30

Single Choice

Which query excludes all last names containing 'Doe'?

SQL Code

SELECT LastName
FROM Employees
WHERE LastName NOT LIKE '%Doe%';

SELECT LastName FROM Employees WHERE LastName NOT LIKE '%Doe%'; SELECT LastName FROM Employees WHERE LastName NOT LIKE 'Doe%'; SELECT LastName FROM Employees WHERE LastName NOT LIKE '_Doe%';SELECT LastName FROM Employees WHERE LastName NOT LIKE '%D%e';

The pattern '%Doe%' matches any string containing 'Doe'. Using NOT LIKE '%Doe%' excludes all rows where the last name contains 'Doe'.

Q31

Multiple Choice

Which of the following queries excludes all rows where the product name contains 'Test'?

SQL Code

SELECT ProductName
FROM Products
WHERE ProductName NOT LIKE '%Test%';

SELECT ProductName FROM Products WHERE ProductName NOT LIKE '%Test%'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE 'Test%'; SELECT ProductName FROM Products WHERE ProductName NOT LIKE '_Test%';SELECT ProductName FROM Products WHERE ProductName NOT LIKE '%T%est';

The pattern '%Test%' matches any string containing 'Test'. Using NOT LIKE '%Test%' excludes all rows where the product name contains 'Test'.

Q32

Multiple Choice

Which queries exclude all rows where the username starts with 'user'?

SQL Code

SELECT Username
FROM Users
WHERE Username NOT LIKE 'user%';

SELECT Username FROM Users WHERE Username NOT LIKE 'user%'; SELECT Username FROM Users WHERE Username NOT LIKE '%user'; SELECT Username FROM Users WHERE Username NOT LIKE '_user%';SELECT Username FROM Users WHERE Username NOT LIKE 'u%ser';

The pattern 'user%' matches any string starting with 'user'. Using NOT LIKE 'user%' excludes all rows where the username starts with 'user'.

Q33

Multiple Choice

Which queries exclude all rows where the email contains 'example'?

SQL Code

SELECT Email
FROM Contacts
WHERE Email NOT LIKE '%example%';

SELECT Email FROM Contacts WHERE Email NOT LIKE '%example%'; SELECT Email FROM Contacts WHERE Email NOT LIKE 'example%'; SELECT Email FROM Contacts WHERE Email NOT LIKE '_example%';SELECT Email FROM Contacts WHERE Email NOT LIKE '%e%ample';

The pattern '%example%' matches any string containing 'example'. Using NOT LIKE '%example%' excludes all rows where the email contains 'example'.

Q34

Multiple Choice

Which of the following queries excludes all rows where the phone number ends with '000'?

SQL Code

SELECT PhoneNumber
FROM Directory
WHERE PhoneNumber NOT LIKE '%000';

SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '%000'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '000%'; SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '_000%';SELECT PhoneNumber FROM Directory WHERE PhoneNumber NOT LIKE '%0%00';

The pattern '%000' matches any string ending with '000'. Using NOT LIKE '%000' excludes all rows where the phone number ends with '000'.

Q35

Multiple Choice

Which queries exclude all rows where the city name contains 'New'?

SQL Code

SELECT City
FROM Locations
WHERE City NOT LIKE '%New%';

SELECT City FROM Locations WHERE City NOT LIKE '%New%'; SELECT City FROM Locations WHERE City NOT LIKE 'New%'; SELECT City FROM Locations WHERE City NOT LIKE '_New%';SELECT City FROM Locations WHERE City NOT LIKE '%N%ew';

The pattern '%New%' matches any string containing 'New'. Using NOT LIKE '%New%' excludes all rows where the city name contains 'New'.

Q36

Multiple Choice

Which queries exclude all rows where the last name starts with 'M'?

SQL Code

SELECT LastName
FROM Employees
WHERE LastName NOT LIKE 'M%';

SELECT LastName FROM Employees WHERE LastName NOT LIKE 'M%'; SELECT LastName FROM Employees WHERE LastName NOT LIKE '%M'; SELECT LastName FROM Employees WHERE LastName NOT LIKE '_M%';SELECT LastName FROM Employees WHERE LastName NOT LIKE 'M_';

The pattern 'M%' matches any string starting with 'M'. Using NOT LIKE 'M%' excludes all rows where the last name starts with 'M'.

Q37

Multiple Choice

Which of the following queries excludes all rows where the company name contains 'Tech'?

SQL Code

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

SELECT CompanyName FROM Companies WHERE CompanyName NOT LIKE '%Tech%'; SELECT CompanyName FROM Companies WHERE CompanyName NOT LIKE 'Tech%'; SELECT CompanyName FROM Companies WHERE CompanyName NOT LIKE '_Tech%';SELECT CompanyName FROM Companies WHERE CompanyName NOT LIKE '%T%ch';

The pattern '%Tech%' matches any string containing 'Tech'. Using NOT LIKE '%Tech%' excludes all rows where the company name contains 'Tech'.

Q38

Multiple Choice

Which queries exclude all rows where the department name starts with 'Sales'?

SQL Code

SELECT DepartmentName
FROM Departments
WHERE DepartmentName NOT LIKE 'Sales%';

SELECT DepartmentName FROM Departments WHERE DepartmentName NOT LIKE 'Sales%'; SELECT DepartmentName FROM Departments WHERE DepartmentName NOT LIKE '%Sales'; SELECT DepartmentName FROM Departments WHERE DepartmentName NOT LIKE '_Sales%';SELECT DepartmentName FROM Departments WHERE DepartmentName NOT LIKE 'S%les';

The pattern 'Sales%' matches any string starting with 'Sales'. Using NOT LIKE 'Sales%' excludes all rows where the department name starts with 'Sales'.

Q39

Multiple Choice

Which queries exclude all rows where the order ID contains '123'?

SQL Code

SELECT OrderID
FROM Orders
WHERE OrderID NOT LIKE '%123%';

SELECT OrderID FROM Orders WHERE OrderID NOT LIKE '%123%'; SELECT OrderID FROM Orders WHERE OrderID NOT LIKE '123%'; SELECT OrderID FROM Orders WHERE OrderID NOT LIKE '_123%';SELECT OrderID FROM Orders WHERE OrderID NOT LIKE '%1%23';

The pattern '%123%' matches any string containing '123'. Using NOT LIKE '%123%' excludes all rows where the order ID contains '123'.

Q40

Multiple Choice

Which queries exclude all rows where the employee ID ends with '456'?

SQL Code

SELECT EmployeeID
FROM Employees
WHERE EmployeeID NOT LIKE '%456';

SELECT EmployeeID FROM Employees WHERE EmployeeID NOT LIKE '%456'; SELECT EmployeeID FROM Employees WHERE EmployeeID NOT LIKE '456%'; SELECT EmployeeID FROM Employees WHERE EmployeeID NOT LIKE '_456%';SELECT EmployeeID FROM Employees WHERE EmployeeID NOT LIKE '%4%56';

The pattern '%456' matches any string ending with '456'. Using NOT LIKE '%456' excludes all rows where the employee ID ends with '456'.

Q41

Multiple Choice

Which of the following queries excludes all rows where the first name contains 'John'?

SQL Code

SELECT FirstName
FROM Employees
WHERE FirstName NOT LIKE '%John%';

SELECT FirstName FROM Employees WHERE FirstName NOT LIKE '%John%'; SELECT FirstName FROM Employees WHERE FirstName NOT LIKE 'John%'; SELECT FirstName FROM Employees WHERE FirstName NOT LIKE '_John%';SELECT FirstName FROM Employees WHERE FirstName NOT LIKE '%J%ohn';

The pattern '%John%' matches any string containing 'John'. Using NOT LIKE '%John%' excludes all rows where the first name contains 'John'.

Q42

Multiple Choice

Which queries exclude all rows where the city name starts with 'San'?

SQL Code

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

SELECT City FROM Locations WHERE City NOT LIKE 'San%'; SELECT City FROM Locations WHERE City NOT LIKE '%San'; SELECT City FROM Locations WHERE City NOT LIKE '_San%';SELECT City FROM Locations WHERE City NOT LIKE 'S%an';

The pattern 'San%' matches any string starting with 'San'. Using NOT LIKE 'San%' excludes all rows where the city name starts with 'San'.

Q43

Multiple Choice

Which of the following queries excludes all rows where the email ends with 'domain.com'?

SQL Code

SELECT Email
FROM Contacts
WHERE Email NOT LIKE '%domain.com';

SELECT Email FROM Contacts WHERE Email NOT LIKE '%domain.com'; SELECT Email FROM Contacts WHERE Email NOT LIKE 'domain.com%'; SELECT Email FROM Contacts WHERE Email NOT LIKE '_domain.com%';SELECT Email FROM Contacts WHERE Email NOT LIKE '%d%omain.com';

The pattern '%domain.com' matches any string ending with 'domain.com'. Using NOT LIKE '%domain.com' excludes all rows where the email ends with 'domain.com'.

Q44

Multiple Choice

Which queries exclude all rows where the country name contains 'land'?

SQL Code

SELECT CountryName
FROM Countries
WHERE CountryName NOT LIKE '%land%';

SELECT CountryName FROM Countries WHERE CountryName NOT LIKE '%land%'; SELECT CountryName FROM Countries WHERE CountryName NOT LIKE 'land%'; SELECT CountryName FROM Countries WHERE CountryName NOT LIKE '_land%';SELECT CountryName FROM Countries WHERE CountryName NOT LIKE '%l%and';

The pattern '%land%' matches any string containing 'land'. Using NOT LIKE '%land%' excludes all rows where the country name contains 'land'.

Q45

Multiple Choice

Which of the following queries exclude all rows where the job title starts with 'Manager'?

SQL Code

SELECT JobTitle
FROM Jobs
WHERE JobTitle NOT LIKE 'Manager%';

SELECT JobTitle FROM Jobs WHERE JobTitle NOT LIKE 'Manager%'; SELECT JobTitle FROM Jobs WHERE JobTitle NOT LIKE '%Manager'; SELECT JobTitle FROM Jobs WHERE JobTitle NOT LIKE '_Manager%';SELECT JobTitle FROM Jobs WHERE JobTitle NOT LIKE 'M%anager';

The pattern 'Manager%' matches any string starting with 'Manager'. Using NOT LIKE 'Manager%' excludes all rows where the job title starts with 'Manager'.

Microsoft SQL Server Database Quiz Questions