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