Test Your MySQL Not Equal Operator Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the '<>' operator is used to check if two values are not equal.

True False

In MySQL, the '<>' operator is used to compare two values and returns true if they are not equal.

True / False

The '!=' operator in MySQL cannot be used to compare string values.

True False

The '!=' operator in MySQL can be used to compare both numeric and string values.

True / False

Using '!=' in MySQL is equivalent to using '<>'.

True False

In MySQL, the '!=' operator and the '<>' operator are functionally equivalent and both check for inequality.

True / False

In MySQL, the query SELECT * FROM employees WHERE salary != 5000 returns all employees with a salary different from 5000.

True False

The '!=' operator checks for inequality, so this query returns all employees whose salary is not 5000.

True / False

In MySQL, NULL != NULL returns TRUE.

True False

In MySQL, NULL != NULL returns NULL, not TRUE. Comparisons with NULL always result in NULL unless using the IS NULL or IS NOT NULL operators.

True / False

The '<>' operator in MySQL can be used within a CASE statement to handle conditional logic based on inequality.

True False

The '<>' operator can be used in a CASE statement to handle conditional checks for inequality.

True / False

In MySQL, the query SELECT * FROM products WHERE price != 0 AND price IS NOT NULL ensures that the price is neither zero nor NULL.

True False

This query uses both the '!=' operator and the IS NOT NULL operator to filter out rows where the price is either zero or NULL.

True / False

MySQL optimizes the use of '!=' and '<>' operators equally in query execution plans.

True False

MySQL treats '!=' and '<>' as equivalent, and both are optimized similarly in query execution plans.

True / False

In MySQL, the '!=' operator can be used with the IN clause to exclude specific values.

True False

The '!=' operator cannot be used directly with the IN clause. Instead, NOT IN should be used to exclude specific values.

Q10

True / False

In MySQL, using '!=' in a JOIN condition can produce the same results as using an inner join with an inequality condition.

True False

Using '!=' in a JOIN condition can create a join based on non-equal values, which can produce similar results to an inner join with an inequality condition, but the logic and use case might differ based on specific requirements.

Q11

Single Choice

Which MySQL operator is used to compare two values for inequality?

== = !=:=

The != operator is used in MySQL to test whether two expressions are not equal.

Q12

Single Choice

What will this query return?

SQL Code

Consider the following MySQL statement:
SELECT * FROM employees WHERE salary <> 50000;

Employees with a salary of exactly 50000. Employees with a salary greater than 50000. Employees with a salary less than 50000.Employees with a salary different from 50000.

The <> operator returns rows where the salary column is not equal to 50000.

Q13

Single Choice

Which of the following queries would correctly return all rows where the status column is not equal to 'active'

SELECT * FROM users WHERE status = 'active'; SELECT * FROM users WHERE status != 'active'; SELECT * FROM users WHERE status IS NOT 'active';SELECT * FROM users WHERE status <> 'inactive';

The != operator correctly checks for inequality with 'active' in the status column.

Q14

Single Choice

Given the table orders, which SQL query will return orders where the quantity is not equal to 10?

SQL Code

SELECT * FROM orders WHERE quantity ______ 10;

!= <> =Both A and B

In MySQL, both != and <> can be used to check for inequality.

Q15

Single Choice

What will the following MySQL query return?

SQL Code

SELECT name FROM products WHERE price <> 100 AND price <> 200;

Products with price equal to 100 or 200. Products with price exactly 100 and 200. Products with price different from both 100 and 200.Products with price either 100 or 200.

The query uses the <> operator to filter out products with a price of 100 and 200.

Q16

Single Choice

Which query will select rows where the column discount is not equal to zero?

SQL Code

SELECT * FROM sales WHERE discount ______ 0;

== != <>B and C

Both != and <> are valid operators in MySQL to filter out rows where discount equals zero.

Q17

Single Choice

Given the table student_scores with columns name and score, which query will return students who did not score 75 or 85?

SQL Code

SELECT name FROM student_scores WHERE score ______ 75 AND score ______ 85;

!= <> =, !=<>, <>

The correct query filters students who neither scored 75 nor 85 using the <> operator.

Q18

Single Choice

What does it return?

SQL Code

Analyze the following SQL query:
SELECT id FROM inventory WHERE stock != 0 AND stock != 10;

Items with stock exactly 0 or 10. Items with stock different from 0 and 10. Items with stock equal to 0 but not 10.Items with stock equal to 10 but not 0.

The != operator filters out items where stock is either 0 or 10.

Q19

Single Choice

Given a table transactions, which of the following SQL queries will list all transactions where the amount is not 500 or 1000?

SQL Code

SELECT * FROM transactions WHERE amount <> 500 AND amount <> 1000;

All transactions with amounts exactly 500 or 1000. All transactions with amounts different from both 500 and 1000. All transactions with amounts less than 500 or greater than 1000.All transactions with amounts greater than 500 or less than 1000.

