Test Your Oracle '<>' or '!=' Operator Knowledge

Progress

True / False

In Oracle, the <> operator is used to compare two values to determine if they are not equal.

True False

The <> operator checks if two values are not equal and returns true if they are not.

True / False

The != operator can also be used in Oracle to compare two values for inequality.

True False

The != operator is an alternative syntax for the <> operator in Oracle and serves the same purpose.

True / False

In Oracle, both <> and != operators can be used with numeric, character, and date data types.

True False

Both <> and != operators can be used with various data types, including numeric, character, and date types.

True / False

In Oracle, the <> and != operators can be used in the WHERE clause to filter rows based on inequality.

True False

Both operators can be used in the WHERE clause to filter rows that do not meet a specified condition.

True / False

The <> and != operators in Oracle are case-sensitive when comparing character data.

True False

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

True / False

In Oracle, using <> or != operators with NULL values will always return true.

True False

Comparisons with NULL values using <> or != will always return NULL, not true or false, because NULL represents an unknown value.

True / False

In Oracle, the <> and != operators can be used in subqueries to filter rows based on values not equal to those in the subquery result.

True False

Both operators can be used in subqueries to filter rows where values are not equal to those returned by the subquery.

True / False

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

True False

Both operators can be combined with logical operators to form complex filtering criteria in the WHERE clause.

True / False

In Oracle, using the <> or != operators on indexed columns always results in a full table scan.

True False

While inequality comparisons can lead to full table scans, indexed columns can still be used effectively depending on the query execution plan and the presence of other conditions that utilize the index.

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 effective use of <> and != operators and understanding their performance implications and logical outcomes in SQL queries.

Q11

Single Choice

What does the following Oracle SQL query return?

SQL Code

SELECT COUNT(*)
FROM employees
WHERE department_id <> 10;

The total number of employees with department_id equal to 10 The total number of employees with department_id not equal to 10 The total number of employees in department 10The total number of employees in all departments

The <> operator in Oracle is used to compare values and returns rows where the department_id is not equal to 10.

Q12

Single Choice

Which of the following Oracle SQL queries correctly identifies employees who do not work in department 20?

SELECT * FROM employees WHERE department_id = 20; SELECT * FROM employees WHERE department_id != 20; SELECT * FROM employees WHERE department_id >= 20;SELECT * FROM employees WHERE department_id IS NOT 20;

The != operator in Oracle is equivalent to <> and is used to exclude employees with department_id 20.

Q13

Single Choice

In Oracle, which of the following conditions correctly identifies records where the salary is not equal to 5000?

salary = 5000 salary <> 5000 salary IS 5000salary == 5000

The <> operator checks if the salary is not equal to 5000.

Q14

Single Choice

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

SQL Code

SELECT first_name, last_name
FROM employees
WHERE job_id <> 'SA_REP';

All employees with the job_id 'SA_REP' All employees except those with the job_id 'SA_REP' Only employees with job_id equal to 'SA_REP'Only employees with job_id starting with 'SA'

The <> operator excludes employees with the job_id 'SA_REP'.

Q15

Single Choice

Which of the following Oracle SQL statements will return employees whose salary is neither 4000 nor 5000?

SELECT * FROM employees WHERE salary = 4000 AND salary = 5000; SELECT * FROM employees WHERE salary != 4000 OR salary != 5000; SELECT * FROM employees WHERE salary <> 4000 AND salary <> 5000;SELECT * FROM employees WHERE salary = 4000 OR salary = 5000;

The <> operator is used with the AND clause to exclude both salaries 4000 and 5000.

Q16

Single Choice

In Oracle, how would you write a query to select rows where the hire_date is not equal to '01-JAN-2020'?

SELECT * FROM employees WHERE hire_date = '01-JAN-2020'; SELECT * FROM employees WHERE hire_date != '01-JAN-2020'; SELECT * FROM employees WHERE hire_date <> '01-JAN-2020';SELECT * FROM employees WHERE hire_date IS NOT '01-JAN-2020';

The <> operator is the correct way to specify that hire_date should not equal '01-JAN-2020'.

Q17

Single Choice

Which of the following Oracle SQL queries will correctly exclude employees whose commission_pct is not 0.2?

SELECT * FROM employees WHERE commission_pct != 0.2; SELECT * FROM employees WHERE commission_pct == 0.2; SELECT * FROM employees WHERE commission_pct <> 0.2;SELECT * FROM employees WHERE commission_pct =! 0.2;

The <> operator is used to exclude rows where commission_pct equals 0.2. != is also valid, but option C uses the standard <>.

Q18

Single Choice

Which Oracle SQL query returns all products that are not discontinued? How should the query be modified to return products that are discontinued?

