Chapter 15 Quiz * Due Mar 26 at 6pm * Points 10 * Questions 10 * Available Mar 19 at 12am - Mar 26 at 6pm 8 days * Time Limit None
Attempt History | Attempt | Time | Score | LATEST | Attempt 1 | 36 minutes | 7 out of 10 |
Score for this quiz: 7 out of 10
Submitted Mar 19 at 11:58pm
This attempt took 36 minutes. Question 1
1 / 1 pts
Parameters for stored procedures and functions can be of any valid SQL Server data type except
Parameters for stored procedures and functions can be of any valid SQL Server data type except date/time
Correct!

table xml numeric Question 2
0 / 1 pts
Skip to question text.
Code a statement that calls the following stored procedure and passes the values ‘2011-12-01’ and 122 to its input parameters. Pass the parameters by name in the reverse order that they’re declared in the procedure.
CREATE PROC spInvoiceTotal1 @DateVar smalldatetime, @VendorID int
AS
SELECT SUM(InvoiceTotal)
FROM Invoices
WHERE VendorID = @VendorID AND InvoiceDate >= @DateVar;
______________________________________________________________________________
You Answered

Correct Answers
EXEC spInvoiceTotal1 @VendorID = 122, @DateVar = '2011-12-01';
EXEC spInvoiceTotal1 @VendorID = 122, @DateVar = '2011-12-01' Question 3
0 / 1 pts
Before you can pass a table to a stored procedure or a function as a parameter, you must use the ______________________ statement to create a user-defined table type.
Before you can pass a table to a stored procedure or a function as a parameter, you must use the ______________________ statement to create a user-defined table type.
You Answered

Correct Answers
CREATE TYPE Question 4
1 / 1 pts
Unless a database system supports declarative referential integrity, the only way to enforce referential integrity is