Test Your Knowledge on Oracle BETWEEN Operator

Progress

True / False

In Oracle, the BETWEEN operator is used to filter the result set within a specified range.

True False

The BETWEEN operator is used to filter rows that fall within a specified range of values.

True / False

The BETWEEN operator in Oracle includes the boundary values in its range.

True False

The BETWEEN operator includes both the start and end values in the range.

True / False

In Oracle, you can use the BETWEEN operator with numeric, date, and character data types.

True False

The BETWEEN operator can be used with various data types, including numeric, date, and character types.

True / False

The BETWEEN operator in Oracle can be used in the WHERE clause to filter rows based on a date range.

True False

The BETWEEN operator can filter rows based on a range of dates when used in the WHERE clause.

True / False

In Oracle, the BETWEEN operator is case-sensitive when used with character data.

True False

The BETWEEN operator is not case-sensitive for character data unless the database collation is case-sensitive.

True / False

In Oracle, you can use the BETWEEN operator with multiple columns in a single WHERE clause.

True False

The BETWEEN operator can only be applied to a single column or expression at a time. For multiple columns, you need separate BETWEEN conditions.

True / False

In Oracle, the BETWEEN operator can be combined with the AND operator to create complex range conditions.

True False

The BETWEEN operator can be combined with AND and other logical operators to create complex filtering conditions.

True / False

In Oracle, using the BETWEEN operator on indexed columns can optimize query performance.

True False

Using the BETWEEN operator on indexed columns can improve query performance by efficiently narrowing down the search range.

True / False

The BETWEEN operator can be used in Oracle subqueries to filter rows in nested queries.

True False

The BETWEEN operator can be used in subqueries to filter rows in nested queries, providing a way to apply range conditions within subqueries.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using the BETWEEN operator effectively and understanding its performance implications.

True False

The OCP certification covers advanced topics, including the effective use of the BETWEEN operator and understanding its performance implications in Oracle SQL.

Q11

Single Choice

What is the purpose of the BETWEEN operator in Oracle SQL?

To compare exact values To select rows where a column value falls within a specific range To sort the rows in ascending orderTo join two tables

The BETWEEN operator in Oracle is used to filter rows where a column value falls within a specified range, including the boundary values.

Q12

Single Choice

Consider the following Oracle SQL query:What will this query return?

SQL Code

SELECT * FROM employees WHERE salary BETWEEN 5000 AND 10000;

Employees with a salary less than 5000 Employees with a salary greater than 10000 Employees with a salary between 5000 and 10000, inclusiveAll employees regardless of salary

The BETWEEN operator includes both the start and end values, so this query returns employees with salaries from 5000 to 10000, inclusive.

Q13

Single Choice

Which of the following data types can be used with the BETWEEN operator in Oracle?

Strings Numbers DatesAll of the above

The BETWEEN operator in Oracle can be used with strings, numbers, and dates to filter rows within a specified range.

Q14

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT * FROM orders WHERE order_date BETWEEN '01-JAN-2023' AND '31-DEC-2023';

Orders placed in the year 2022 Orders placed before January 1, 2023 Orders placed in the year 2023Orders placed after December 31, 2023

This query returns orders where the order_date falls within the range of January 1, 2023, to December 31, 2023, inclusive.

Q15

Single Choice

What will be the result of executing the following Oracle SQL query?

SQL Code

SELECT * FROM products WHERE price BETWEEN 100 AND 200 ORDER BY price DESC;

Products with a price less than 100 Products with a price greater than 200 Products with a price between 100 and 200, sorted by price in descending orderProducts with a price between 100 and 200, sorted by price in ascending order

This query filters the products table to include only rows where price is between 100 and 200, then sorts the result by price in descending order.

Q16

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT * FROM employees WHERE hire_date BETWEEN '01-JAN-2020' AND '31-DEC-2020';

Employees hired before January 1, 2020 Employees hired after December 31, 2020 Employees hired during the year 2020Employees hired between 2019 and 2021

The BETWEEN operator filters employees hired between January 1, 2020, and December 31, 2020, inclusive, meaning those hired during the entire year of 2020.

Q17

Single Choice

What is the effect of using the NOT BETWEEN operator in an Oracle SQL query?

It includes rows where the column value is outside the specified range It includes rows where the column value is exactly on the boundary of the range It includes only the rows within the specified rangeIt excludes all rows