SQL Code

SELECT product_name
FROM products
WHERE discontinued = 0;

Change WHERE discontinued = 0; to WHERE discontinued != 0; Change WHERE discontinued = 0; to WHERE discontinued = 1; Change WHERE discontinued = 0; to WHERE discontinued <> 0;Both A and C are correct.

Both != and <> can be used interchangeably in Oracle to check for inequality.

Q19

Single Choice

Which of the following Oracle SQL queries correctly retrieves employees whose manager_id is not equal to their employee_id?

SELECT * FROM employees WHERE manager_id != employee_id; SELECT * FROM employees WHERE manager_id <> employee_id; SELECT * FROM employees WHERE manager_id = employee_id;Both A and B are correct.

Both != and <> can be used to check that manager_id is not equal to employee_id.

Q20

Single Choice

Given the following Oracle SQL statement:What does this query do?

SQL Code

SELECT department_name
FROM departments
WHERE department_id <> (SELECT department_id FROM employees WHERE last_name = 'Smith');

It returns all departments with the same department_id as Smith. It returns all departments except the one associated with Smith. It returns only the department associated with Smith.It returns all departments where department_id is NULL.

The subquery returns the department_id for the employee with the last name 'Smith'. The outer query excludes this department using the <> operator.

Q21

Multiple Choice

Which SQL code snippet correctly uses the '<>' and '!=' operators to filter employees where the department is not equal to 'HR' in Oracle?

SQL Code

SELECT *
FROM employees
WHERE department <> 'HR';

SELECT *
FROM employees
WHERE department != 'HR';

SELECT employee_id, department
FROM employees
WHERE department <> 'HR';

SELECT * FROM employees WHERE department <> 'HR'; SELECT * FROM employees WHERE department != 'HR'; SELECT employee_id, department FROM employees WHERE department <> 'HR';SELECT * FROM employees WHERE department = 'HR';

Options A and B correctly use the '<>' and '!=' operators to filter employees where the department is not equal to 'HR'. Option C also correctly uses the '<>' operator.

Q22

Multiple Choice

Which SQL code snippet demonstrates how to use the '<>' and '!=' operators to filter orders where the status is not equal to 'Shipped' in Oracle?

SQL Code

SELECT *
FROM orders
WHERE status <> 'Shipped';

SELECT *
FROM orders
WHERE status != 'Shipped';

SELECT order_id, status
FROM orders
WHERE status <> 'Shipped';

SELECT * FROM orders WHERE status <> 'Shipped'; SELECT * FROM orders WHERE status != 'Shipped'; SELECT order_id, status FROM orders WHERE status <> 'Shipped';SELECT * FROM orders WHERE status = 'Shipped';

Options A and B correctly use the '<>' and '!=' operators to filter orders where the status is not equal to 'Shipped'. Option C also correctly uses the '<>' operator.

Q23

Multiple Choice

Which SQL code snippet uses the '<>' and '!=' operators to filter products where the category is not equal to 'Electronics' in Oracle?

SQL Code

SELECT *
FROM products
WHERE category <> 'Electronics';

SELECT *
FROM products
WHERE category != 'Electronics';

SELECT product_id, category
FROM products
WHERE category <> 'Electronics';

SELECT * FROM products WHERE category <> 'Electronics'; SELECT * FROM products WHERE category != 'Electronics'; SELECT product_id, category FROM products WHERE category <> 'Electronics';SELECT * FROM products WHERE category = 'Electronics';

Options A and B correctly use the '<>' and '!=' operators to filter products where the category is not equal to 'Electronics'. Option C also correctly uses the '<>' operator.

Q24

Multiple Choice

Which SQL code snippet demonstrates how to use the '<>' and '!=' operators to filter customers where the city is not equal to 'New York' in Oracle?

SQL Code

SELECT *
FROM customers
WHERE city <> 'New York';

SELECT *
FROM customers
WHERE city != 'New York';

SELECT customer_id, city
FROM customers
WHERE city <> 'New York';

SELECT * FROM customers WHERE city <> 'New York'; SELECT * FROM customers WHERE city != 'New York'; SELECT customer_id, city FROM customers WHERE city <> 'New York';SELECT * FROM customers WHERE city = 'New York';

Options A and B correctly use the '<>' and '!=' operators to filter customers where the city is not equal to 'New York'. Option C also correctly uses the '<>' operator.

Q25

Multiple Choice

Which SQL code snippet uses the '<>' and '!=' operators to filter inventory where the stock status is not equal to 'In Stock' in Oracle?

SQL Code

SELECT *
FROM inventory
WHERE stock_status <> 'In Stock';

