To answer this question, you need to understand the different types of security controls in the context of database management systems.
Option A) Detective - This option is incorrect. Detective controls are used to identify and detect security incidents or breaches after they have occurred. Database views do not specifically provide detective controls.
Option B) Corrective - This option is incorrect. Corrective controls are used to correct or mitigate the effects of a security incident or breach. Database views do not specifically provide corrective controls.
Option C) Preventive - This option is correct. Preventive controls are used to prevent or minimize the occurrence of security incidents or breaches. Database views can provide preventive security controls by restricting access to sensitive data and ensuring that only authorized users can view certain portions of the database.
Option D) Administrative - This option is incorrect. Administrative controls are related to the management and administration of the database system, such as user management, access control, and system configuration. While database views can be managed and administered administratively, they do not specifically provide administrative security controls.
The correct answer is C) Preventive. Database views provide preventive security controls by restricting access to sensitive data and ensuring that only authorized users can view certain portions of the database.