Test Your Oracle '>' and '<' Operators Knowledge

Progress

True / False

In Oracle, the > operator is used to compare two values to determine if the left value is greater than the right value.

True False

The > operator compares two values and returns true if the left value is greater than the right value.

True / False

The < operator in Oracle is used to compare two values to determine if the left value is less than the right value.

True False

The < operator compares two values and returns true if the left value is less than the right value.

True / False

In Oracle, you can use the > and < operators with numeric data types only.

True False

The > and < operators can be used with numeric, date, and character data types.

True / False

In Oracle, the > and < operators can be used in the WHERE clause to filter rows based on a range of values.

True False

The > and < operators can be used in the WHERE clause to filter rows that fall within a specific range.

True / False

The > and < operators in Oracle can be combined with logical operators like AND and OR to create complex conditions.

True False

The > and < operators can be combined with logical operators to form complex filtering criteria.

True / False

In Oracle, the > operator can be used to compare two date values to determine which date is later.

True False

The > operator can be used to compare date values, returning true if the left date is later than the right date.

True / False

In Oracle, the > and < operators can be used in subqueries to filter rows based on the results of another query.

True False

The > and < operators can be used in subqueries to filter rows based on the values returned by the subquery.

True / False

The > and < operators in Oracle are case-sensitive when used with character data types.

True False

Character comparisons using the > and < operators are case-sensitive unless the database collation is set to be case-insensitive.

True / False

In Oracle, the > and < operators can be used in a JOIN condition to join tables based on non-equality conditions.

True False

The > and < operators can be used in JOIN conditions to join tables based on non-equality conditions, such as joining rows where one column value is greater than or less than another.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using the > and < operators efficiently and understanding their impact on query performance and logical outcomes.

True False

The OCP certification covers advanced topics, including the efficient use of the > and < operators and understanding their impact on query performance and logical outcomes in SQL queries.

Q11

Single Choice

What is the primary use of the > operator in Oracle SQL?

To check if a column value is equal to another value To check if a column value is greater than another value To check if a column value is less than another valueTo compare two strings

The > operator in Oracle SQL is used to filter rows where a column value is greater than the specified value.

Q12

Single Choice

What is the primary use of the < operator in Oracle SQL?

To check if a column value is equal to another value To check if a column value is greater than another value To check if a column value is less than another valueTo compare two strings

The < operator in Oracle SQL is used to filter rows where a column value is less than the specified value.

Q13

Single Choice

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

SQL Code

SELECT * FROM employees WHERE salary > 5000;

Employees with a salary less than 5000 Employees with a salary equal to 5000 Employees with a salary greater than 5000All employees

The query uses the > operator to filter and return only those employees whose salary is greater than 5000.

Q14

Single Choice

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

SQL Code

SELECT * FROM orders WHERE order_date < '01-JAN-2023';

Orders placed on January 1, 2023 Orders placed after January 1, 2023 Orders placed before January 1, 2023All orders

The query uses the < operator to return orders where the order_date is before January 1, 2023.

Q15

Single Choice

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

SQL Code

SELECT * FROM products WHERE price > 100 AND price < 500;

Products with a price greater than 500 Products with a price less than 100 Products with a price between 100 and 500Products with a price equal to 100 or 500

The query filters the products table to return rows where the price is greater than 100 and less than 500, effectively selecting products priced between 100 and 500.

Q16

Single Choice

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

SQL Code

SELECT first_name, last_name FROM employees WHERE hire_date > '01-JAN-2020';

Employees hired before January 1, 2020 Employees hired on January 1, 2020 Employees hired after January 1, 2020All employees

The query uses the > operator to return employees whose hire_date is after January 1, 2020.

Q17

Single Choice

How does Oracle treat NULL values when using the > or < operators in a query?

NULL values are treated as the smallest possible value NULL values are treated as the largest possible value The comparison with NULL results in NULL (unknown), so the row is not includedNULL values cause the query to raise an error

When using > or < operators, if a column value is NULL, the comparison result is NULL, which is treated as false, so the row is not included in the result set.

Q18

Single Choice

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

SQL Code

SELECT * FROM sales WHERE amount > 1000 AND amount < 5000 OR discount > 10;

Sales where the amount is between 1000 and 5000 and the discount is greater than 10 Sales where the amount is between 1000 and 5000 or the discount is greater than 10 Sales where the amount is less than 1000 and the discount is less than 10Sales where the amount is greater than 5000 and the discount is less than 10

The query returns rows where either the amount is between 1000 and 5000 or the discount is greater than 10, due to the use of AND and OR operators.

