Materialized view is a temporary table that is stored in the database to represent a view, which is maintained as the base table(s) are updated. Advantages - may be faster than trying to perform view resolution. - may also be useful for integrity checking and query optimisation.

What will be an ideal response?

Discretionary – each user is given appropriate access rights (or privileges) on specific database
objects.
Mandatory – each database object is assigned a certain classification level (e.g. Top Secret,
Secret, Confidential, Unclassified) and each subject (e.g. user, application) is given a designated
clearance level (Top Secret > Secret > Confidential > Unclassified).
SQL security mechanism is based on discretionary access control.