You need to create a stored procedure that passes in a person’s name and age.
Which statement should you use to create the stored procedure?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
given the syntax of CREATE PROCEDURE it should be B as nvarchar in C stores unicode which really isn’t applicable to a name
https://technet.microsoft.com/en-us/library/ms187926(v=sql.105).aspx
0
0
It would not be B unless you want to store only a single character as the username. The type “nvarchar” is fine for a username since it supports UTF-8 encoded characters.
0
0
D.
0
2
Answer is C
6
0