Test Your PostgreSQL NOT LIKE Operator Knowledge with This Quiz

Progress

True / False

In PostgreSQL, the NOT LIKE operator is used to check if a text value does not match a specified pattern.

True False

The NOT LIKE operator returns TRUE if the text value does not match the pattern specified.

True / False

In PostgreSQL, the % wildcard can be used with NOT LIKE to represent any sequence of characters.

True False

The % wildcard can be used in NOT LIKE patterns to represent any sequence of characters, just as it does with the LIKE operator.

True / False

In PostgreSQL, the _ wildcard can be used with NOT LIKE to represent exactly one character.

True False

The _ wildcard can be used in NOT LIKE patterns to represent exactly one character.

True / False

In PostgreSQL, the NOT LIKE operator is case-insensitive by default.

True False

The NOT LIKE operator is case-sensitive by default. To perform a case-insensitive match, use NOT ILIKE.

True / False

In PostgreSQL, the expression column NOT LIKE 'a%' will match any string that does not start with the letter 'a'.

True False

The pattern a% matches any string that starts with 'a'. Therefore, NOT LIKE 'a%' matches any string that does not start with 'a'.

True / False

In PostgreSQL, the NOT LIKE operator can be used in WHERE clauses to filter out rows where a column matches a specified pattern.

True False

The NOT LIKE operator can be used in WHERE clauses to exclude rows that match the specified pattern.

True / False

In PostgreSQL, using NOT LIKE with an indexed column will always result in efficient query performance.

True False

While indexes can improve query performance, using NOT LIKE may not always leverage indexes effectively, especially if the pattern starts with a wildcard.

True / False

In PostgreSQL, the expression column NOT LIKE '%value%' can be used to exclude rows where the column contains the substring 'value'.

True False

The pattern %value% matches any string containing 'value'. Therefore, NOT LIKE '%value%' excludes rows where the column contains the substring 'value'.

True / False

In PostgreSQL, combining NOT LIKE with AND and OR operators allows for complex filtering conditions.

True False

The NOT LIKE operator can be combined with AND and OR to create complex logical conditions for filtering data.

Q10

True / False

In PostgreSQL, the NOT LIKE operator can be used in combination with escape characters to exclude patterns containing literal % or _ characters.

True False

