Test: SQL Server - 1 - Software Development MCQ

A collection of tables

A programming language

A graphical user interface

A network protocol

To enforce data integrity

To improve query performance

To define relationships between tables

To restrict access to certain data

UPDATE

DELETE

INSERT

SELECT

UPDATE

DELETE

INSERT

SELECT

Structured Query Language

Sequential Query Language

Structured Question Language

Sequential Question Language

The total number of employees in the Employees table.

The number of employees whose DepartmentID is NULL.

The number of unique values in the DepartmentID column.

The number of employees with the last name "Employees".

The first and last names of all customers.

The first and last names of customers from New York.

The first names of customers from New York.

The last names of customers from New York.

The average unit price of all products.

The average unit price of products with units in stock.

The average unit price of products with a specific product ID.

The average unit price of products with a specific product name.

The maximum total amount for all orders.

The maximum total amount for orders placed after January 1, 2022.

The maximum total amount for orders with a specific order ID.

The maximum total amount for orders with a specific customer ID.

The last names and first names of employees in ascending order of last name and descending order of first name.

The last names and first names of employees in descending order of last name and ascending order of first name.

The last names of employees in ascending order.

The first names of employees in descending order.

SELECT COUNT() AS TotalStudents, CourseID FROM Students GROUP BY CourseID;

SELECT COUNT() AS TotalStudents, CourseID FROM Students WHERE Grade IS NOT NULL GROUP BY CourseID;

SELECT COUNT(DISTINCT StudentID) AS TotalStudents, CourseID FROM Students GROUP BY CourseID;

SELECT COUNT(DISTINCT StudentID) AS TotalStudents, CourseID FROM Students WHERE Grade IS NOT NULL GROUP BY CourseID;

SELECT * FROM Employees WHERE DepartmentID IN (SELECT DepartmentID FROM Employees GROUP BY DepartmentID HAVING COUNT() = (SELECT MAX(COUNT()) FROM Employees GROUP BY DepartmentID));

SELECT * FROM Employees WHERE DepartmentID IN (SELECT DepartmentID FROM Employees GROUP BY DepartmentID HAVING COUNT() = MAX(COUNT()));

SELECT * FROM Employees WHERE DepartmentID IN (SELECT DepartmentID FROM Employees GROUP BY DepartmentID HAVING COUNT() = MAX(SELECT COUNT() FROM Employees GROUP BY DepartmentID));

SELECT * FROM Employees WHERE DepartmentID IN (SELECT DepartmentID FROM Employees GROUP BY DepartmentID HAVING COUNT() = (SELECT MAX(COUNT()) FROM Employees));

SELECT CustomerID FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders);

SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING SUM(TotalAmount) = (SELECT MAX(SUM(TotalAmount)) FROM Orders GROUP BY CustomerID);

SELECT CustomerID FROM Orders WHERE TotalAmount = MAX(SELECT MAX(TotalAmount) FROM Orders GROUP BY CustomerID);

SELECT CustomerID FROM Orders WHERE TotalAmount = (SELECT MAX(SUM(TotalAmount)) FROM Orders GROUP BY CustomerID);

SELECT COUNT() AS TotalEmployees, DepartmentID FROM Employees GROUP BY DepartmentID;

SELECT COUNT() AS TotalEmployees, DepartmentID FROM Employees WHERE DepartmentID IS NOT NULL GROUP BY DepartmentID;

SELECT COUNT(DISTINCT EmployeeID) AS TotalEmployees, DepartmentID FROM Employees GROUP BY DepartmentID;

SELECT COUNT(DISTINCT EmployeeID) AS TotalEmployees, DepartmentID FROM Employees WHERE DepartmentID IS NOT NULL GROUP BY DepartmentID;

SELECT AVG(TotalAmount) AS AverageAmount, YEAR(OrderDate) AS OrderYear FROM Orders GROUP BY YEAR(OrderDate);

SELECT AVG(TotalAmount) AS AverageAmount, EXTRACT(YEAR FROM OrderDate) AS OrderYear FROM Orders GROUP BY EXTRACT(YEAR FROM OrderDate);

SELECT AVG(TotalAmount) AS AverageAmount, DATEPART(YEAR, OrderDate) AS OrderYear FROM Orders GROUP BY DATEPART(YEAR, OrderDate);

SELECT AVG(TotalAmount) AS AverageAmount, YEAR(GETDATE()) AS OrderYear FROM Orders GROUP BY YEAR(GETDATE());