Database Development 2 - Assessment 10

All of the system objects that define a database are stored in

A system catalog

Which statement do you use to modify an existing view?

ALTER VIEW

You can code views that: a. join tables b. summarize data c. use subqueries and functions d. all of the above

All the above

Which statement do you use to delete an existing view?

DROP VIEW

Which of the following should you use to select the columns for a view in the View Designer?

Diagram pane

A view is a/an ________________ statement that's stored as an object in the database

SELECT

Which of the following should you use to view the code that's generated for a view in the View Designer?

SQL pane

Each of the following is a benefit provided by using views except for one. Which one is it?

You can create a view that simplifies data insertion by hiding a complex INSERT statement within the view.

A table that's used to create a view is called

a base table

The WITH SCHEMABINDING clause of the CREATE VIEW statement

a. protects the view by binding it to the database schema b. prevents the tables that the view is based on from being deleted c. prevents the tables that the view is based on from being modified in a way that affects the view d. all of the above

A view a. is like a virtual table b. consists only of the rows and columns specified in its CREATE VIEW statement c. doesn't store any data itself d. all of the above

all of the above

The SELECT statement for a view

can use the ORDER BY clause if it also uses the TOP clause

The statement CREATE VIEW Example4ASSELECT *FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal - PaymentTotal - CreditTotal > 0;

d. will fail because the SELECT statement returns two columns named VendorID

The WITH ENCRYPTION clause of the CREATE VIEW statement

prevents users from seeing the code that defines the view

The statement CREATE VIEW Example3 AS SELECT *FROM Invoices;

will create an updatable view