PostgreSQL allows the use of escape characters in NOT LIKE patterns to exclude strings containing literal % or _ characters by specifying an escape character (e.g., NOT LIKE 'a\%%' ESCAPE '\' to exclude a%).

Q11

Single Choice

Which of the following queries will return rows where the name column does not start with 'A' in PostgreSQL?

SQL Code

SELECT name
FROM employees
WHERE name NOT LIKE 'A%';

WHERE name NOT LIKE 'A%' WHERE name NOT LIKE '%A' WHERE name NOT LIKE '%A%'WHERE name NOT LIKE '_A%'

The NOT LIKE 'A%' pattern excludes rows where the name starts with 'A'.

Q12

Single Choice

In PostgreSQL, how do you exclude rows where the email column contains '.com'?

SQL Code

SELECT email
FROM users
WHERE email NOT LIKE '%.com';

WHERE email NOT LIKE '%.com' WHERE email NOT LIKE '_%.com WHERE email NOT LIKE '%comWHERE email NOT LIKE '%_.com%

The NOT LIKE '%.com' pattern excludes rows where the email ends with '.com'.

Q13

Single Choice

What will be the result of the following query in PostgreSQL?

SQL Code

SELECT *
FROM products
WHERE product_code NOT LIKE '123%';

Rows with product_code starting with '123' Rows with product_code not starting with '123' Rows with product_code ending with '123'All rows where product_code is '123'

The query returns rows where the product_code does not start with '123'.

Q14

Single Choice

How would you filter out rows where the address column does not include 'Street' anywhere in PostgreSQL?

SQL Code

SELECT address
FROM locations
WHERE address NOT LIKE '%Street%';

WHERE address NOT LIKE '%Street' WHERE address NOT LIKE '%Street%' WHERE address NOT LIKE 'Street%'WHERE address NOT LIKE '%Street_

The NOT LIKE '%Street%' pattern excludes rows where the word 'Street' appears anywhere in the address.

Q15

Single Choice

Which of the following queries will exclude rows where description does not end with 'good' in PostgreSQL?

SQL Code

SELECT description
FROM reviews
WHERE description NOT LIKE '%good';

WHERE description NOT LIKE 'good%' WHERE description NOT LIKE '%good' WHERE description NOT LIKE '%good%'WHERE description NOT LIKE '_good%'

The NOT LIKE '%good' pattern excludes rows where the description ends with 'good'.

Q16

Single Choice

What does the following PostgreSQL query do?

SQL Code

SELECT *
FROM orders
WHERE order_id NOT LIKE 'ORD%';

Includes rows with order_id starting with 'ORD' Excludes rows with order_id starting with 'ORD' Includes rows with order_id ending with 'ORD'Excludes rows with order_id ending with 'ORD'

The query excludes rows where the order_id starts with 'ORD'.

Q17

Single Choice

How do you exclude rows in PostgreSQL where the username column does not have an underscore followed by 'admin'?

SQL Code

SELECT username
FROM accounts
WHERE username NOT LIKE '%_admin';

WHERE username NOT LIKE '_admin' WHERE username NOT LIKE '%_admin' WHERE username NOT LIKE '%admin'WHERE username NOT LIKE '%admin_'

The NOT LIKE '%_admin' pattern excludes rows where the username contains an underscore followed by 'admin'.

Q18

Single Choice

Which query would exclude rows where file_name does not have an extension in PostgreSQL?

SQL Code

SELECT file_name
FROM documents
WHERE file_name NOT LIKE '%.%';

WHERE file_name NOT LIKE '%.' WHERE file_name NOT LIKE '%.%' WHERE file_name NOT LIKE '_%.%'WHERE file_name NOT LIKE '%.%_'

The NOT LIKE '%.%' pattern excludes rows where the file_name contains a dot, which typically represents an extension.

Q19

Single Choice

In PostgreSQL, how do you filter out rows where the serial_number does not follow the pattern 'SN-' followed by exactly 5 digits?

SQL Code

SELECT serial_number
FROM devices
WHERE serial_number NOT LIKE 'SN-_____';

WHERE serial_number NOT LIKE 'SN-___' WHERE serial_number NOT LIKE 'SN-_____' WHERE serial_number NOT LIKE 'SN-______'WHERE serial_number NOT LIKE 'SN-__'

The NOT LIKE 'SN-_____' pattern excludes rows where the serial_number does not follow the 'SN-' followed by exactly 5 characters pattern.

Q20

Single Choice

Consider the following PostgreSQL query:

SQL Code

SELECT *
FROM transactions
WHERE transaction_code NOT LIKE 'TR_%'
 AND transaction_code NOT LIKE 'INV_%';
What does this query do?

Includes rows where transaction_code starts with 'TR_' or 'INV_' Excludes rows where transaction_code starts with 'TR_' or 'INV_' Includes rows where transaction_code does not start with 'TR_' or 'INV_'Excludes rows where transaction_code does not start with 'TR_' or 'INV_'

The query excludes rows where the transaction_code starts with 'TR_' or 'INV_'.

Q21

Multiple Choice

Identify the SQL scripts that correctly use the NOT LIKE operator to exclude specific patterns in PostgreSQL.

SELECT * FROM employees WHERE first_name NOT LIKE 'A%'; SELECT * FROM employees WHERE first_name NOT LIKE '%A'; SELECT * FROM employees WHERE first_name NOT LIKE 'A__';SELECT * FROM employees WHERE first_name NOT LIKE 'A%_%';

The NOT LIKE operator is used to exclude patterns. The correct scripts will demonstrate how to use NOT LIKE to filter out rows that match a specific pattern.

Q22

Multiple Choice

Select the SQL scripts that correctly use the NOT LIKE operator with numeric values stored as text in PostgreSQL.

SELECT * FROM orders WHERE order_number NOT LIKE '%3%'; SELECT * FROM orders WHERE order_number NOT LIKE '3%'; SELECT * FROM orders WHERE order_number NOT LIKE '%3';SELECT * FROM orders WHERE order_number NOT LIKE '3';

The NOT LIKE operator can be used with numeric values stored as text to exclude certain digits. The correct scripts will demonstrate how to use this operator to filter out numbers with specific digits.

Q23

Multiple Choice

Determine the SQL scripts that correctly use the NOT LIKE operator with a pattern at the end of the string in PostgreSQL.

SELECT * FROM products WHERE product_name NOT LIKE '%X'; SELECT * FROM products WHERE product_name NOT LIKE 'X%'; SELECT * FROM products WHERE product_name NOT LIKE '_X%';SELECT * FROM products WHERE product_name NOT LIKE '%X%';

The NOT LIKE operator is used to exclude patterns at the end of a string. The correct scripts will demonstrate how to use NOT LIKE to filter out rows based on such patterns.

Q24

Multiple Choice

Identify the SQL scripts that correctly use the NOT LIKE operator with special characters in PostgreSQL.

SELECT * FROM users WHERE username NOT LIKE '%_%'; SELECT * FROM users WHERE username NOT LIKE '%\_%' ESCAPE '\'; SELECT * FROM users WHERE username NOT LIKE '_%';SELECT * FROM users WHERE username NOT LIKE '%%_';

The NOT LIKE operator can be used with special characters by using the appropriate escape sequences. The correct scripts will demonstrate how to filter out rows with specific special characters.

Q25

Multiple Choice

Determine the SQL scripts that correctly use the NOT LIKE operator to exclude specific patterns in email addresses in PostgreSQL.

SELECT * FROM users WHERE email NOT LIKE '%@example.com'; SELECT * FROM users WHERE email NOT LIKE '%example.com%'; SELECT * FROM users WHERE email NOT LIKE 'example.com%';SELECT * FROM users WHERE email NOT LIKE '%example%com';

The NOT LIKE operator can be used to exclude specific domains in email addresses. The correct scripts will demonstrate how to filter out emails containing a specific domain.

Q26

Multiple Choice

Identify the SQL scripts that correctly use the NOT LIKE operator with JOINs in PostgreSQL.

SELECT * FROM customers c JOIN orders o ON c.customer_id = o.customer_id WHERE o.order_number NOT LIKE 'Z%'; SELECT * FROM customers c JOIN orders o ON c.customer_id = o.customer_id WHERE o.order_number NOT LIKE '_Z%'; SELECT * FROM customers c WHERE order_number NOT LIKE 'Z%';SELECT * FROM customers c WHERE NOT EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.customer_id AND o.order_number LIKE 'Z%');

