|
Answer» It provides security by restricting access to a predetermined set of rows or columns of a table. It HIDES data complexity. It SIMPLIFIES statements for the user. An example WOULD be the views, which allow users to select data from multiple tables without actually KNOWING how to perform a join. It presents the data in a different PERSPECTIVE from that of the base table. It isolate applications from changes in definitions of base tables. It saves complex queries. It provides security by restricting access to a predetermined set of rows or columns of a table. It hides data complexity. It simplifies statements for the user. An example would be the views, which allow users to select data from multiple tables without actually knowing how to perform a join. It presents the data in a different perspective from that of the base table. It isolate applications from changes in definitions of base tables. It saves complex queries.
|