The query filters transactions where the amount column is not equal to 500 or 1000 using the <> operator.

Q20

Single Choice

You have a table customers with a column age. Which query will return customers who are not exactly 18 years old?

SQL Code

SELECT * FROM customers WHERE age ______ 18;

!= <> =Both A and B

Both != and <> can be used in MySQL to filter out customers whose age is not exactly 18.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where 'department_id' is not equal to 3?

SQL Code

SELECT *
FROM employees
WHERE department_id <> 3;

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

The '<>' operator is used to filter rows where the 'department_id' column does not equal 3.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'orders' table where 'order_status' is not equal to 'Shipped'.

SQL Code

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

SELECT * FROM orders WHERE order_status != 'Shipped'; SELECT * FROM orders WHERE order_status <> 'Shipped'; SELECT * FROM orders WHERE order_status = 'Shipped';SELECT * FROM orders WHERE order_status IS NOT 'Shipped';

The '!=' operator filters rows where the 'order_status' column is not equal to 'Shipped'.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where 'category_id' is not equal to 10?

SQL Code

SELECT *
FROM products
WHERE category_id <> 10;

SELECT * FROM products WHERE category_id <> 10; SELECT * FROM products WHERE category_id != 10; SELECT * FROM products WHERE category_id = 10;SELECT * FROM products WHERE category_id IS NOT 10;

The '<>' operator is used to filter rows where the 'category_id' column is not equal to 10.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where 'country' is not equal to 'USA'.

SQL Code

SELECT *
FROM customers
WHERE country <> 'USA';

SELECT * FROM customers WHERE country <> 'USA'; SELECT * FROM customers WHERE country != 'USA'; SELECT * FROM customers WHERE country = 'USA';SELECT * FROM customers WHERE country IS NOT 'USA';

The '<>' operator filters rows where the 'country' column is not equal to 'USA'.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'quantity' is not equal to 100?

SQL Code

SELECT *
FROM inventory
WHERE quantity <> 100;

SELECT * FROM inventory WHERE quantity <> 100; SELECT * FROM inventory WHERE quantity != 100; SELECT * FROM inventory WHERE quantity = 100;SELECT * FROM inventory WHERE quantity IS NOT 100;

The '<>' operator is used to filter rows where the 'quantity' column is not equal to 100.

Q26

Multiple Choice

Which query correctly retrieves records from the 'sales' table where 'total_sales' is not equal to 5000?

SQL Code

SELECT *
FROM sales
WHERE total_sales != 5000;

SELECT * FROM sales WHERE total_sales != 5000; SELECT * FROM sales WHERE total_sales <> 5000; SELECT * FROM sales WHERE total_sales = 5000;SELECT * FROM sales WHERE total_sales IS NOT 5000;

The '!=' operator filters rows where the 'total_sales' column is not equal to 5000.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'transactions' table where 'transaction_amount' is not equal to 100.

SQL Code

SELECT *
FROM transactions
WHERE transaction_amount <> 100;

SELECT * FROM transactions WHERE transaction_amount <> 100; SELECT * FROM transactions WHERE transaction_amount != 100; SELECT * FROM transactions WHERE transaction_amount = 100;SELECT * FROM transactions WHERE transaction_amount IS NOT 100;

The '<>' operator is used to filter rows where 'transaction_amount' is not equal to 100.

Q28

Multiple Choice

Which SQL query retrieves records from the 'projects' table where 'budget' is not equal to 50000?

SQL Code

SELECT *
FROM projects
WHERE budget <> 50000;

SELECT * FROM projects WHERE budget <> 50000; SELECT * FROM projects WHERE budget != 50000; SELECT * FROM projects WHERE budget = 50000;SELECT * FROM projects WHERE budget IS NOT 50000;

The '<>' operator is used to filter rows where the 'budget' column is not equal to 50000.

Q29

Multiple Choice

Identify the correct query that retrieves records from the 'clients' table where 'revenue' is not equal to 200000.

SQL Code

SELECT *
FROM clients
WHERE revenue != 200000;

SELECT * FROM clients WHERE revenue != 200000; SELECT * FROM clients WHERE revenue <> 200000; SELECT * FROM clients WHERE revenue = 200000;SELECT * FROM clients WHERE revenue IS NOT 200000;

The '!=' operator is used to filter rows where the 'revenue' column is not equal to 200000.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'students' table where 'marks' are not equal to 85?

SQL Code

SELECT *
FROM students
WHERE marks <> 85;

SELECT * FROM students WHERE marks <> 85; SELECT * FROM students WHERE marks != 85; SELECT * FROM students WHERE marks = 85;SELECT * FROM students WHERE marks IS NOT 85;

The '<>' operator is used to filter rows where 'marks' are not equal to 85.

MySQL Database Quiz Questions