The NOT BETWEEN operator in Oracle filters out rows within the specified range, returning only those rows where the column value is outside the range.

Q18

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT * FROM sales WHERE amount NOT BETWEEN 1000 AND 5000;

Sales where the amount is between 1000 and 5000 Sales where the amount is exactly 1000 or 5000 Sales where the amount is less than 1000 or greater than 5000All sales

The NOT BETWEEN operator filters out rows where amount is between 1000 and 5000, returning only those where the amount is less than 1000 or greater than 5000.

Q19

Single Choice

How does Oracle handle NULL values when using the BETWEEN operator in a query?

NULL values are treated as the smallest possible value NULL values are treated as the largest possible value NULL values cause the row to be excluded from the result setThe query raises an error

When a column value is NULL, the BETWEEN operator does not include that row in the result set, as NULL cannot be compared to a range of values.

Q20

Single Choice

In an Oracle certification exam, you encounter the following SQL statement:What does this query return?

SQL Code

SELECT product_id, product_name FROM products WHERE quantity_in_stock BETWEEN 10 AND 50 AND price NOT BETWEEN 100 AND 200;

Products with a quantity in stock outside the range of 10 to 50 Products with a price between 100 and 200 Products with a quantity in stock between 10 and 50 and a price outside the range of 100 to 200All products regardless of stock and price

This query returns products where quantity_in_stock is between 10 and 50 and price is outside the range of 100 to 200, using both BETWEEN and NOT BETWEEN operators.

Q21

Multiple Choice

Which SQL code snippet correctly uses the BETWEEN operator to filter employees with salaries between 50000 and 100000 in Oracle?

SQL Code

SELECT *
FROM employees
WHERE salary BETWEEN 50000 AND 100000;

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

SELECT employee_id, salary
FROM employees
WHERE salary BETWEEN 50000 AND 100000;

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

Options A and C correctly use the BETWEEN operator to filter employees with salaries between 50000 and 100000. Option B uses greater than and less than comparisons instead.

Q22

Multiple Choice

Which SQL code snippet demonstrates how to use the BETWEEN operator to filter orders placed between two specific dates in Oracle?

SQL Code

SELECT *
FROM orders
WHERE order_date BETWEEN TO_DATE('2023-01-01', 'YYYY-MM-DD') AND TO_DATE('2023-06-30', 'YYYY-MM-DD');

SELECT *
FROM orders
WHERE order_date >= TO_DATE('2023-01-01', 'YYYY-MM-DD') AND order_date <= TO_DATE('2023-06-30', 'YYYY-MM-DD');

SELECT order_id, order_date
FROM orders
WHERE order_date BETWEEN TO_DATE('2023-01-01', 'YYYY-MM-DD') AND TO_DATE('2023-06-30', 'YYYY-MM-DD');

SELECT * FROM orders WHERE order_date BETWEEN TO_DATE('2023-01-01', 'YYYY-MM-DD') AND TO_DATE('2023-06-30', 'YYYY-MM-DD'); SELECT * FROM orders WHERE order_date >= TO_DATE('2023-01-01', 'YYYY-MM-DD') AND order_date <= TO_DATE('2023-06-30', 'YYYY-MM-DD'); SELECT order_id, order_date FROM orders WHERE order_date BETWEEN TO_DATE('2023-01-01', 'YYYY-MM-DD') AND TO_DATE('2023-06-30', 'YYYY-MM-DD');SELECT * FROM orders WHERE order_date > TO_DATE('2023-01-01', 'YYYY-MM-DD') AND order_date < TO_DATE('2023-06-30', 'YYYY-MM-DD');

Options A and C correctly use the BETWEEN operator to filter orders placed between two specific dates. Option B uses greater than and less than comparisons instead.

Q23

Multiple Choice

Which SQL code snippet uses the BETWEEN operator to filter products with prices between 20 and 50 in Oracle?

SQL Code

SELECT *
FROM products
WHERE price BETWEEN 20 AND 50;

SELECT *
FROM products
WHERE price >= 20 AND price <= 50;

SELECT product_id, price
FROM products
WHERE price BETWEEN 20 AND 50;

SELECT * FROM products WHERE price BETWEEN 20 AND 50; SELECT * FROM products WHERE price >= 20 AND price <= 50; SELECT product_id, price FROM products WHERE price BETWEEN 20 AND 50;SELECT * FROM products WHERE price > 20 AND price < 50;

