- George needs to write a view that can return one or more customers from a table given a last name or part of a last name. Which of the following strategies will allow him to do that?
   Write a SELECT statement that references the view. Use the WHERE clause in the SELECT statement to filter the data.

- Given the following partial function definition, which SET statement shown below would correctly accept the returned value?
create function Area (l1 int, l2 int) returns int
   set @A = dbo.area(5, 4)

- Given the following partial function definition, which SET statement shown below would correctly accept the returned value?
create function Area (l1 int, l2 int) returns int
   set @A = area(5,4)

- Given the following piece of a stored procedure definition, which of the following EXEC statements will correctly call the stored procedure and retrieve the output value into the variable @OutputValue?
create procedure TestProc1 ( @i int, @j char(20), @k int output) as
   exec Testproc 1, 2, @OutputValue OUTPUT