70-761 Query Practice Questions

1. A database administrator needs to find all employees with the same job title as "Manager". Which query would correctly filter this data?

• AA. SELECT * FROM Employees;
• BB. SELECT * FROM Employees WHERE JobTitle != 'Manager';
• CC. SELECT * FROM Employees WHERE JobTitle IS NOT NULL;
• DD. SELECT * FROM Employees WHERE JobTitle = 'Manager';

3. You need to write a query that retrieves customer names but excludes any customers who have not made a purchase. Which query would achieve this?

• AA. SELECT CustomerName FROM Customers;
• BB. SELECT CustomerName FROM Customers WHERE Purchases > 0;
• CC. SELECT CustomerName FROM Customers WHERE Purchases IS NOT NULL;
• DD. SELECT DISTINCT CustomerName FROM Customers;

6. You need to retrieve the names of employees who have not completed mandatory training. Which query should you use?

• AA. SELECT Name FROM Employees;
• BB. SELECT Name FROM Employees WHERE TrainingCompleted = 1;
• CC. SELECT Name FROM Employees WHERE TrainingCompleted = 0;
• DD. SELECT Name FROM Employees WHERE TrainingCompleted IS NULL;

11. To find customers who bought more than 10 items, which query would be appropriate?

• AA. SELECT CustomerID FROM Sales GROUP BY CustomerID HAVING COUNT(ItemID) > 10;
• BB. SELECT CustomerID FROM Sales WHERE COUNT(ItemID) > 10;
• CC. SELECT CustomerID FROM Sales GROUP BY CustomerID;
• DD. SELECT DISTINCT CustomerID FROM Sales;