PrepAway - Latest Free Exam Questions & Answers

What are database views used for?

What are database views used for?

PrepAway - Latest Free Exam Questions & Answers

A.
To ensure referential integrity.

B.
To allow easier access to data in a database.

C.
To restrict user access to data in a database.

D.
To provide audit trails.

Explanation:
Through the use of a view we can provide security for the organization restricting users access to
certain data or to the real tables containing the information in our database. For example, we can
create a view that brings data from 3 tables, only showing 2 of the 4 columns in each. Instead of
giving access to the tables that contain the information, we give access to the view, so the user can
access this fixed information but does not have privileges over the tables containing it. This provides
security.


Leave a Reply