Test Your PostgreSQL BETWEEN Operator Knowledge with This Quiz

Progress

True / False

In PostgreSQL, the BETWEEN keyword is used to filter the result set within a specified range.

True False

The BETWEEN keyword filters rows where a column's value falls within a specified inclusive range.

True / False

In PostgreSQL, the BETWEEN keyword can only be used with numeric data types.

True False

BETWEEN can be used with numeric, date, and time data types.

True / False

In PostgreSQL, the BETWEEN keyword includes the start and end values of the specified range.

True False

The BETWEEN keyword is inclusive, meaning it includes the start and end values of the range.

True / False

In PostgreSQL, the BETWEEN keyword can be used in the WHERE clause to filter rows based on a range of dates.

True False

BETWEEN can be used in the WHERE clause to filter rows where a date column's value falls within a specified range of dates.

True / False

In PostgreSQL, using NOT BETWEEN will return rows where the column's value is outside the specified range.

True False

NOT BETWEEN filters rows where the column's value is outside the specified range.

True / False

In PostgreSQL, the BETWEEN keyword can be used with string data types to filter rows alphabetically within a specified range.

True False

BETWEEN can be used with string data types to filter rows based on alphabetical order within a specified range.

True / False

In PostgreSQL, the BETWEEN keyword can be used with subqueries to define the range.

True False

BETWEEN can be used with subqueries, allowing the range to be dynamically defined based on the result of subqueries.

True / False

In PostgreSQL, the BETWEEN keyword can be used with composite keys to filter rows within a specified range of multiple columns.

True False

BETWEEN operates on a single column at a time and cannot be used directly with composite keys to filter based on multiple columns simultaneously.

True / False

In PostgreSQL, the BETWEEN keyword can be used in conjunction with the CASE statement to implement conditional logic.

True False

BETWEEN can be used within a CASE statement to implement conditional logic based on whether a value falls within a specified range.

Q10

True / False

In PostgreSQL, the BETWEEN keyword always performs better than using >= and <= operators separately.

True False

The performance of BETWEEN and using >= and <= separately is generally the same, as BETWEEN is internally converted to these operators by PostgreSQL. Performance differences are negligible and depend more on the context and query optimization.

Q11

Single Choice

Which of the following queries correctly selects rows where the column age is between 20 and 30 in PostgreSQL?

SELECT * FROM users WHERE age > 20 AND age < 30; SELECT * FROM users WHERE age >= 20 AND age <= 30; SELECT * FROM users WHERE age BETWEEN 20 AND 30;SELECT * FROM users WHERE age BETWEEN 20 OR 30;

The BETWEEN operator is used to filter the result set within a certain range. In PostgreSQL, the BETWEEN operator is inclusive, meaning it includes the start and end values.

Q12

Single Choice

In PostgreSQL, what does the following query return? SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31';

Orders placed before January 1, 2023 Orders placed after December 31, 2023 Orders placed between January 1, 2023, and December 31, 2023Orders placed on January 1, 2023

The BETWEEN operator will include all orders placed from January 1, 2023, to December 31, 2023.

Q13

Single Choice

Which of the following queries will select products with prices between 100 and 200 in PostgreSQL?

SELECT * FROM products WHERE price BETWEEN 100 OR 200; SELECT * FROM products WHERE price >= 100 AND price <= 200; SELECT * FROM products WHERE price >= 100 OR price <= 200;SELECT * FROM products WHERE price BETWEEN 100 AND 200;

The BETWEEN operator is used to filter the data between two specified values. Option D is correct because it correctly uses the BETWEEN operator.

Q14

Single Choice

Consider the PostgreSQL query: SELECT * FROM employees WHERE hire_date BETWEEN '2020-01-01' AND '2022-12-31';. What does this query return?

Employees hired before January 1, 2020 Employees hired after December 31, 2022 Employees hired between January 1, 2020, and December 31, 2022Employees hired only on January 1, 2020

The BETWEEN operator in PostgreSQL includes the boundary values, so it selects employees hired within the date range, including January 1, 2020, and December 31, 2022.

Q15

Single Choice

What will be the output of the following PostgreSQL query: SELECT * FROM sales WHERE amount BETWEEN 500 AND 1000;?

Sales with an amount less than 500 Sales with an amount greater than 1000 Sales with an amount between 500 and 1000, inclusiveSales with an amount equal to 500 and 1000 only

The BETWEEN operator includes both the lower and upper bounds, so this query returns sales with amounts from 500 to 1000 inclusive.

Q16

Single Choice

In PostgreSQL, how can you retrieve records where the rating is not between 3 and 5?

SELECT * FROM reviews WHERE rating < 3 OR rating > 5; SELECT * FROM reviews WHERE rating BETWEEN 3 AND 5; SELECT * FROM reviews WHERE rating NOT BETWEEN 3 AND 5;SELECT * FROM reviews WHERE rating >= 3 AND rating <= 5;

