70-465 · Question #169
70-465 Question #169: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #169. The question stem and answer options stay visible for context.
Question
You have a database named DB1 that has the following: --- a Table named Customers that contains a list of customers ---- a table named Invoice that contains invoice information. There is foreign key relationship between Invoice and Customer. You need to create a stored procedure that will retrieve a list of all the invoice for a set of customers. The stored procedure must allow the caller to specify an unlimited list of customers. What should you use to create the stored procedure?
Options
- AAn optional parameter
- BA table-valued parameter
- CA nonclustered index
- DA Multiple active -result set(MARS)
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.