PostgreSQL Comparison Operators Quiz: Test Your SQL Skills

Progress

True / False

In PostgreSQL, the = operator is used to compare two values for equality.

True False

The = operator is the standard operator in PostgreSQL for comparing two values to check if they are equal.

True / False

In PostgreSQL, the != operator is equivalent to the <> operator.

True False

Both != and <> are used in PostgreSQL to compare two values for inequality.

True / False

The < operator in PostgreSQL can be used to check if one value is less than another.

True False

The < operator is used to compare if the value on the left is less than the value on the right.

True / False

In PostgreSQL, the BETWEEN operator is inclusive of the boundary values.

True False

The BETWEEN operator in PostgreSQL includes the boundary values in its comparison.

True / False

The LIKE operator in PostgreSQL is used to compare numeric values.

True False

The LIKE operator is used for pattern matching in text values, not for comparing numeric values.

True / False

In PostgreSQL, the IN operator can be used to check if a value matches any value in a list.

True False

The IN operator is used to compare a value against a list of values to see if it matches any of them.

True / False

In PostgreSQL, the ILIKE operator is case-sensitive.

True False

The ILIKE operator is a case-insensitive version of the LIKE operator.

True / False

PostgreSQL supports the IS DISTINCT FROM operator to handle NULL comparisons more effectively.

True False

The IS DISTINCT FROM operator is used in PostgreSQL to compare two values, treating NULLs as distinct values rather than equal.

True / False

The SIMILAR TO operator in PostgreSQL uses POSIX regular expressions for pattern matching.

True False

The SIMILAR TO operator uses SQL standard regular expressions, not POSIX regular expressions.

Q10

True / False

In PostgreSQL, the IS NOT DISTINCT FROM operator treats NULLs as equal for comparison purposes.

True False

The IS NOT DISTINCT FROM operator in PostgreSQL is used to compare two values, considering NULLs as equal, which is useful in avoiding the typical issues with NULL comparisons.

Q11

Single Choice

Question: Which of the following SQL statements will correctly compare two integer values in PostgreSQL?

SQL Code

SELECT * FROM employees WHERE salary > 50000;

salary < 50000 salary >= 50000 salary = 50000salary > 50000

The > operator is used to compare if the salary is greater than 50000 in PostgreSQL.

Q12

Single Choice

What is the result of the following comparison in PostgreSQL?

SQL Code

SELECT 10 = 10;

TRUE FALSE NULLNULL

The = operator checks if two values are equal. Since 10 equals 10, the result is TRUE.

Q13

Single Choice

How would you check if two columns have the same value in PostgreSQL?

SQL Code

SELECT * FROM products WHERE price = cost;

price > cost price >= cost price = costprice < cost

The = operator is used to compare two columns to check if they hold the same value.

Q14

Single Choice

Which PostgreSQL SQL statement will return rows where the age is not equal to 30?

SQL Code

SELECT * FROM users WHERE age <> 30;

age != 30 age >= 30 age <> 30age > 30

The <> operator is used to check if a value is not equal to another value in PostgreSQL.

Q15

Single Choice

What is the correct SQL statement to find records where amount is less than or equal to 1000 in PostgreSQL?

SQL Code

SELECT * FROM transactions WHERE amount <= 1000;

amount = 1000 amount < 1000 amount <= 1000amount > 1000

The <= operator is used to compare if a value is less than or equal to another value.

Q16

Single Choice

In PostgreSQL, how can you retrieve rows where the date column is greater than '2024-01-01'?

SQL Code

SELECT * FROM events WHERE date > '2024-01-01';

date < '2024-01-01' date = '2024-01-01' date >= '2024-01-01date > '2024-01-01

The > operator checks if the date is greater than '2024-01-01'.

Q17

Single Choice

Which of the following queries correctly uses the BETWEEN operator in PostgreSQL to filter rows based on a range?

SQL Code

SELECT * FROM orders WHERE order_date BETWEEN '2024-01-01' AND '2024-12-31';

order_date < '2024-01-01' order_date >= '2024-01-01 order_date BETWEEN '2024-01-01' AND '2024-12-31order_date > '2024-01-01

The BETWEEN operator is used to filter results within a specific range, inclusive of the boundary values.

Q18

Single Choice

How would you select rows in PostgreSQL where the quantity is exactly 10 or less than 5?

SQL Code

SELECT * FROM inventory WHERE quantity = 10 OR quantity < 5;

quantity >= 10 OR quantity <= 5 quantity = 10 AND quantity < 5 quantity = 10 OR quantity < 5quantity > 10 AND quantity >= 5

The OR operator allows combining conditions where either one can be true.

Q19

Single Choice

In PostgreSQL, what is the result of the following comparison?

SQL Code

SELECT '2024-01-01' > '2023-12-31';

TRUE FALSE NULLNULL

Date comparisons work just like numerical comparisons, where a later date is considered greater than an earlier one.