Options A and C correctly use the BETWEEN operator to filter products with prices between 20 and 50. Option B uses greater than and less than comparisons instead.

Q24

Multiple Choice

Which SQL code snippet demonstrates how to use the BETWEEN operator to filter employees with hire dates between two specific years in Oracle?

SQL Code

SELECT *
FROM employees
WHERE hire_date BETWEEN TO_DATE('2010-01-01', 'YYYY-MM-DD') AND TO_DATE('2020-12-31', 'YYYY-MM-DD');

SELECT *
FROM employees
WHERE hire_date >= TO_DATE('2010-01-01', 'YYYY-MM-DD') AND hire_date <= TO_DATE('2020-12-31', 'YYYY-MM-DD');

SELECT employee_id, hire_date
FROM employees
WHERE hire_date BETWEEN TO_DATE('2010-01-01', 'YYYY-MM-DD') AND TO_DATE('2020-12-31', 'YYYY-MM-DD');

SELECT * FROM employees WHERE hire_date BETWEEN TO_DATE('2010-01-01', 'YYYY-MM-DD') AND TO_DATE('2020-12-31', 'YYYY-MM-DD'); SELECT * FROM employees WHERE hire_date >= TO_DATE('2010-01-01', 'YYYY-MM-DD') AND hire_date <= TO_DATE('2020-12-31', 'YYYY-MM-DD'); SELECT employee_id, hire_date FROM employees WHERE hire_date BETWEEN TO_DATE('2010-01-01', 'YYYY-MM-DD') AND TO_DATE('2020-12-31', 'YYYY-MM-DD');SELECT * FROM employees WHERE hire_date > TO_DATE('2010-01-01', 'YYYY-MM-DD') AND hire_date < TO_DATE('2020-12-31', 'YYYY-MM-DD');

Options A and C correctly use the BETWEEN operator to filter employees with hire dates between two specific years. Option B uses greater than and less than comparisons instead.

Q25

Multiple Choice

Which SQL code snippet uses the BETWEEN operator to filter inventory items with quantities between 100 and 500 in Oracle?

SQL Code

SELECT *
FROM inventory
WHERE quantity BETWEEN 100 AND 500;

SELECT *
FROM inventory
WHERE quantity >= 100 AND quantity <= 500;

SELECT item_id, quantity
FROM inventory
WHERE quantity BETWEEN 100 AND 500;

SELECT * FROM inventory WHERE quantity BETWEEN 100 AND 500; SELECT * FROM inventory WHERE quantity >= 100 AND quantity <= 500; SELECT item_id, quantity FROM inventory WHERE quantity BETWEEN 100 AND 500;SELECT * FROM inventory WHERE quantity > 100 AND quantity < 500;

Options A and C correctly use the BETWEEN operator to filter inventory items with quantities between 100 and 500. Option B uses greater than and less than comparisons instead.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the BETWEEN operator to filter sales records where the sales amount is between 1000 and 5000 in Oracle?

SQL Code

SELECT *
FROM sales
WHERE sales_amount BETWEEN 1000 AND 5000;

SELECT *
FROM sales
WHERE sales_amount >= 1000 AND sales_amount <= 5000;

SELECT sale_id, sales_amount
FROM sales
WHERE sales_amount BETWEEN 1000 AND 5000;

SELECT * FROM sales WHERE sales_amount BETWEEN 1000 AND 5000; SELECT * FROM sales WHERE sales_amount >= 1000 AND sales_amount <= 5000; SELECT sale_id, sales_amount FROM sales WHERE sales_amount BETWEEN 1000 AND 5000;SELECT * FROM sales WHERE sales_amount > 1000 AND sales_amount < 5000;

Options A and C correctly use the BETWEEN operator to filter sales records where the sales amount is between 1000 and 5000. Option B uses greater than and less than comparisons instead.

Q27

Multiple Choice

Which SQL code snippet uses the BETWEEN operator to filter customer records where the customer age is between 18 and 35 in Oracle?

SQL Code

SELECT *
FROM customers
WHERE age BETWEEN 18 AND 35;

SELECT *
FROM customers
WHERE age >= 18 AND age <= 35;

SELECT customer_id, age
FROM customers
WHERE age BETWEEN 18 AND 35;

