Test Your Oracle Comparison Operators Knowledge with This Fun SQL Quiz

Progress

True / False

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

True False

The = operator checks if two values are equal and returns true if they are.

True / False

In Oracle, the != and <> operators are both used to compare two values for inequality.

True False

Both != and <> operators can be used to check if two values are not equal.

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 checks if the left value is greater than the right value.

True / False

In Oracle, the <= operator checks if the left value is less than or equal to the right value.

True False

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

True / False

In Oracle, the >= operator checks if the left value is greater than or equal to the right value.

True False

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

True / False

In Oracle, the LIKE operator is used to compare a value to a pattern using wildcard characters.

True False

The LIKE operator is used for pattern matching, often with the % (percent) and _ (underscore) wildcard characters.

True / False

In Oracle, the BETWEEN operator is used to compare a value to a range of values, including the boundary values.

True False

The BETWEEN operator checks if a value falls within a specified range, inclusive of the boundary values.

True / False

In Oracle, the IN operator is used to compare a value to a list of literal values or the results of a subquery.

True False

The IN operator checks if a value matches any value in a list or a subquery result set.

True / False

In Oracle, the IS NULL and IS NOT NULL operators are used to compare values to NULL.

True False

The IS NULL and IS NOT NULL operators check if a value is or is not NULL.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using comparison operators effectively, understanding their syntax, and optimizing their performance in SQL queries.

True False

The OCP certification covers advanced topics, including the effective use of comparison operators, understanding their syntax, and optimizing their performance in SQL queries.

Q11

Single Choice

Which of the following is a valid comparison operator in Oracle SQL?

+ <> *||

The <> operator is used in Oracle SQL to check for inequality (not equal to).

Q12

Single Choice

In Oracle SQL, what does the following expression evaluate to?

SQL Code

SELECT 5 > 3 FROM dual;

TRUE FALSE NULL8

The expression 5 > 3 evaluates to TRUE because 5 is greater than 3.

Q13

Single Choice

Which Oracle SQL operator would you use to check if a value is greater than or equal to another value?

= > >=<

The >= operator checks if the value on the left is greater than or equal to the value on the right.

Q14

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 equal to 5000 Employees with a salary greater than 5000 Employees with a salary less than 5000Employees with a salary greater than or equal to 5000

The < operator is used to filter rows where the salary is less than 5000.

Q15

Single Choice

Which Oracle SQL operator is used to compare if two values are not equal?

<= != ==<>

The <> operator checks if two values are not equal in Oracle SQL.

Q16

Single Choice

Given the Oracle SQL query:What will be the result?

SQL Code

SELECT department_id FROM departments WHERE department_id = 10;

All departments Departments with department_id greater than 10 Departments with department_id equal to 10Departments with department_id less than 10

The = operator is used to filter rows where department_id is equal to 10.

Q17

Single Choice

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

SQL Code

SELECT 15 BETWEEN 10 AND 20 FROM dual;

TRUE FALSE NULL5

The BETWEEN operator checks if a value lies within a specified range, and in this case, 15 is between 10 and 20, so the result is TRUE.

Q18

Single Choice

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

Employees with a salary of exactly 10000 Employees with a salary not equal to 10000 Employees with a salary less than 10000Employees with a salary greater than 10000

The != operator (or <>) is used to find rows where the salary is not equal to 10000.

Q19

Single Choice

Which of the following Oracle SQL queries correctly filters rows where the hire_date is before January 1, 2000?

SELECT * FROM employees WHERE hire_date > '01-JAN-2000'; SELECT * FROM employees WHERE hire_date < '01-JAN-2000'; SELECT * FROM employees WHERE hire_date = '01-JAN-2000';SELECT * FROM employees WHERE hire_date != '01-JAN-2000';

The < operator is used to filter rows where the hire_date is before January 1, 2000.

Q20

Single Choice

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

SQL Code

SELECT CASE
 WHEN salary = 5000 THEN 'Exact Match'
 WHEN salary > 5000 THEN 'Above 5000'
 ELSE 'Below 5000'
 END AS salary_status
FROM employees;

Returns 'Exact Match' for all employees Returns 'Above 5000' for employees with salary greater than 5000 Returns 'Below 5000' for employees with salary less than 5000Returns different statuses based on the salary value

The CASE statement uses comparison operators to return different results depending on the value of salary.

Q21

Multiple Choice

Which SQL code snippet uses the '=' operator to find employees in the 'Sales' department in Oracle?

