Database Management Systems – Multiple Choice Questions (MCQs)

1. 25. Which SQL command is used to add new data to a database?

   • A. SELECT
   • B. INSERT
   • C. UPDATE
   • D. DELETE

2. 26. Which SQL command is used to modify existing data in a database?

   • A. SELECT
   • B. INSERT
   • C. UPDATE
   • D. DELETE

3. 27. Which SQL command is used to remove data from a database?

   • A. SELECT
   • B. INSERT
   • C. UPDATE
   • D. DELETE

4. 28. Which SQL clause is used to specify the table(s) to retrieve data from?

   • A. WHERE
   • B. FROM
   • C. ORDER BY
   • D. GROUP BY

5. 29. Which SQL clause is used to filter the rows returned by a query?

   • A. WHERE
   • B. FROM
   • C. ORDER BY
   • D. GROUP BY

6. 30. Which SQL clause is used to sort the rows returned by a query?

   • A. WHERE
   • B. FROM
   • C. ORDER BY
   • D. GROUP BY

7. 31. Which SQL clause is used to group rows with the same values in one or more columns into a summary row?

   • A. WHERE
   • B. FROM
   • C. ORDER BY
   • D. GROUP BY

8. 32. Which SQL aggregate function calculates the average of values in a column?

   • A. COUNT()
   • B. SUM()
   • C. AVG()
   • D. MAX()

9. 33. Which SQL aggregate function counts the number of rows?

   • A. COUNT()
   • B. SUM()
   • C. AVG()
   • D. MIN()

10. 34. Which SQL aggregate function calculates the sum of values in a column?

    • A. COUNT()
    • B. SUM()
    • C. AVG()
    • D. MAX()

11. 35. Which SQL aggregate function finds the maximum value in a column?

    • A. COUNT()
    • B. SUM()
    • C. AVG()
    • D. MAX()

12. 36. Which SQL aggregate function finds the minimum value in a column?

    • A. COUNT()
    • B. SUM()
    • C. AVG()
    • D. MIN()