Q19

Single Choice

What will be the output of the following Oracle SQL query if the price column contains NULL values?

SQL Code

SELECT * FROM products WHERE price < 100;

All products with a price less than 100, including those with NULL values All products with a price less than 100, excluding those with NULL values All products, regardless of priceNo products because of the NULL values

The query excludes rows where the price is NULL because comparisons with NULL return NULL, which is not true.

Q20

Single Choice

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

SQL Code

SELECT employee_id, salary FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

Employees with a salary less than the average salary Employees with a salary equal to the average salary Employees with a salary greater than the average salaryAll employees regardless of salary

This query uses a subquery to calculate the average salary and then selects employees whose salary is greater than this average.

Q21

Multiple Choice

Which SQL code snippet correctly uses the '>' and '<' operators to filter employees where the salary is greater than 50000 and less than 100000 in Oracle?

SQL Code

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

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

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

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

Options A and C correctly use the '>' and '<' operators to filter employees where the salary is greater than 50000 and less than 100000. Option B incorrectly includes the equality operators.

Q22

Multiple Choice

Which SQL code snippet demonstrates how to use the '>' and '<' operators to filter orders where the total amount is greater than 1000 and less than 5000 in Oracle?

SQL Code

SELECT *
FROM orders
WHERE total_amount > 1000 AND total_amount < 5000;

SELECT *
FROM orders
WHERE total_amount > 1000 OR total_amount < 5000;

SELECT order_id, total_amount
FROM orders
WHERE total_amount > 1000 AND total_amount < 5000;

SELECT * FROM orders WHERE total_amount > 1000 AND total_amount < 5000; SELECT * FROM orders WHERE total_amount > 1000 OR total_amount < 5000; SELECT order_id, total_amount FROM orders WHERE total_amount > 1000 AND total_amount < 5000;SELECT * FROM orders WHERE total_amount > 5000 AND total_amount < 1000;

Options A and C correctly use the '>' and '<' operators to filter orders where the total amount is greater than 1000 and less than 5000. Option B incorrectly uses the OR operator instead of AND.

Q23

Multiple Choice

Which SQL code snippet uses the '>' and '<' operators to filter products where the price is greater than 100 and less than 1000 in Oracle?

SQL Code

SELECT *
FROM products
WHERE price > 100 AND price < 1000;

SELECT *
FROM products
WHERE price > 100 AND price < 500;

SELECT product_id, price
FROM products
WHERE price > 100 AND price < 1000;

SELECT * FROM products WHERE price > 100 AND price < 1000; SELECT * FROM products WHERE price > 100 AND price < 500; SELECT product_id, price FROM products WHERE price > 100 AND price < 1000;SELECT * FROM products WHERE price > 1000 AND price < 100;

Options A and C correctly use the '>' and '<' operators to filter products where the price is greater than 100 and less than 1000. Option B incorrectly narrows the range.

Q24

Multiple Choice

Which SQL code snippet demonstrates how to use the '>' and '<' operators to filter customers where the age is greater than 25 and less than 50 in Oracle?

SQL Code

SELECT *
FROM customers
WHERE age > 25 AND age < 50;

SELECT *
FROM customers
WHERE age >= 25 AND age <= 50;

SELECT customer_id, age
FROM customers
WHERE age > 25 AND age < 50;

SELECT * FROM customers WHERE age > 25 AND age < 50; SELECT * FROM customers WHERE age >= 25 AND age <= 50; SELECT customer_id, age FROM customers WHERE age > 25 AND age < 50;SELECT * FROM customers WHERE age > 50 AND age < 25;

Options A and C correctly use the '>' and '<' operators to filter customers where the age is greater than 25 and less than 50. Option B incorrectly includes the equality operators.

Q25

Multiple Choice

Which SQL code snippet uses the '>' and '<' operators to filter sales where the quantity is greater than 10 and less than 100 in Oracle?

SQL Code

SELECT *
FROM sales
WHERE quantity > 10 AND quantity < 100;

SELECT *
FROM sales
WHERE quantity > 10 AND quantity < 50;

SELECT sale_id, quantity
FROM sales
WHERE quantity > 10 AND quantity < 100;

SELECT * FROM sales WHERE quantity > 10 AND quantity < 100; SELECT * FROM sales WHERE quantity > 10 AND quantity < 50; SELECT sale_id, quantity FROM sales WHERE quantity > 10 AND quantity < 100;SELECT * FROM sales WHERE quantity > 100 AND quantity < 10;

