quiz 5

1. Aggregation operators in SQL are used to perform calculations on _______________ data.

2. The _______________ operator in SQL calculates the sum of values in a numeric column.

grouped

3. To count the number of rows in a result set, you can use the _______________ operator.

4. The _______________ operator in SQL calculates the average (mean) value of a numeric column.

5. The _______________ operator returns the maximum value from a numeric column.

6. To find the minimum value in a numeric column, you can use the _______________ operator.

7. There are two main types of triggers: _______________ triggers and _______________ triggers.

8. Triggers can be associated with various database events, including _______________, _______________, DELETE, and DDL events.

9 Triggers are used to enforce data _______________, automate tasks, and ensure consistent actions in the database.

10. Triggers can calculate and populate _______________ values in tables.