Consist of a select statement that's stored as an object

Consist of a select statement that's stored as an object

consist of a select statement that's stored as an object in the database

 

·         view

 

the tables referenced in the select statement

 

·         base tables

 

another term for a view

 

·         viewed table

 

provides a view to the underlying base tables

 

·         viewed table

 

lists all of the system objects that define a database, including tables, views, columns, keys, and constraints

 

·         system catalog

 

the catalog view from which the columns are inherited

 

·         base view

 

 

the catalog view that inherits the columns

 

·         derived view

 

 

use the _____________ to examine the system dialog

 

·         catalog views

 

a benefit of views; if the database design changes, you can modify the view so the queries that use it don't need to be changed

 

·         design independence

 

a benefit of views; they can be used to limit access to the data that specific users are allowed to see

 

·         data security

 

a benefit of views; customer views can accommodate different data requirements

 

·         flexibility

 

a benefit of views; they can hide the complexity of retrieval options

 

·         simplified queries

 

a benefit of views; with some restrictions, they can be used to update data in a base table

 

·         updatability

 

a create view clause that keeps users from examining the SQL code that defines the view

 

·         with encryption

 

a create view clause that binds a view to the database schema and prevents you from dropping or modifying the tables on which the view is based

 

·         with schemabinding

 

a create view clause that prevents a row from being updated through a view if it would no longer be included in the view

 

·         with check option

 

name the columns in a view ___________ in the create view clause

 

·         after the view name

 

you must name __________ the columns

 

·         all

 

you can also name the columns in a view in the ________ clause

 

·         select

 

You must name a column if it's ___________

 

·         calculated from other columns

 

You must name a view if a column _____________ already exists

 

·         with the same name

 

a view that can be used in an insert, update, or delete statement to modify the contents of a base table that the view refers to

 

·         updatable view

 

if a view is not updatable, it's called a ____________

 

·         read-only view

 

the select list for an updatable view can't include a ________ or _______ clause

 

·         distinct, top

 

the select list for an updatable view can't include an _________ function

 

·         aggregate

 

the select list for an updatable view can't include a __________ value

 

·         calculated

 

the select statement for an updatable view can't include a _________ or __________ clause

 

·         group by, having

 

an updatable view can't include a ___________ operator

 

·         union

 

T/F: An updatable view can include a join statement

 

·         true

 

you can only use the delete table if the view statement is based on a _________

 

·         single table

 

to use the delete statement to delete rows from a base table, name the table in the ___________

 

·         delete clause