Which type of trigger fires once for each row affected

Which SQL function is used to calculate the average of a numeric column?

Which SQL feature allows hierarchical queries (e.g., org chart traversal)?

Which SQL keyword is used to eliminate duplicate rows in a query result?

In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?

Deadlock in DBMS can be prevented using:

Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?

A `BEFORE INSERT` trigger fires:

A materialized view differs from a normal view because it:

What is the primary purpose of a `SEQUENCE` in SQL?

Which SQL keyword removes duplicate rows automatically from results?