SQL 4 – Quiz | Divex Consult

1. Which SQL function is used to count the number of rows in a table? *

A) SUM()

B) COUNT()

C) TOTAL()

D) ADD()

2. What does the following SQL query return?
SELECT COUNT(*) FROM Orders WHERE Status = 'Shipped'; *

A) The total number of orders in the Orders table

B) The number of customers who have placed orders

C) The number of orders that have been shipped

D) The sum of all shipped orders

3. What does the SUM() function do? *

A) Counts the total number of records in a table

B) Adds up the values in a specified column

C) Returns the highest value in a column

D) Returns the average value in a column

4. What will this query return?
SELECT SUM(Total_Amount) FROM Orders WHERE Status = 'Delivered'; *

A) The number of delivered orders

B) The total amount of all orders

C) The total revenue from delivered orders

D) The number of customers with delivered orders

5. What does AVG() do in SQL? *

A) Returns the total sum of a column

B) Finds the middle value in a dataset

C) Finds the lowest value in a column

D) Returns the average value of a numeric column

6. What will this query return?
SELECT AVG(Price) FROM Products WHERE Category = 'Laptops';
Answer: C *

A) The total price of all laptops

B) The lowest price of a laptop

C) The average price of all laptops

D) The number of laptops in stock

7. Why do we use GROUP BY in SQL? *

A) To filter records based on conditions

B) To group rows that have the same values in specified columns

C) To combine duplicate rows into one row

D) To sort the results in ascending order

8. What will this query return?
SELECT Category, COUNT(*) FROM Products GROUP BY Category; *

A) The number of products in each category

B) The total number of products

C) The total count of all products

D) The highest-priced product in each category

9. What is the purpose of the HAVING clause? *

A) It counts the number of unique values in a column

B) It is used to filter individual rows in a table

C) It changes the order of grouped results

D) It is used to filter groups based on aggregate functions

10. What will this query return?
SELECT Customer_ID, COUNT(Order_ID)
FROM Orders
GROUP BY Customer_ID
HAVING COUNT(Order_ID) > 5; *

A) Customers who have placed more than 5 orders

B) The total number of orders in the database

C) Orders where the quantity is more than 5

D) Customers who have placed exactly 5 orders

Structured Query Language(SQL)

SQL 4 – Quiz