Options A and C correctly use the '>' and '<' operators to filter sales where the quantity is greater than 10 and less than 100. Option B incorrectly narrows the range.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '>' and '<' operators to filter employees where the performance rating is greater than 3 and less than 5 in Oracle?

SQL Code

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

SELECT *
FROM employees
WHERE performance_rating > 2 AND performance_rating < 5;

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

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

Options A and C correctly use the '>' and '<' operators to filter employees where the performance rating is greater than 3 and less than 5. Option B incorrectly includes a broader range.

Q27

Multiple Choice

Which SQL code snippet uses the '>' and '<' operators to filter orders where the delivery time is greater than 2 days and less than 7 days in Oracle?

SQL Code

SELECT *
FROM orders
WHERE delivery_time > 2 AND delivery_time < 7;

SELECT *
FROM orders
WHERE delivery_time > 1 AND delivery_time < 7;

SELECT order_id, delivery_time
FROM orders
WHERE delivery_time > 2 AND delivery_time < 7;

SELECT * FROM orders WHERE delivery_time > 2 AND delivery_time < 7; SELECT * FROM orders WHERE delivery_time > 1 AND delivery_time < 7; SELECT order_id, delivery_time FROM orders WHERE delivery_time > 2 AND delivery_time < 7;SELECT * FROM orders WHERE delivery_time > 7 AND delivery_time < 2;

Options A and C correctly use the '>' and '<' operators to filter orders where the delivery time is greater than 2 days and less than 7 days. Option B incorrectly includes a broader range.

Q28

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '>' and '<' operators to filter products where the rating is greater than 3.5 and less than 4.5 in Oracle?

SQL Code

SELECT *
FROM products
WHERE rating > 3.5 AND rating < 4.5;

SELECT *
FROM products
WHERE rating > 3.0 AND rating < 4.5;

SELECT product_id, rating
FROM products
WHERE rating > 3.5 AND rating < 4.5;

SELECT * FROM products WHERE rating > 3.5 AND rating < 4.5; SELECT * FROM products WHERE rating > 3.0 AND rating < 4.5; SELECT product_id, rating FROM products WHERE rating > 3.5 AND rating < 4.5;SELECT * FROM products WHERE rating > 4.5 AND rating < 3.5;

Options A and C correctly use the '>' and '<' operators to filter products where the rating is greater than 3.5 and less than 4.5. Option B incorrectly includes a broader range.

Q29

Multiple Choice

Which SQL code snippet uses the '>' and '<' operators to filter inventory where the reorder level is greater than 50 and less than 200 in Oracle?

SQL Code

SELECT *
FROM inventory
WHERE reorder_level > 50 AND reorder_level < 200;

SELECT *
FROM inventory
WHERE reorder_level > 50 AND reorder_level < 150;

SELECT item_id, reorder_level
FROM inventory
WHERE reorder_level > 50 AND reorder_level < 200;

SELECT * FROM inventory WHERE reorder_level > 50 AND reorder_level < 200; SELECT * FROM inventory WHERE reorder_level > 50 AND reorder_level < 150; SELECT item_id, reorder_level FROM inventory WHERE reorder_level > 50 AND reorder_level < 200;SELECT * FROM inventory WHERE reorder_level > 200 AND reorder_level < 50;

Options A and C correctly use the '>' and '<' operators to filter inventory where the reorder level is greater than 50 and less than 200. Option B incorrectly narrows the range.

Q30

Multiple Choice

Which SQL code snippet demonstrates the certification-level use of the '>' and '<' operators to filter transactions where the transaction time is greater than 30 minutes and less than 2 hours in Oracle?

SQL Code

SELECT *
FROM transactions
WHERE transaction_time > 30 AND transaction_time < 120;

SELECT *
FROM transactions
WHERE transaction_time > 60 AND transaction_time < 120;

SELECT transaction_id, transaction_time
FROM transactions
WHERE transaction_time > 30 AND transaction_time < 120;

SELECT * FROM transactions WHERE transaction_time > 30 AND transaction_time < 120; SELECT * FROM transactions WHERE transaction_time > 60 AND transaction_time < 120; SELECT transaction_id, transaction_time FROM transactions WHERE transaction_time > 30 AND transaction_time < 120;SELECT * FROM transactions WHERE transaction_time > 120 AND transaction_time < 30;

Options A and C correctly use the '>' and '<' operators to filter transactions where the transaction time is greater than 30 minutes and less than 2 hours. Option B incorrectly narrows the range.

Oracle Database Quiz Questions