Ch 13

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

Base

To delete an existing view, you use which statement?

DROP VIEW

To select the columns for a view, you would use what?

Diagram Pane

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

SELECT

You can use what to create or modify a view in SQL Server Management Studio?

View Designer

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

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

A view

all of the above

The WITH SCHEMABINDING clause

both b and c

By default,

columns in a view are given the same names as the columns in the base tables

The WITH CHECK option of the CREATE VIEW statement

prevents an update from being performed through the view if it causes a row to no longer be included in the view

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

system catalog

The statement CREATE VIEW Example1ASSELECT VendorName, SUM(InvoiceTotal) AS SumOfInvoicesFROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorIDGROUP BY VendorName ORDER BY VendorName;

will fail because the ORDER BY clause isn't allowed in this view

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

will fail because the SELECT statement returns two columns named VendorID

The statement CREATE VIEW Example2 AS SELECT InvoiceNumber, DATEDIFF(day,InvoiceDate,InvoiceDueDate) FROM Invoices;

will fail because the second column isn't named