SELECT * FROM customers WHERE age BETWEEN 18 AND 35; SELECT * FROM customers WHERE age >= 18 AND age <= 35; SELECT customer_id, age FROM customers WHERE age BETWEEN 18 AND 35;SELECT * FROM customers WHERE age > 18 AND age < 35;

Options A and C correctly use the BETWEEN operator to filter customer records where the customer age is between 18 and 35. Option B uses greater than and less than comparisons instead.

Q28

Multiple Choice

Which SQL code snippet demonstrates advanced use of the BETWEEN operator to filter order items with quantities between 10 and 50 and prices between 100 and 500 in Oracle?

SQL Code

SELECT *
FROM order_items
WHERE quantity BETWEEN 10 AND 50
AND price BETWEEN 100 AND 500;

SELECT *
FROM order_items
WHERE quantity >= 10 AND quantity <= 50
AND price >= 100 AND price <= 500;

SELECT item_id, quantity, price
FROM order_items
WHERE quantity BETWEEN 10 AND 50
AND price BETWEEN 100 AND 500;

SELECT * FROM order_items WHERE quantity BETWEEN 10 AND 50 AND price BETWEEN 100 AND 500; SELECT * FROM order_items WHERE quantity >= 10 AND quantity <= 50 AND price >= 100 AND price <= 500; SELECT item_id, quantity, price FROM order_items WHERE quantity BETWEEN 10 AND 50 AND price BETWEEN 100 AND 500;SELECT * FROM order_items WHERE quantity > 10 AND quantity < 50 AND price > 100 AND price < 500;

Options A and C correctly use the BETWEEN operator to filter order items with quantities between 10 and 50 and prices between 100 and 500. Option B uses greater than and less than comparisons instead.

Q29

Multiple Choice

Which SQL code snippet uses the BETWEEN operator to filter employees with performance ratings between 3 and 5 in Oracle?

SQL Code

SELECT *
FROM employees
WHERE performance_rating BETWEEN 3 AND 5;

SELECT *
FROM employees
WHERE performance_rating >= 3 AND performance_rating <= 5;

SELECT employee_id, performance_rating
FROM employees
WHERE performance_rating BETWEEN 3 AND 5;

SELECT * FROM employees WHERE performance_rating BETWEEN 3 AND 5; SELECT * FROM employees WHERE performance_rating >= 3 AND performance_rating <= 5; SELECT employee_id, performance_rating FROM employees WHERE performance_rating BETWEEN 3 AND 5;SELECT * FROM employees WHERE performance_rating > 3 AND performance_rating < 5;

Options A and C correctly use the BETWEEN operator to filter employees with performance ratings between 3 and 5. Option B uses greater than and less than comparisons instead.

Q30

Multiple Choice

Which SQL code snippet demonstrates the certification-level use of the BETWEEN operator to filter orders where the total amount is between 1000 and 5000 and the order date is within the last year in Oracle?

SQL Code

SELECT *
FROM orders
WHERE total_amount BETWEEN 1000 AND 5000
AND order_date BETWEEN SYSDATE - 365 AND SYSDATE;

SELECT *
FROM orders
WHERE total_amount >= 1000 AND total_amount <= 5000
AND order_date >= SYSDATE - 365 AND order_date <= SYSDATE;

SELECT order_id, total_amount, order_date
FROM orders
WHERE total_amount BETWEEN 1000 AND 5000
AND order_date BETWEEN SYSDATE - 365 AND SYSDATE;

SELECT * FROM orders WHERE total_amount BETWEEN 1000 AND 5000 AND order_date BETWEEN SYSDATE - 365 AND SYSDATE; SELECT * FROM orders WHERE total_amount >= 1000 AND total_amount <= 5000 AND order_date >= SYSDATE - 365 AND order_date <= SYSDATE; SELECT order_id, total_amount, order_date FROM orders WHERE total_amount BETWEEN 1000 AND 5000 AND order_date BETWEEN SYSDATE - 365 AND SYSDATE;SELECT * FROM orders WHERE total_amount > 1000 AND total_amount < 5000 AND order_date > SYSDATE - 365 AND order_date < SYSDATE;

Options A and C correctly use the BETWEEN operator to filter orders where the total amount is between 1000 and 5000 and the order date is within the last year. Option B uses greater than and less than comparisons instead.

Oracle Database Quiz Questions