Quiz for Logical Operators

Q1: Which logical operator returns true only if both conditions are true?

A. OR B. NOT C. XOR D. AND

Q2: Which SQL logical operator is used to combine multiple conditions that must all be true?

A. AND B. OR C. NOT D. BETWEEN

Q3: Which SQL logical operator is used to return true if either condition is true?

A. IN B. NOT C. AND D. OR

Q4: What does the NOT operator do in SQL?

A. Negates a condition B. Checks equality C. Joins tables D. Groups results

Q5: Which of the following SQL statements will return all rows except those where city is "Delhi"?

A. SELECT * FROM customers WHERE city = "Delhi"; B. SELECT * FROM customers WHERE NOT city = "Delhi"; C. SELECT * FROM customers WHERE city <> "Delhi"; D. Both B and C

Q6: Which of the following returns true only when all expressions are false?

A. OR B. XOR C. NOT OR D. AND

Q7: Choose the correct SQL syntax for using the AND operator.

A. SELECT * FROM employees WHERE age > 30 AND department = "HR"; B. SELECT * FROM employees WHERE age > 30 OR department = "HR"; C. SELECT * FROM employees WHERE age > 30 NOT department = "HR"; D. SELECT * FROM employees WHERE age > 30 BETWEEN department = "HR";

Q8: What will be the output if both conditions are false in an AND clause?

A. TRUE B. FALSE C. NULL D. ERROR

Q9: Which logical operator returns true only if one condition is true and the other is false?

A. XOR B. AND C. OR D. NOT

Q10: Identify the incorrect use of a logical operator.

A. SELECT * FROM customers WHERE NOT city = "Mumbai"; B. SELECT * FROM customers WHERE age > 25 AND salary < 50000; C. SELECT * FROM customers WHERE name OR "John"; D. SELECT * FROM customers WHERE NOT (age < 18);

Q11: Which operator is used to negate a Boolean condition?

A. AND B. NOT C. OR D. IN

Q12: What will the query return: SELECT * FROM orders WHERE NOT (status = "Pending" OR amount < 100);

A. Orders with status "Pending" and amount < 100 B. Orders with status "Pending" or amount < 100 C. Orders with status not "Pending" and amount >= 100 D. None of the above

Q13: Which operator is used to evaluate whether multiple conditions are true at the same time?

A. NOT B. OR C. AND D. XOR

Q14: Which clause is best suited to find records where a condition is not true?

A. IN B. LIKE C. NOT D. BETWEEN

Q15: What is the result of TRUE OR FALSE?

A. TRUE B. FALSE C. NULL D. ERROR

Q16: Which operator returns true only when both expressions are true?

A. AND B. OR C. NOT D. IS NULL

Q17: Which of the following is an example of combining logical operators?

A. SELECT * FROM table WHERE age > 20 AND city = "Pune"; B. SELECT * FROM table WHERE age > 20; C. SELECT * FROM table; D. SELECT name FROM table;

Q18: In SQL, what does this condition mean: age > 25 OR salary > 50000?

A. Both age and salary must be greater B. Only age must be greater C. Either age or salary must be greater D. Neither condition is needed

Q19: Which operator would you use to exclude a range of values?

A. BETWEEN B. IN C. NOT BETWEEN D. XOR

Q20: The NOT operator can be applied to which type of expressions?

A. Only numeric B. Only strings C. Any Boolean condition D. Only NULL checks

Q21: Which SQL query retrieves employees who are not in the Sales department and have salary greater than 50000?

A. SELECT * FROM employees WHERE department = "Sales" AND salary > 50000; B. SELECT * FROM employees WHERE NOT department = "Sales" AND salary > 50000; C. SELECT * FROM employees WHERE salary > 50000; D. SELECT * FROM employees WHERE NOT (department = "Sales") OR salary > 50000;