SELECT *
FROM inventory
WHERE stock_status != 'In Stock';

SELECT item_id, stock_status
FROM inventory
WHERE stock_status <> 'In Stock';

SELECT * FROM inventory WHERE stock_status <> 'In Stock'; SELECT * FROM inventory WHERE stock_status != 'In Stock'; SELECT item_id, stock_status FROM inventory WHERE stock_status <> 'In Stock';SELECT * FROM inventory WHERE stock_status = 'In Stock';

Options A and B correctly use the '<>' and '!=' operators to filter inventory where the stock status is not equal to 'In Stock'. Option C also correctly uses the '<>' operator.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '<>' and '!=' operators to filter sales records where the region is not equal to 'North' in Oracle?

SQL Code

SELECT *
FROM sales
WHERE region <> 'North';

SELECT *
FROM sales
WHERE region != 'North';

SELECT sale_id, region
FROM sales
WHERE region <> 'North';

SELECT * FROM sales WHERE region <> 'North'; SELECT * FROM sales WHERE region != 'North'; SELECT sale_id, region FROM sales WHERE region <> 'North';SELECT * FROM sales WHERE region = 'North';

Options A and B correctly use the '<>' and '!=' operators to filter sales records where the region is not equal to 'North'. Option C also correctly uses the '<>' operator.

Q27

Multiple Choice

Which SQL code snippet uses the '<>' and '!=' operators to filter employees where the job title is not equal to 'Analyst' in Oracle?

SQL Code

SELECT *
FROM employees
WHERE job_title <> 'Analyst';

SELECT *
FROM employees
WHERE job_title != 'Analyst';

SELECT employee_id, job_title
FROM employees
WHERE job_title <> 'Analyst';

SELECT * FROM employees WHERE job_title <> 'Analyst'; SELECT * FROM employees WHERE job_title != 'Analyst'; SELECT employee_id, job_title FROM employees WHERE job_title <> 'Analyst';SELECT * FROM employees WHERE job_title = 'Analyst';

Options A and B correctly use the '<>' and '!=' operators to filter employees where the job title is not equal to 'Analyst'. Option C also correctly uses the '<>' operator.

Q28

Multiple Choice

Which SQL code snippet demonstrates advanced use of the '<>' and '!=' operators to filter orders where the payment method is not equal to 'Credit Card' in Oracle?

SQL Code

SELECT *
FROM orders
WHERE payment_method <> 'Credit Card';

SELECT *
FROM orders
WHERE payment_method != 'Credit Card';

SELECT order_id, payment_method
FROM orders
WHERE payment_method <> 'Credit Card';

SELECT * FROM orders WHERE payment_method <> 'Credit Card'; SELECT * FROM orders WHERE payment_method != 'Credit Card'; SELECT order_id, payment_method FROM orders WHERE payment_method <> 'Credit Card';SELECT * FROM orders WHERE payment_method = 'Credit Card';

Options A and B correctly use the '<>' and '!=' operators to filter orders where the payment method is not equal to 'Credit Card'. Option C also correctly uses the '<>' operator.

Q29

Multiple Choice

Which SQL code snippet uses the '<>' and '!=' operators to filter products where the brand is not equal to 'Apple' in Oracle?

SQL Code

SELECT *
FROM products
WHERE brand <> 'Apple';

SELECT *
FROM products
WHERE brand != 'Apple';

SELECT product_id, brand
FROM products
WHERE brand <> 'Apple';

SELECT * FROM products WHERE brand <> 'Apple'; SELECT * FROM products WHERE brand != 'Apple'; SELECT product_id, brand FROM products WHERE brand <> 'Apple';SELECT * FROM products WHERE brand = 'Apple';

Options A and B correctly use the '<>' and '!=' operators to filter products where the brand is not equal to 'Apple'. Option C also correctly uses the '<>' operator.

Q30

Multiple Choice

Which SQL code snippet demonstrates the certification-level use of the '<>' and '!=' operators to filter transactions where the status is not equal to 'Completed' in Oracle?

SQL Code

SELECT *
FROM transactions
WHERE status <> 'Completed';

SELECT *
FROM transactions
WHERE status != 'Completed';

SELECT transaction_id, status
FROM transactions
WHERE status <> 'Completed';

SELECT * FROM transactions WHERE status <> 'Completed'; SELECT * FROM transactions WHERE status != 'Completed'; SELECT transaction_id, status FROM transactions WHERE status <> 'Completed';SELECT * FROM transactions WHERE status = 'Completed';

Options A and B correctly use the '<>' and '!=' operators to filter transactions where the status is not equal to 'Completed'. Option C also correctly uses the '<>' operator.

Oracle Database Quiz Questions