From among the given alternatives select the one in

A materialized view differs from a normal view because it:

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

ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:

Which SQL keyword prevents duplicate rows in result?

Which SQL command is used to remove a table completely?

What is an SQL `VIEW`?

Which SQL constraint ensures a column cannot have NULL values?

Materialized views differ from normal views because:

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?

Which type of trigger fires once for each row affected by the triggering DML statement?