The NOT LIKE operator can be used with JOINs to filter rows based on patterns in related tables. The correct scripts will demonstrate how to use NOT LIKE with JOINs.

Q27

Multiple Choice

Determine the SQL scripts that correctly use the NOT LIKE operator with subqueries in PostgreSQL.

SELECT * FROM invoices WHERE invoice_number NOT LIKE (SELECT pattern FROM patterns WHERE id = 1); SELECT * FROM invoices WHERE invoice_number NOT LIKE ALL (SELECT pattern FROM patterns WHERE id = 1); SELECT * FROM invoices WHERE invoice_number NOT LIKE ANY (SELECT pattern FROM patterns WHERE id = 1);SELECT * FROM invoices WHERE invoice_number = (SELECT pattern FROM patterns WHERE id = 1);

The NOT LIKE operator can be used with subqueries to exclude values matching patterns retrieved dynamically. The correct scripts will demonstrate how to use NOT LIKE with subqueries.

Q28

Multiple Choice

Identify the SQL scripts that correctly use the NOT LIKE operator with multiple conditions in PostgreSQL.

SELECT * FROM products WHERE product_name NOT LIKE 'A%' AND product_name NOT LIKE '%Z'; SELECT * FROM products WHERE product_name NOT LIKE 'A%' OR product_name NOT LIKE '%Z'; SELECT * FROM products WHERE product_name NOT LIKE '%A%' AND product_name NOT LIKE 'Z%';SELECT * FROM products WHERE product_name LIKE 'A%' AND product_name LIKE '%Z';

The NOT LIKE operator can be combined with AND to filter rows that do not match multiple patterns. The correct scripts will demonstrate how to use NOT LIKE with multiple conditions.

Q29

Multiple Choice

Determine the SQL scripts that correctly use the NOT LIKE operator to exclude patterns with special characters in PostgreSQL.

SELECT * FROM users WHERE username NOT LIKE '%-%'; SELECT * FROM users WHERE username NOT LIKE '%\-%' ESCAPE '\'; SELECT * FROM users WHERE username NOT LIKE '%_-%';SELECT * FROM users WHERE username NOT LIKE '-%';

The NOT LIKE operator can be used to exclude patterns with special characters, but care must be taken to escape the characters correctly. The correct scripts will demonstrate this usage.

Q30

Multiple Choice

Identify the SQL scripts that correctly use the NOT LIKE operator to filter rows based on case sensitivity in PostgreSQL.

SELECT * FROM entries WHERE entry_text NOT LIKE 'Test%'; SELECT * FROM entries WHERE LOWER(entry_text) NOT LIKE 'test%'; SELECT * FROM entries WHERE UPPER(entry_text) NOT LIKE 'TEST%';SELECT * FROM entries WHERE entry_text NOT LIKE '%test%';

The NOT LIKE operator can be used to filter rows based on case-sensitive patterns. The correct scripts will demonstrate how to filter rows regardless of case.

PostgreSQL Database Quiz Questions