The NOT BETWEEN operator is used to exclude a range of values. This query will return records where the rating is outside the range of 3 to 5.

Q17

Single Choice

What will be the result of this PostgreSQL query? SELECT * FROM inventory WHERE quantity BETWEEN (SELECT MIN(quantity) FROM inventory) AND (SELECT MAX(quantity) FROM inventory);

Rows with quantity equal to the minimum value Rows with quantity equal to the maximum value Rows with quantity between the minimum and maximum valuesRows with quantity not between the minimum and maximum values

The BETWEEN clause can be used with subqueries to define the range dynamically. This query selects rows where the quantity is within the minimum and maximum quantities in the inventory table.

Q18

Single Choice

Given the query: SELECT * FROM transactions WHERE amount BETWEEN 500 AND 1000 AND transaction_date BETWEEN '2023-01-01' AND '2023-06-30'; What is true about the records it will return?

Transactions with amount exactly 500 and 1000 only Transactions with amount between 500 and 1000, and dates outside the range Transactions with amount between 500 and 1000, and dates between January 1, 2023, and June 30, 2023Transactions with any amount and any date

The query filters transactions with an amount between 500 and 1000 and also restricts the dates between January 1, 2023, and June 30, 2023.

Q19

Single Choice

In PostgreSQL, how does the query SELECT * FROM employees WHERE salary BETWEEN 50000 AND 100000; compare to the query SELECT * FROM employees WHERE salary >= 50000 AND salary <= 100000;?

The first query returns fewer rows The first query returns more rows Both queries return the same rowsThe second query is faster

The BETWEEN operator is equivalent to using >= and <=. Both queries return the same set of rows.

Q20

Single Choice

What would be the impact of using the BETWEEN operator in the following PostgreSQL query? SELECT * FROM employees WHERE experience BETWEEN 5 AND 10 AND salary BETWEEN 60000 AND 80000;

Employees with either experience between 5 and 10 years or salary between 60000 and 80000 Employees with both experience between 5 and 10 years and salary between 60000 and 80000 Employees with experience greater than 10 years and salary less than 60000Employees with experience less than 5 years or salary greater than 80000

The query selects employees who meet both conditions: experience between 5 and 10 years and salary between 60000 and 80000.

Q21

Multiple Choice

Identify the SQL scripts that correctly use the BETWEEN operator for filtering numeric values in PostgreSQL.

SELECT * FROM employees WHERE salary BETWEEN 30000 AND 60000; SELECT * FROM employees WHERE salary BETWEEN 60000 AND 30000; SELECT * FROM employees WHERE salary >= 30000 AND salary <= 60000;SELECT * FROM employees WHERE salary > 30000 AND salary < 60000;

The BETWEEN operator is used to filter the result set within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with numeric values in PostgreSQL.

Q22

Multiple Choice

Select the SQL scripts that correctly use the BETWEEN operator for filtering date values in PostgreSQL.

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-06-30'; SELECT * FROM orders WHERE order_date >= '2023-01-01' AND order_date <= '2023-06-30'; SELECT * FROM orders WHERE order_date BETWEEN '2023-06-30' AND '2023-01-01';SELECT * FROM orders WHERE order_date > '2023-01-01' AND order_date < '2023-06-30';

The BETWEEN operator can be used to filter date ranges. The correct scripts will demonstrate how to use the BETWEEN operator with date values in PostgreSQL.

Q23

Multiple Choice

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

SELECT * FROM employees WHERE salary NOT BETWEEN 40000 AND 80000; SELECT * FROM employees WHERE NOT salary BETWEEN 40000 AND 80000; SELECT * FROM employees WHERE salary < 40000 OR salary > 80000;SELECT * FROM employees WHERE NOT salary >= 40000 AND NOT salary <= 80000;

The NOT BETWEEN operator is used to filter out rows within a specified range. The correct scripts will demonstrate how to use the NOT BETWEEN operator with numeric values in PostgreSQL.

Q24

Multiple Choice

Identify the SQL scripts that correctly use the BETWEEN operator for filtering string values in PostgreSQL.

SELECT * FROM customers WHERE customer_name BETWEEN 'A' AND 'M'; SELECT * FROM customers WHERE customer_name >= 'A' AND customer_name <= 'M'; SELECT * FROM customers WHERE customer_name BETWEEN 'M' AND 'A';SELECT * FROM customers WHERE customer_name > 'A' AND customer_name < 'M';

The BETWEEN operator can be used with string values to filter alphabetically within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with string values in PostgreSQL.

Q25

Multiple Choice

Select the SQL scripts that correctly use the BETWEEN operator with JOINs in PostgreSQL.

