Unit 4

Question 1

If you delete a stored procedure, function, or trigger and then create it again

Answer 1

you delete the security permissions assigned to the object

Question 2

Unlike most database objects, when you invoke a user-defined function, you must always preface the name of the function with the

Answer 2

schema name

Question 3

You can invoke a table-valued user-defined function

Answer 3

anywhere you’d refer to a table or a view

Question 4

A user-defined function

Answer 4

can return a single scalar value or a single table value

Question 5

Table-valued functions are one of the most useful extensions provided by Transact-SQL because they behave like views but can accept parameters that can change the result set.

Answer 5

True

Question 6

If you want to prevent users from examining the SQL code that defines a procedure, function, or trigger, you code the CREATE statement with the ________________ option

Answer 6

ENCRYPTION

Question 7

Before you can pass a table to a stored procedure or a function as a parameter, which statement do you use to create a user-defined table type?

Answer 7

CREATE