Chapter 13

Question 1

Which statement do you use to modify an existing view?

Answer 1

ALTER VIEW

Question 2

The WITH CHECK option of the CREATE VIEW statement

Answer 2

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

Question 3

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

Answer 3

Diagram pane

Question 4

One way to examine the system objects that define a database is to use

Answer 4

catalog views

Question 5

The statement

CREATE VIEW Example3
AS
SELECT *
FROM Invoices;

Answer 5

will create an updatable view

Question 6

A common table expression (CTE) creates a temporary _____________ that can be used by a query that follows.

Answer 6

table

Question 7

Which of the following can you use to create or modify a view in SQL Server Management Studio?

Answer 7

View Designer

Question 8

By default,

Answer 8

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

Question 9

The WITH SCHEMABINDING clause of the CREATE VIEW statement

Answer 9

protects the view by binding it to the database schema

prevents the tables that the view is based on from being deleted

prevents the tables that the view is based on from being modified in a way that affects the view

Question 10

A correlated subquery is one that

Answer 10

is executed once for each row in the outer query

Question 11

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

Answer 11

a system catalog

Question 12

Which statement do you use to delete an existing view?

Answer 12

DROP VIEW

Question 13

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

You can simplify data retrieval by hiding multiple join conditions.

You can provide secure access to data by creating views that provide access only to certain columns or rows.

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

You can create custom views to accommodate different needs.

Answer 13

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

Question 14

The SELECT statement for a view

Answer 14

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

Question 15

The statement

CREATE VIEW Example4
AS
SELECT *
FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0;

Answer 15

will fail because the SELECT statement returns two columns named VendorID

Question 16

The statement

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

Answer 16

will fail because the second column isn’t named

Question 17

The WITH ENCRYPTION clause of the CREATE VIEW statement

Answer 17

prevents users from seeing the code that defines the view

Question 18

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

Answer 18

SELECT

Question 19

The statement

CREATE VIEW Example1
AS
SELECT VendorName, SUM(InvoiceTotal) AS SumOfInvoices
FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID
GROUP BY VendorName
ORDER BY VendorName;

Answer 19

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

Question 20

The View Designer allows you to

Answer 20

display the results of a view

specify the selection criteria and sort order for a view

edit the design of an existing view

Question 21

A view

Answer 21

is like a virtual table

consists only of the rows and columns specified in its CREATE VIEW statement

doesn’t store any data itself

Question 22

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

Answer 22

SQL pane

Question 23

You can code views that

Answer 23

join tables

summarize data

use subqueries and functions

Question 24

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

Answer 24

a base table