Test Your PostgreSQL LIKE Operator Knowledge with This Quiz

Progress

True / False

In PostgreSQL, the LIKE operator is used to match text values against a pattern using wildcard characters.

True False

The LIKE operator in PostgreSQL is used to match a text value against a specified pattern using % and _ as wildcard characters.

True / False

In PostgreSQL, the % wildcard in the LIKE operator matches any sequence of characters.

True False

The % wildcard matches zero or more characters in PostgreSQL.

True / False

In PostgreSQL, the _ wildcard in the LIKE operator matches exactly one character.

True False

The _ wildcard matches exactly one character in PostgreSQL.

True / False

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

True False

The LIKE operator is case-sensitive by default in PostgreSQL, meaning LIKE 'a%' will not match A.

True / False

In PostgreSQL, the ILIKE operator can be used for case-insensitive pattern matching.

True False

The ILIKE operator performs case-insensitive pattern matching, making it useful when the case of characters should be ignored.

True / False

In PostgreSQL, the expression column LIKE 'a%' will match any string that starts with the letter 'a'.

True False

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

True / False

In PostgreSQL, using LIKE with an index can improve query performance for text pattern matching.

True False

While PostgreSQL can use indexes with LIKE if the pattern starts with a constant string (e.g., LIKE 'abc%'), it may not use indexes efficiently for patterns that start with a wildcard (e.g., %abc%).

True / False

In PostgreSQL, LIKE patterns can include escape characters to match literal % or _ characters.

True False

