Free 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 Name, Email FROM Employees;

  • SELECT * FROM Employees WHERE Department = 'Sales';

  • SELECT Name, Email FROM Employees WHERE Department = 'Marketing';

This question's topic:
CompTIA ITF+ FC0-U61 / 
Database Fundamentals
Your Score:

Check or uncheck an objective to set which questions you will receive.