Chapter 12 Study Questions Flashcards
A(n) ____ consists of a SELECT statement that is stored as an object in a database. It behaves like a virtual table. It does not store any data.
view
Table(s) referenced in the SELECT statement for a view definition are called ___________.
base tables
A view can also be referred to as a(n) _____________ because it provides a view to the underlying base table(s).
viewed table
___________________ is the benefit or advantage provided by views that is described as limiting the exposure of tables to external users and applications.
Design independence
The benefit of _____________ describes that views can restrict access to the data in a table by using the select clause to include only selected columns of a table, or by using the where clause to include only selected rows in a table.
data security
____________________ is view benefit because views can be used to hide the complexity of retrieval operations.
simplified queries
The view benefit termed ____________ means with certain restrictions, views can be used to update, insert, and delete data from a base table.
updatability
A view that is biased on another view rather than on a [base] table is known as a ____________.
nested view
A(n) ______________ is a view that can be used in an INSERT, UPDATE, or DELETE statement to update data in base table.
updatable view
If a view is not updatable, it is called a(n) _____________.
read-only view
If the ________________ clause is not included when creating a view, a change made through the view can cause modified rows to no longer be included in the view.
with check option
If a __________________clause is specified when creating a view, an error will occur should there be an attempt to modify a row in such a way that it would no longer be included in the view.
with check option
To alter a view, use the ______________________ statement to replace an existing view with a new one.
create or replace view
The ______ statement issued to delete a view from the database.
delete