SQL Code

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id = (SELECT department_id
FROM departments
WHERE department_name = 'Sales');

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id = (SELECT department_id
FROM departments
WHERE department_name = 'Sales');

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id = (SELECT department_id
FROM departments
WHERE department_name = 'Sales');

SELECT employee_id, first_name, department_id FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales'); SELECT employee_id, first_name, department_id FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales'); SELECT employee_id, first_name, department_id FROM employees WHERE department_id = (SELECT department_id FROM departments WHERE department_name = 'Sales');SELECT employee_id, first_name, department_id FROM employees WHERE department_id > 10;

Options A, B, and C correctly demonstrate the use of the '=' operator to find employees in the 'Sales' department. Option D is incorrect because it does not use the '=' operator.

Q22

Multiple Choice

Which SQL code snippet uses the '>' operator to find employees with salaries greater than $50,000 in Oracle?

SQL Code

SELECT employee_id, first_name, salary
FROM employees
WHERE salary > 50000;

SELECT employee_id, first_name, salary
FROM employees
WHERE salary > 50000;

SELECT employee_id, first_name, salary
FROM employees
WHERE salary > 50000;

SELECT employee_id, first_name, salary FROM employees WHERE salary > 50000; SELECT employee_id, first_name, salary FROM employees WHERE salary > 50000; SELECT employee_id, first_name, salary FROM employees WHERE salary > 50000;SELECT employee_id, first_name, salary FROM employees WHERE salary = 50000;

Options A, B, and C correctly demonstrate the use of the '>' operator to find employees with salaries greater than $50,000. Option D is incorrect because it does not use the '>' operator.

Q23

Multiple Choice

Which SQL code snippet uses the '<' operator to find employees with less than 5 years of experience in Oracle?

SQL Code

SELECT employee_id, first_name, years_of_experience
FROM employees
WHERE years_of_experience < 5;

SELECT employee_id, first_name, years_of_experience
FROM employees
WHERE years_of_experience < 5;

SELECT employee_id, first_name, years_of_experience
FROM employees
WHERE years_of_experience < 5;

SELECT employee_id, first_name, years_of_experience FROM employees WHERE years_of_experience < 5; SELECT employee_id, first_name, years_of_experience FROM employees WHERE years_of_experience < 5; SELECT employee_id, first_name, years_of_experience FROM employees WHERE years_of_experience < 5;SELECT employee_id, first_name, years_of_experience FROM employees WHERE years_of_experience = 5;

Options A, B, and C correctly demonstrate the use of the '<' operator to find employees with less than 5 years of experience. Option D is incorrect because it does not use the '<' operator.

Q24

Multiple Choice

Which SQL code snippet uses the '>=' operator to find products with a price greater than or equal to $100 in Oracle?

SQL Code

SELECT product_id, product_name, price
FROM products
WHERE price >= 100;

SELECT product_id, product_name, price
FROM products
WHERE price >= 100;

SELECT product_id, product_name, price
FROM products
WHERE price >= 100;

SELECT product_id, product_name, price FROM products WHERE price >= 100; SELECT product_id, product_name, price FROM products WHERE price >= 100; SELECT product_id, product_name, price FROM products WHERE price >= 100;SELECT product_id, product_name, price FROM products WHERE price = 100;

Options A, B, and C correctly demonstrate the use of the '>=' operator to find products with a price greater than or equal to $100. Option D is incorrect because it does not use the '>=' operator.

Q25

Multiple Choice

Which SQL code snippet uses the '<=' operator to find orders placed on or before January 1, 2023, in Oracle?

SQL Code

SELECT order_id, order_date, customer_id
FROM orders
WHERE order_date <= '2023-01-01';

SELECT order_id, order_date, customer_id
FROM orders
WHERE order_date <= '2023-01-01';

SELECT order_id, order_date, customer_id
FROM orders
WHERE order_date <= '2023-01-01';

SELECT order_id, order_date, customer_id FROM orders WHERE order_date <= '2023-01-01'; SELECT order_id, order_date, customer_id FROM orders WHERE order_date <= '2023-01-01'; SELECT order_id, order_date, customer_id FROM orders WHERE order_date <= '2023-01-01';SELECT order_id, order_date, customer_id FROM orders WHERE order_date = '2023-01-01';

Options A, B, and C correctly demonstrate the use of the '<=' operator to find orders placed on or before January 1, 2023. Option D is incorrect because it does not use the '<=' operator.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '!=' operator to find employees not in the 'HR' department in Oracle?

SQL Code

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id != (SELECT department_id
FROM departments
WHERE department_name = 'HR');

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id != (SELECT department_id
FROM departments
WHERE department_name = 'HR');