SELECT o.*, c.customer_name FROM orders o JOIN customers c ON o.customer_id = c.customer_id WHERE o.amount BETWEEN 100 AND 500; SELECT o.*, c.customer_name FROM orders o JOIN customers c ON o.customer_id = c.customer_id WHERE amount BETWEEN 100 AND 500; SELECT o.*, c.customer_name FROM orders o JOIN customers c ON o.customer_id = c.customer_id WHERE o.amount >= 100 AND o.amount <= 500;SELECT o.*, c.customer_name FROM orders o LEFT JOIN customers c ON o.customer_id = c.customer_id WHERE o.amount BETWEEN 500 AND 100;

The BETWEEN operator can be used with JOINs to filter results from multiple tables within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with JOINs in PostgreSQL.

Q26

Multiple Choice

Determine the SQL scripts that correctly use the BETWEEN operator with GROUP BY in PostgreSQL.

SELECT department_id, SUM(amount) AS total_sales FROM sales GROUP BY department_id HAVING total_sales BETWEEN 5000 AND 20000; SELECT department_id, SUM(amount) AS total_sales FROM sales WHERE SUM(amount) BETWEEN 5000 AND 20000 GROUP BY department_id; SELECT department_id, SUM(amount) AS total_sales FROM sales GROUP BY department_id HAVING SUM(amount) BETWEEN 5000 AND 20000;SELECT department_id, SUM(amount) AS total_sales FROM sales GROUP BY department_id WHERE SUM(amount) BETWEEN 5000 AND 20000;

The BETWEEN operator can be used with GROUP BY to filter grouped results within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with GROUP BY in PostgreSQL.

Q27

Multiple Choice

Identify the SQL scripts that correctly use the BETWEEN operator with ORDER BY in PostgreSQL.

SELECT * FROM employees WHERE hire_date BETWEEN '2020-01-01' AND '2023-12-31' ORDER BY hire_date ASC; SELECT * FROM employees ORDER BY hire_date ASC WHERE hire_date BETWEEN '2020-01-01' AND '2023-12-31'; SELECT * FROM employees WHERE hire_date >= '2020-01-01' AND hire_date <= '2023-12-31' ORDER BY hire_date ASC;SELECT * FROM employees WHERE hire_date BETWEEN '2023-12-31' AND '2020-01-01' ORDER BY hire_date ASC;

The BETWEEN operator can be used with ORDER BY to filter and sort results within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with ORDER BY in PostgreSQL.

Q28

Multiple Choice

Select the SQL scripts that correctly use the BETWEEN operator with window functions in PostgreSQL.

SELECT employee_id, salary, RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees WHERE salary BETWEEN 40000 AND 90000; SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS rank FROM employees WHERE salary BETWEEN 40000 AND 90000; SELECT employee_id, salary, DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees WHERE salary BETWEEN 40000 AND 90000;SELECT employee_id, salary, ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees WHERE salary BETWEEN 40000 AND 90000;

The BETWEEN operator can be used with window functions to filter and rank results within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with window functions in PostgreSQL.

Q29

Multiple Choice

Determine the SQL scripts that correctly use the BETWEEN operator with LIMIT OFFSET in PostgreSQL.

SELECT * FROM employees WHERE salary BETWEEN 60000 AND 100000 ORDER BY salary DESC LIMIT 5 OFFSET 5; SELECT * FROM employees ORDER BY salary DESC WHERE salary BETWEEN 60000 AND 100000 LIMIT 5 OFFSET 5; SELECT * FROM employees WHERE salary BETWEEN 60000 AND 100000 LIMIT 5 OFFSET 5 ORDER BY salary DESC;SELECT * FROM employees WHERE salary BETWEEN 60000 AND 100000 ORDER BY salary DESC LIMIT 5 OFFSET 10;

The BETWEEN operator can be used with LIMIT OFFSET to filter and paginate results within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with LIMIT OFFSET in PostgreSQL.

Q30

Multiple Choice

Identify the SQL scripts that correctly use the BETWEEN operator with DISTINCT in PostgreSQL.

SELECT DISTINCT department_id FROM employees WHERE salary BETWEEN 50000 AND 100000; SELECT DISTINCT department_id FROM employees WHERE salary BETWEEN 100000 AND 50000; SELECT department_id FROM (SELECT DISTINCT department_id FROM employees) AS sub WHERE salary BETWEEN 50000 AND 100000;SELECT DISTINCT department_id FROM employees WHERE salary >= 50000 AND salary <= 100000;

The BETWEEN operator can be used with DISTINCT to filter unique rows within a specified range. The correct scripts will demonstrate how to use the BETWEEN operator with DISTINCT in PostgreSQL.

PostgreSQL Database Quiz Questions