How does a view enhance data security in a DB2 database?
- Views automatically optimize database queries
- Views encrypt the data stored in the database
- Views provide a backup of the entire database
- Views restrict access to specific columns or rows of a table
Views in DB2 restrict access to specific columns or rows of a table, thus enhancing data security by only allowing authorized users to see limited portions of the data. This helps in controlling access to sensitive information and ensures data privacy.
Loading...
Related Quiz
- The CASCADE option in a FOREIGN KEY constraint in DB2 performs ________.
- What are the benefits of using indexes with INCLUDE columns in DB2?
- DB2 manages encryption keys for encrypted data through ________.
- When using the SUM() function in DB2, NULL values in the column are ________ in the calculation.
- Which of the following is a potential drawback of denormalization?