SELECT employee_id, first_name, department_id
FROM employees
WHERE department_id != (SELECT department_id
FROM departments
WHERE department_name = 'HR');

SELECT employee_id, first_name, department_id FROM employees WHERE department_id != (SELECT department_id FROM departments WHERE department_name = 'HR'); SELECT employee_id, first_name, department_id FROM employees WHERE department_id != (SELECT department_id FROM departments WHERE department_name = 'HR'); SELECT employee_id, first_name, department_id FROM employees WHERE department_id != (SELECT department_id FROM departments WHERE department_name = 'HR');SELECT employee_id, first_name, department_id FROM employees WHERE department_id = 10;

Options A, B, and C correctly demonstrate the advanced use of the '!=' operator to find employees not in the 'HR' department. Option D is incorrect because it does not use the '!=' operator.

Q27

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '<>' operator to find employees whose salary is not equal to $60,000 in Oracle?

SQL Code

SELECT employee_id, first_name, salary
FROM employees
WHERE salary <> 60000;

SELECT employee_id, first_name, salary
FROM employees
WHERE salary <> 60000;

SELECT employee_id, first_name, salary
FROM employees
WHERE salary <> 60000;

SELECT employee_id, first_name, salary FROM employees WHERE salary <> 60000; SELECT employee_id, first_name, salary FROM employees WHERE salary <> 60000; SELECT employee_id, first_name, salary FROM employees WHERE salary <> 60000;SELECT employee_id, first_name, salary FROM employees WHERE salary = 60000;

Options A, B, and C correctly demonstrate the advanced use of the '<>' operator to find employees whose salary is not equal to $60,000. Option D is incorrect because it does not use the '<>' operator.

Q28

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the 'BETWEEN' operator to find products priced between $50 and $150 in Oracle?

SQL Code

SELECT product_id, product_name, price
FROM products
WHERE price BETWEEN 50 AND 150;

SELECT product_id, product_name, price
FROM products
WHERE price BETWEEN 50 AND 150;

SELECT product_id, product_name, price
FROM products
WHERE price BETWEEN 50 AND 150;

SELECT product_id, product_name, price FROM products WHERE price BETWEEN 50 AND 150; SELECT product_id, product_name, price FROM products WHERE price BETWEEN 50 AND 150; SELECT product_id, product_name, price FROM products WHERE price BETWEEN 50 AND 150;SELECT product_id, product_name, price FROM products WHERE price = 100;

Options A, B, and C correctly demonstrate certification-level use of the 'BETWEEN' operator to find products priced between $50 and $150. Option D is incorrect because it does not use the 'BETWEEN' operator.

Q29

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the 'IN' operator to find orders placed by specific customers in Oracle?

SQL Code

SELECT order_id, customer_id, order_date
FROM orders
WHERE customer_id IN (101, 102, 103);

SELECT order_id, customer_id, order_date
FROM orders
WHERE customer_id IN (101, 102, 103);

SELECT order_id, customer_id, order_date
FROM orders
WHERE customer_id IN (101, 102, 103);

SELECT order_id, customer_id, order_date FROM orders WHERE customer_id IN (101, 102, 103); SELECT order_id, customer_id, order_date FROM orders WHERE customer_id IN (101, 102, 103); SELECT order_id, customer_id, order_date FROM orders WHERE customer_id IN (101, 102, 103);SELECT order_id, customer_id, order_date FROM orders WHERE customer_id = 101;

Options A, B, and C correctly demonstrate certification-level use of the 'IN' operator to find orders placed by specific customers. Option D is incorrect because it does not use the 'IN' operator.

Q30

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the 'LIKE' operator to find customers whose last name starts with 'S' in Oracle?

SQL Code

SELECT customer_id, first_name, last_name
FROM customers
WHERE last_name LIKE 'S%';

SELECT customer_id, first_name, last_name
FROM customers
WHERE last_name LIKE 'S%';

SELECT customer_id, first_name, last_name
FROM customers
WHERE last_name LIKE 'S%';

SELECT customer_id, first_name, last_name FROM customers WHERE last_name LIKE 'S%'; SELECT customer_id, first_name, last_name FROM customers WHERE last_name LIKE 'S%'; SELECT customer_id, first_name, last_name FROM customers WHERE last_name LIKE 'S%';SELECT customer_id, first_name, last_name FROM customers WHERE last_name = 'Smith';

Options A, B, and C correctly demonstrate certification-level use of the 'LIKE' operator to find customers whose last name starts with 'S'. Option D is incorrect because it does not use the 'LIKE' operator.

Oracle Database Quiz Questions