engineering computer science MCQ #700

What is the result of the SQL query: SELECT * FROM employees WHERE department = 'Sales' OR department = 'Marketing'?

engineering computer science MCQ #700

  1. Question 1

    Q1. What is the result of the SQL query: SELECT * FROM employees WHERE department = 'Sales' OR department = 'Marketing'?

    • A) Employees in the Sales department
    • B) Employees in the Marketing department
    • C) Employees in both Sales and Marketing departments
    • D) Employees in either Sales or Marketing department

    Answer: Employees in either Sales or Marketing department

    Explanation: The OR operator returns rows that satisfy either condition, so the query returns employees in either the Sales or Marketing department.