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