CompTIA ITF+ FC0-U61 Practice Question
In a company's employee database, there is a table named 'Employees' that includes fields such as 'ID', 'Name', 'Department', and 'Email'. You are asked to retrieve a list of the names and email addresses of all employees who work in the 'Marketing' department. Which query would you use to accomplish this task?
SELECT Department FROM Employees WHERE Name = 'Marketing';
SELECT * FROM Employees WHERE Department = 'Sales';
SELECT Name, Email FROM Employees;
SELECT Name, Email FROM Employees WHERE Department = 'Marketing';
CompTIA ITF+ FC0-U61
Database Fundamentals
Your Score:
SAVE $17
Bash, the Crucial Exams Chat Bot
AI Bot