Q20

Single Choice

Which PostgreSQL query will correctly filter rows where sales is not greater than 500 and also not equal to 300?

SQL Code

SELECT * FROM revenue WHERE sales <= 500 AND sales <> 300;

sales = 500 AND sales <> 300 sales > 500 OR sales = 300 sales <= 500 AND sales <> 300sales < 500 OR sales = 300

This query uses the <= operator to ensure sales is not greater than 500 and <> to ensure it is not equal to 300.

Q21

Multiple Choice

Which SQL queries correctly use the '=' operator for comparison in PostgreSQL?

SELECT * FROM employees WHERE department = 'Sales'; SELECT * FROM employees WHERE department == 'Sales'; SELECT * FROM employees WHERE department LIKE 'Sales';SELECT * FROM employees WHERE department = 'sales';

The '=' operator in PostgreSQL is used to compare values for equality.

Q22

Multiple Choice

Which SQL queries correctly use the '!=' operator for comparison in PostgreSQL?

SELECT * FROM products WHERE price != 100; SELECT * FROM products WHERE price <> 100; SELECT * FROM products WHERE price NOT = 100;SELECT * FROM products WHERE price <> '100';

The '!=' operator in PostgreSQL is used to compare values for inequality.

Q23

Multiple Choice

Which SQL queries correctly use the '>' operator for comparison in PostgreSQL?

SELECT * FROM orders WHERE order_amount > 500; SELECT * FROM orders WHERE order_amount >= 500; SELECT * FROM orders WHERE order_amount > '500';SELECT * FROM orders WHERE order_amount => 500;

The '>' operator in PostgreSQL is used to compare if a value is greater than another value.

Q24

Multiple Choice

Which SQL queries correctly use the '<' operator for comparison in PostgreSQL?

SELECT * FROM students WHERE marks < 75; SELECT * FROM students WHERE marks <= 75; SELECT * FROM students WHERE marks < '75';SELECT * FROM students WHERE marks =< 75;

The '<' operator in PostgreSQL is used to compare if a value is less than another value.

Q25

Multiple Choice

Which SQL queries correctly use the '>=' operator for comparison in PostgreSQL?

SELECT * FROM transactions WHERE amount >= 1000; SELECT * FROM transactions WHERE amount > 1000; SELECT * FROM transactions WHERE amount => 1000;SELECT * FROM transactions WHERE amount >= '1000';

The '>=' operator in PostgreSQL is used to compare if a value is greater than or equal to another value.

Q26

Multiple Choice

Which SQL queries correctly use the '<=' operator for comparison in PostgreSQL?

SELECT * FROM invoices WHERE total <= 500; SELECT * FROM invoices WHERE total < 500; SELECT * FROM invoices WHERE total =< 500;SELECT * FROM invoices WHERE total <= '500';

The '<=' operator in PostgreSQL is used to compare if a value is less than or equal to another value.

Q27

Multiple Choice

Which SQL queries correctly use the '<>' operator for comparison in PostgreSQL?

SELECT * FROM payments WHERE payment_method <> 'Credit Card'; SELECT * FROM payments WHERE payment_method != 'Credit Card'; SELECT * FROM payments WHERE payment_method NOT 'Credit Card';SELECT * FROM payments WHERE payment_method NOT LIKE 'Credit Card';

The '<>' operator in PostgreSQL is used to compare values for inequality, and is functionally equivalent to the '!=' operator.

Q28

Multiple Choice

Which SQL queries correctly combine comparison operators with logical operators?

SELECT * FROM employees WHERE salary > 50000 AND salary < 100000; SELECT * FROM employees WHERE salary >= 50000 AND salary <= 100000; SELECT * FROM employees WHERE salary > 50000 OR salary < 100000;SELECT * FROM employees WHERE salary BETWEEN 50000 AND 100000;

In PostgreSQL, comparison operators can be combined with logical operators like AND and OR to create complex conditions.

Q29

Multiple Choice

Which SQL queries correctly use comparison operators in a subquery?

SELECT * FROM sales WHERE amount > (SELECT AVG(amount) FROM sales); SELECT * FROM sales WHERE amount >= (SELECT AVG(amount) FROM sales); SELECT * FROM sales WHERE amount > AVG(amount);SELECT * FROM sales WHERE amount = (SELECT AVG(amount) FROM sales);

Comparison operators can be used in subqueries to compare values with the results of an aggregated query.

Q30

Multiple Choice

Which SQL queries correctly handle NULL values with comparison operators?

SELECT * FROM projects WHERE budget IS NULL; SELECT * FROM projects WHERE budget = NULL; SELECT * FROM projects WHERE COALESCE(budget, 0) > 10000;SELECT * FROM projects WHERE budget != NULL;

In PostgreSQL, comparison operators interact with NULL values in specific ways. Using IS NULL or COALESCE can help manage these cases.

PostgreSQL Database Quiz Questions