PostgreSQL allows using escape characters in LIKE patterns to match literal % or _ characters by specifying an escape character (e.g., LIKE 'a\%%' ESCAPE '\' to match a%).

True / False

In PostgreSQL, the SIMILAR TO operator can be used as an alternative to LIKE for more complex pattern matching using regular expressions.

True False

The SIMILAR TO operator allows for more complex pattern matching using SQL-standard regular expressions, providing greater flexibility than LIKE.

Q10

True / False

In PostgreSQL, the LIKE operator supports the use of character ranges (e.g., [a-z]) within patterns.

True False

The LIKE operator does not support character ranges directly. Instead, the SIMILAR TO or regular expression operators (~) can be used for such patterns.

Q11

Single Choice

What does the % symbol represent in a LIKE pattern in PostgreSQL?

A single character Any sequence of characters (including zero characters) A single digitA single word

In PostgreSQL, the % symbol in a LIKE pattern matches any sequence of characters, including zero characters.

Q12

Single Choice

Which of the following LIKE patterns would match the string 'PostgreSQL'?

SQL Code

SELECT * FROM table_name WHERE column_name LIKE 'Post%';

It matches 'PostgreSQL' only. It matches any string starting with 'Post'. It matches any string containing 'Post'.It does not match 'PostgreSQL'.

The pattern LIKE 'Post%' matches any string that starts with 'Post', so it would match 'PostgreSQL'.

Q13

Single Choice

Which pattern would match any string that contains exactly five characters?

SQL Code

SELECT * FROM table_name WHERE column_name LIKE '_____';

Matches any string with five characters. Matches any string with four characters. Matches any string with more than five characters.Matches any string with less than five characters.

The underscore (_) in a LIKE pattern matches exactly one character. Therefore, five underscores will match any string with exactly five characters.

Q14

Single Choice

What would the following SQL query return if the column_name contains 'PostgreSQL', 'Postman', and 'Post'?

SQL Code

SELECT * FROM table_name WHERE column_name LIKE 'Post%man';

Only Postman Postman' and 'Post Postman' and 'PostgreSQLAll of them

The pattern LIKE 'Post%man' matches strings that start with 'Post' and end with 'man'. Only 'Postman' fits this pattern.

Q15

Single Choice

Which of the following statements is correct regarding case sensitivity in PostgreSQL when using the LIKE operator?

SQL Code

SELECT * FROM table_name WHERE column_name LIKE 'post%';

PostgreSQL LIKE is always case-sensitive. PostgreSQL LIKE is case-insensitive. PostgreSQL LIKE is case-sensitive unless ILIKE is used.PostgreSQL LIKE is case-insensitive unless a collation is used.

In PostgreSQL, the LIKE operator is case-sensitive by default. To perform a case-insensitive search, you would use ILIKE.

Q16

Single Choice

What will be the result of the following query?

SQL Code

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

Matches any username ending with '_admin' Matches any username ending with '_admin' Matches any username containing '_admin'Matches any username starting with '_admin'

The \ is used as an escape character here, so \_ in the pattern matches a literal underscore. The pattern will match any username that ends with _admin.

Q17

Single Choice

Which of the following SQL queries correctly uses LIKE with multiple patterns in PostgreSQL?

SQL Code

SELECT * FROM employees WHERE name LIKE 'John%' OR name LIKE 'Jane%';

Matches any name starting with 'John' or 'Jane' Matches any name ending with 'John' or 'Jane' Matches any name containing 'John' or 'Jane'Matches any name exactly 'John' or 'Jane'

The query uses LIKE with multiple patterns to match any name that starts with either 'John' or 'Jane'.

Q18

Single Choice

Consider the following table products:

SQL Code

product_name
Phone
Laptop
Tablet
Notebook

Which query will return all products with names containing 'top'?
SELECT * FROM products WHERE product_name LIKE '%top%';

Returns 'Phone' Returns 'Laptop' and 'Notebook' Returns 'Laptop'Returns 'Tablet' and 'Notebook'

The pattern LIKE '%top%' matches any string that contains 'top'. Only 'Laptop' contains 'top'

Q19

Single Choice

Which SQL query would return all rows where description starts with 'Pro' and contains exactly 10 characters?

SQL Code

SELECT * FROM table_name WHERE description LIKE 'Pro_______';

Returns rows with descriptions like 'Proactive' and 'Programmer' Returns rows with descriptions like 'Projector' Returns rows with descriptions like 'Production'Returns no rows

The pattern LIKE 'Pro_______' matches any string that starts with 'Pro' and contains exactly 10 characters. 'Projector' fits this pattern.

Q20

Single Choice

Given a table documents with the following data: doc_name PostgreSQLDoc PostgresGuide SQLTutorial ManualPost

SQL Code

Which query will return all documents with 'Post' in any part of the doc_name?

SELECT * FROM documents WHERE doc_name LIKE '%Post%';

Returns 'PostgreSQLDoc', 'PostgresGuide', and 'ManualPost' Returns 'PostgreSQLDoc' and 'ManualPost' Returns 'PostgresGuide' and 'ManualPost'Returns all documents

The pattern LIKE '%Post%' matches any string containing 'Post' at any position, so it returns 'PostgreSQLDoc', 'PostgresGuide', and 'ManualPost'.

Q21

Multiple Choice

Identify the SQL scripts that correctly use the LIKE operator with a wildcard at the end of the string in PostgreSQL.

SELECT * FROM customers WHERE last_name LIKE 'Smi%'; SELECT * FROM customers WHERE last_name LIKE '%Smi'; SELECT * FROM customers WHERE last_name LIKE 'Smi_';SELECT * FROM customers WHERE last_name LIKE '%Smi%';

The LIKE operator can be used with a wildcard (%) at the end of the string to match any characters following a specific pattern. The correct scripts will demonstrate how to use this operator in PostgreSQL.

Q22

Multiple Choice

Select the SQL scripts that correctly use the LIKE operator to match a specific pattern in PostgreSQL.

SELECT * FROM orders WHERE order_number LIKE 'ORD%5'; SELECT * FROM orders WHERE order_number LIKE 'ORD_5'; SELECT * FROM orders WHERE order_number LIKE '%ORD5';SELECT * FROM orders WHERE order_number LIKE 'ORD5%';

The LIKE operator can be used with wildcards to match patterns that start and end with specific characters. The correct scripts will demonstrate how to use this operator with such patterns in PostgreSQL.

Q23

Multiple Choice

Determine the SQL scripts that correctly use the LIKE operator to match any single character in PostgreSQL.

SELECT * FROM products WHERE product_code LIKE 'A___'; SELECT * FROM products WHERE product_code LIKE 'A%'; SELECT * FROM products WHERE product_code LIKE '_A__';SELECT * FROM products WHERE product_code LIKE 'A__%';

The LIKE operator can be used with the underscore (_) wildcard to match any single character. The correct scripts will demonstrate how to use this operator to match a specific number of characters in PostgreSQL.

Q24

Multiple Choice

Identify the SQL scripts that correctly use the LIKE operator with numeric values in PostgreSQL.

SELECT * FROM invoices WHERE invoice_number LIKE '%7%'; SELECT * FROM invoices WHERE invoice_number LIKE '7%'; SELECT * FROM invoices WHERE invoice_number LIKE '%7';SELECT * FROM invoices WHERE invoice_number = '7%';

The LIKE operator can be used with numeric values stored as text to match patterns within numbers. The correct scripts will demonstrate how to use this operator to find a specific digit in PostgreSQL.

Q25

Multiple Choice

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

SELECT * FROM users WHERE username LIKE 'admin__'; SELECT * FROM users WHERE username LIKE 'admin_%'; SELECT * FROM users WHERE username LIKE 'admin\_%' ESCAPE '\';SELECT * FROM users WHERE username LIKE 'admin%_';

The LIKE operator can be used to match patterns that include special characters by using the appropriate wildcards. The correct scripts will demonstrate how to use this operator with special character patterns in PostgreSQL.

Q26

Multiple Choice

Determine the SQL scripts that correctly use the LIKE operator with case-insensitive searches in PostgreSQL.

SELECT * FROM employees WHERE LOWER(first_name) LIKE 'john'; SELECT * FROM employees WHERE first_name ILIKE 'John'; SELECT * FROM employees WHERE first_name LIKE 'JOHN';SELECT * FROM employees WHERE first_name LIKE 'john';

PostgreSQL's LIKE operator is case-sensitive, so achieving case-insensitivity requires specific handling. The correct scripts will demonstrate how to perform case-insensitive pattern matching using LIKE in PostgreSQL.

Q27

Multiple Choice

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

SELECT * FROM orders WHERE order_number LIKE (SELECT pattern FROM patterns WHERE id = 1); SELECT * FROM orders WHERE order_number LIKE ALL (SELECT pattern FROM patterns WHERE id = 1); SELECT * FROM orders WHERE order_number LIKE '%(SELECT pattern FROM patterns)%';SELECT * FROM orders WHERE order_number = (SELECT pattern FROM patterns WHERE id = 1);

The LIKE operator can be used with subqueries to compare values against patterns retrieved dynamically. The correct scripts will demonstrate how to use LIKE with subqueries in PostgreSQL.

Q28

Multiple Choice

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

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

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

Q29

Multiple Choice

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

SELECT * FROM products WHERE product_name NOT LIKE 'Test%'; SELECT * FROM products WHERE product_name LIKE 'Test_'; SELECT * FROM products WHERE product_name NOT LIKE 'Test';SELECT * FROM products WHERE product_name LIKE '%Test';

The LIKE operator can be used with the NOT keyword to exclude patterns. The correct scripts will demonstrate how to use NOT LIKE to filter out unwanted patterns in PostgreSQL.

Q30

Multiple Choice

Select the SQL scripts that correctly use the LIKE operator to search for patterns within a specific column in PostgreSQL.

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

The LIKE operator is used to search for patterns within specific columns. The correct scripts will demonstrate how to search for a domain within an email field using LIKE in PostgreSQL.

PostgreSQL Database Quiz Questions