Schemabinding

Question 1

What can you use SchemaBinding with?

Answer 1

Creating a view or function

Question 2

What does Schemabinding do?

Answer 2

Binds the structure of any underlying table or view

Question 3

You can not change ______ of a database with schemabound objects.

Answer 3

collation

Question 4

True or False?

You can use Select * in a schemabound view?

Answer 4

False

Question 5

True or False? You can make any change to the table that do not affect the structure of the schemabound columns.

Answer 5

True

Question 6

Where can you look to see if an object (Column or Function) is schemabound?

Answer 6

Column: is_schema_bound in sys.sql_modules
Function: OBJECTPROPERTY

Question 7

Objects that are bound (tables/views) can not be dropped while a schemabound object references them.
True or False

Answer 7

True

Question 8

if you reference a view or function in a schemabound view or function then that view or function must also be what?

Answer 8

Schemabound

Question 9

Schemabinding isn’t a commonly used tool unless you are setting up what?

Answer 9

An indexed view

Question 10

When you use schmabinding, the select_statement, there are three objects that can be referenced, what are they?

Answer 10

Tables
Views
User-defined functions

Question 11

True or False: when using schemabinding, all referenced objects must be in the same database?

Answer 11

True

Question 12

Views or tables that participate in a view created with the schemabinding clause can or cannot be dropped unless that view is dropped or changed so that it no longer has schemabinding?

Answer 12

Cannot

Question 13

List basic syntax order for creating a view with Schemabinding

5 Steps

Answer 13

CREATE VIEW
	WITH Schemabinding
AS
SELECT
FROM

Question 14

List basic syntax order for creating or altering a function with Schemabinding

4 Steps

Answer 14

CREATE or ALTER FUNCTION
RETURNS
WITH Schemabinding
AS

Question 15

True or False: Stored procedure can be schemabound?

Answer 15

False

Question 16

Schemabinding prevents ____ or _____ of any object on which the function depends?

Answer 16

Altering or dropping
Note: if a schema-bound function references a table, then columns may be added to the table, but no existing columns can be altered or dropped, and neither can the table itself.

Question 17

Indexed views must be created with which option?

Answer 17

With Schemabinding

Question 18

The Schemabinding option ensures that structural changes against referenced objects and columns will be what?

Answer 18

rejected

Question 19

What clause should you specify when creating a function that will ensure that the objects referenced in the function definition cannot be modified unless the function is also modified?

Answer 19

With Schemabinding

Question 20

True or False: When you use schmabinding, the select_statement must include two-part names that are referenced.

Answer 20

True