CompTIA Study Materials
AWS Study Materials
AWS Certified Developer Associate AWS Certified Developer Associate
AWS Certified Developer Associate DVA-C02
AWS Certified Solutions Architect Associate AWS Certified Solutions Architect Associate
AWS Certified Solutions Architect Associate SAA-C03
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

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

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

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

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

This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology